Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: when userexit and logretain is on where archive log is stored?

    when I trun on logretain or userexit, where archived log is located? In the logpath directory ? and when archived log is erased ? when using backup database command to backup the database ?
    Thanks !

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: when userexit and logretain is on where archive log is stored?

    LOGRETAIN - maintains it in the active log directory
    USEREXIT - Does what your program says , which normally says to copy the logs to a different directory



    Cheers
    Sathyaram

    Originally posted by xiongye
    when I trun on logretain or userexit, where archived log is located? In the logpath directory ? and when archived log is erased ? when using backup database command to backup the database ?
    Thanks !
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2004
    Posts
    3

    Re: when userexit and logretain is on where archive log is stored?

    Originally posted by sathyaram_s
    LOGRETAIN - maintains it in the active log directory
    USEREXIT - Does what your program says , which normally says to copy the logs to a different directory



    Cheers
    Sathyaram
    which parameter control or where userexit copy logs file to ?

    when userexit copy it ?

    after backup database is successful ,the archived log is nolonger useful ?

    thanks again !

  4. #4
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513

    Re: when userexit and logretain is on where archive log is stored?

    Originally posted by xiongye
    which parameter control or where userexit copy logs file to ?

    when userexit copy it ?

    after backup database is successful ,the archived log is nolonger useful ?

    thanks again !
    The userexit is an executable written by you and added to the PATH... IBM only provides samples.

    The archived logs may still be useful, depending on how many backup revisions you keep, etc... but if you have a full offline backup that you trust 100% and you don't think you'll ever need to go further back, you don't need the archive logs from before it

    (For online, it's trickier, you need to use LIST HISTORY to find the logs the backup needs to get to a consistent state)
    --
    Jonathan Petruk
    DB2 Database Consultant

  5. #5
    Join Date
    Mar 2004
    Posts
    3
    The archived log is still in the "path to logfiles" directory even after backup , How can I deal with it ? just delete them ? Thanks !

  6. #6
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Originally posted by xiongye
    The archived log is still in the "path to logfiles" directory even after backup , How can I deal with it ? just delete them ? Thanks !
    Be VERY CAREFUL not to delete the active logs... use LIST HISTORY to see which logs are from the time of the backup, and only delete those older than that...
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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