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

    Red face Unanswered: Archive logs not getting Archived

    I have mentioned a specific path for Archive logs LOGARCHMETH1: But i see logs are getting stored in Active logs rather than moving to Archive log path.

    Also when i see diaglog I see this error.

    2011-10-05-16.03.35.281364+330 I4155814768G488 LEVEL: Warning
    PID : 9740 TID : 3086788288 PROC : db2logmgr (MAXDB71) 0
    INSTANCE: ctginst1 NODE : 000
    FUNCTION: DB2 UDB, data protection services, sqlpgRetryFailedArchive, probe:4780
    MESSAGE : Still unable to archive log file 1199 due to rc -2029060079 for
    LOGARCHMETH1 using method 1 and target
    /MAX_DATA/ctginst1/Archive_Log_Maximo/ctginst1/MAXDB71/NODE0000/C00000
    01/.


    I just understand it is unable to archive the log... But please suggest how to over come this..

    thanks !

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    is the path existing ? owned by instance owner ? write access ?
    what is the real value of LOGARCHMETH1
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Path is : /MAX_DATA/ctginst1/Archive_Log_Maximo/

    it is existing , owned by root, But full access to instance owner.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    what is the real value of LOGARCHMETH1 : not answered

    chown instanceowner:group /MAX....
    chmod 6.. for the same path
    in that case you have all authorization
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Now ownership also changed to instance owner...

    And LOGARCHMETH1
    (LOGARCHMETH1) = DISK:/MAX_DATA/ctginst1/Archive_Log_Maximo/

    ...

    i have a doubt ...

    if i take a backup of the DB then i can move the logs from Active logs to Archive log. will it work ?

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Quote Originally Posted by alwayssathya View Post
    if i take a backup of the DB then i can move the logs from Active logs to Archive log. will it work ?
    Which logs? Old logs that still remain in the active log dir because of the above error?

  7. #7
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Yes .. i still find the logs in Active log directory even after backup and they are not moved to Archive log directory.

  8. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    you have to find the origin of the error
    execute the command db2 archive log for db xxx
    check diaglog if done
    if error - investigate what is wrong with this filesystem/mount
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  9. #9
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    I ve executed the command it was successful,

    [ctginst1@WESSPMDB02 ~]$ db2 archive log for db maxdb71
    DB20000I The ARCHIVE LOG command completed successfully.
    [ctginst1@WESSPMDB02 ~]$


    Thanks it worked,

  10. #10
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    the answer is always as indicated : The ARCHIVE LOG command completed successfully.
    I indicated : check diaglog if done .. please do some debugging before.. and read the posts ..instead of coming back to the forum with each reply..
    I presume you are the dba and we are remote volunteers
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  11. #11
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    I got your point correctly,

    once i gave the command...it showed same error,
    Jus to confirm my permision i once again gave the ownership to instance owner. Then it worked... diaglog show archival was successfull....

Posting Permissions

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