Backup Online db2 9.1

[alex250374]

Hello to all,

I do a backup of an online db and I changed from db cfg parameter logretain on recovery, then I made the backup full offline, what other parameters to be amended? especially I wonder how it should change the parameters logarchmeth1 / default 3)and 2 (default 2) and the path of arch logs so I created a special filesustem.

Thanks

[niladri123]

please set userexit = ON for the same database.

[alex250374]

Thanks for your answer,

what interests me most is the operating parameters logprimary (3) and logsecond (2). How many log files are stored in total? After some time the file is filled and those older must move them by hand?

[docdiesel]

Hi,

DB2 is only holding the number of LOGPRIMARY log files at runtime. Only if their space is exceeded, DB2 creates up to LOGSECOND additional log files which allows some more space for logging but also costs some time for creation of these files. DB2 is also handling the primary and secondary log files automatically.

Regards,

Bernd