Hi forum,
if you backup your DB2 database from command line by :

backup database ... online use tsm include logs

is there written a protocol anywhere which clearly shows that the logs too
have been saved ?

Thank you for your help.

OEggert2706

Check db2diag.log

In db2diag.log you can read things like this :

2011-11-17-08.02.25.219924+060 E10050548E421 LEVEL: Info
PID : 393 TID : 47052750842176PROC : db2sysc 0
INSTANCE: db2vmd NODE : 000 DB : VMD
APPHDL : 0-69 APPID: *LOCAL.db2vmd.111117070002
AUTHID : DB2VMD
EDUID : 791 EDUNAME: db2agent (VMD) 0
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:838
MESSAGE : Backup complete.


But nothing on the question whether logs were included or not.

Kind regards
OEggert2706

I've entries like these during backup:

Logfiles were retrieved from archive to add them to the Backup.

There are messages like the following :

MESSAGE : Started archive for log file S0000762.LOG.
MESSAGE : Completed archive for log file S0000762.LOG to TSM chain 4 from
MESSAGE : Started retrieve for log file S0000761.LOG.
MESSAGE : Completed retrieve for log file S0000761.LOG on chain 4 to
MESSAGE : Started archive for log file S0000763.LOG.
MESSAGE : Completed archive for log file S0000763.LOG to TSM chain 4 from
MESSAGE : Started retrieve for log file S0000763.LOG.
MESSAGE : Completed retrieve for log file S0000763.LOG on chain 4 to
MESSAGE : Started retrieve for log file S0000762.LOG.
MESSAGE : Completed retrieve for log file S0000762.LOG on chain 4 to

Does this mean that the logs have been saved ?

Kind regards
OEggert2706

Yes, if it happens at the end of an online backup.

Starting with v9.5, the logs are archived by default (online backup). If you want to be 100% sure the logs were included and can extract the image to disk, then you can use db2ckbkp to verify.