Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2011
    Posts
    4

    Unanswered: backup database $DB online use tsm "include logs ???"

    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

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Check db2diag.log

  3. #3
    Join Date
    Nov 2011
    Posts
    4

    DB2 backup with "include logs" ???

    Quote Originally Posted by nvk@vhv View Post
    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

  4. #4
    Join Date
    Jan 2010
    Posts
    335
    I've entries like these during backup:

    2011-11-17-02.34.00.938594+060 I7382E444 LEVEL: Warning
    PID : 24617 TID : 47888419776848PROC : db2sysc 0
    INSTANCE: ijbpmprd NODE : 000
    EDUID : 23 EDUNAME: db2logmgr (JBPM_PRD) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogFile, probe:4148
    MESSAGE : Completed retrieve for log file S0003054.LOG on chain 9 to
    /var/db2luw/IJBPMPRD/JBPM_PRD/tlog/NODE0000/.
    Logfiles were retrieved from archive to add them to the Backup.

  5. #5
    Join Date
    Nov 2011
    Posts
    4

    DB2 Backup : Logs saved or not

    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

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •