Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Wink Unanswered: Database Archive log error

    Hi experts,

    I have configured archieve logging. But the logs are not moved to my arhieve log location automatically.

    The command i used to enable archive logging.

    db2 update db cfg for reporter using logarchmeth1 disk:/OBJ_DATA/OMNITDW/Archive_Log_reporter
    update db cfg for reporter using LOGRETAIN YES
    update db cfg for reporter using USEREXIT ON
    update db cfg for reporter using LOGBUFSZ 4096
    update db cfg for reporter using LOGprimary 100
    update db cfg for reporter using LOGsecond 50



    Help me as what would be the issue why logs are not moved to the path.

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Check
    logarchmeth1 - Primary log archive method configuration parameter - IBM DB2 9.7 for Linux, UNIX, and Windows
    ->
    2. If you update the userexit or logretain configuration parameters logarchmeth1 will automatically be updated and vice versa. However, if you are using either userexit or logretain, logarchmeth2 must be set to OFF.

    What setting do you have for logarchmeth1? If you issued the commands in the given order logarchmeth1 is USEREXIT. Do you have a userexit program?
    I'ld recommend to just update logarchmeth1 and don't update LOGRETAIN and USEREXIT. If you set logarchmeth1, then LOGRETAIN will be set automatically.

    Also if you set logarchmeth1 for the first time the databases needs to be deactivated and you have to take an offline backup of the database.

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Thanks nvk.

    As it was a permission issue. which the log path was owned by root.

    now it is working...

Posting Permissions

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