Unanswered: Advices Required " how to save archive log files"
I am completely new to DB2 database adminsitration as i came from Progress DBA background ....
Here i have Five DB2 instances running on different AIX servers. Solution also comprised of TSM and my earlier DB2 DBA was taking so called " Online Db2 backup " using tsm.
I reviewed the info on web and found that userexit should be ON , if you want to take backups of archive log files to TSM. In our case, following are DB2 parameters:
Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0000783.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Percent of max active log space by transaction(MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = OFF
Auto restart enabled (AUTORESTART) = ON
Index re-creation time (INDEXREC) = SYSTEM (RESTART)
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 10
Recovery history retention (days) (REC_HIS_RETENTN) = 366
I have also checked in TSM config and found db2mgtclass is pointing to one tape storage pool in TSM Server.
Now it seems from above configuration , that userexit is off so it means that earlier they are just taking online backups of Db2 database ( but not backing up archive log files to TSM which are very important for DB recovery.. Please correct me if i am wrong in understanding ....)
SO What should be done now to backup archive log files also to tapes.. I am not interested in using userexit & TSM integration as it will require TSM advance skills which i dont have!!!
Can i write a shell script on Unix which simply moves new archive log files from production Server to another server automatically as new archive files are created ( from where it is backed up to TSM or to some other tape drive )???? please advice
This script can be run on every let's say two minutes interval on Production Server!!
I will recommend using TSM for log archiving using USEREXIT ...
hmm .. ok... if you say you cannot use TSM directly, then create a filesystem and a directory for the archive log files ...
Use the db2uext2.cdisk program to archive the log files to the archive directory you created above.
Backup the directory to TSM every day (or preferably more often, depending on the rate of archiving) .. Moving to TSM will eliminate the risk loosing arcchived logfiles in case of disk failure ...
You'll have to make sure that the archive logs files copied to TSM are retained atleast as long as the related backups ...
When you need a restore and rollforward, a manual copy of the files from TSM to the disk will be required ...
BTW, did you know that the backup also can be written directlry to TSM?
Visit the new-look IDUG Website , register to gain access to the excellent content.
Advices Required " how to backup archive log files"
First of all many thanks for giving me such good advices !!!
Now returning to main question... infact the DB2 version is 8.1...
As far as writing log files directly to TSM is concerned , i am hesitating because i have to go in depth for TSM also ( as in this my new company , there is no one to look after TSM aslo.. unfortunately )...and i want to backup these archive log files to tapes as soon as possible.
What if , i use AIX rdist utility in shell script ( which compares two directories and copies files from one directory to another , on same or different server ) to push archive log files to another server as soon as they are formed and then use simple TSM archive function to archive these log files to tape.
I look forward to have your advices and opinion on this idea....