DB2 9.5 backup using archive logging

AlanAyala

ADSM.ORG Member
Joined
Feb 20, 2007
Messages
61
Reaction score
0
Points
0
AIX5.3
TSM Client 5.4.1.2
DB2 9.5

What do I need to configure to backup db2 database logs within the databases?

Do I need to configure user exit?

Full backups of the databases have been made, i dont know if the logs were backed up too within the databases.

Best Regards,

Alan
 
db2 update cfg SID logarchmeth1 TSM (goes into backup pending mode)
stop db2
backup database (offline backup)
start db2 ( goes out of backup pending and into roll forward )

Now it will archive logs to TSM.
If thats already done just do the below to backup logs with backups

db2 backup db SID online inlcude logs use tsm
( backup logs with the backup )

Use db2adutl commands to query logs and backups.

You can also do
db2 archive logs use tsm ( check syntax but similar )
 
Back
Top