Results 1 to 7 of 7

Thread: archival logs

  1. #1
    Join Date
    Nov 2007
    Posts
    26

    Unanswered: archival logs

    Hi help me


    In our environment primary log file are not moving to archival log path

    due to that primary log path get 100% full

    i did db2stop and start

    i am unable to connect database also
    plese help me

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Prasad,
    Can you just paste the values you have assigned for LOGARCHMETH1.

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  3. #3
    Join Date
    Nov 2007
    Posts
    26
    hi

    logarchmeth1 DISK /<path >

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It should be "DISK:/path"

    Andy

  5. #5
    Join Date
    Nov 2007
    Posts
    26
    Hi all
    LOGRETAIN = Recovery
    (LOGARCHMETH1) = DISK:/udb/logs/db2odsq/archive/
    USEREXIT OFF
    there is enough space in arcival log

  6. #6
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Still you facing the same problem? Did you take a complete offline backup of the Database after activating these parameter and then a db2start of the Instance?

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  7. #7
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    Quote Originally Posted by prasadv18
    Hi all
    LOGRETAIN = Recovery
    (LOGARCHMETH1) = DISK:/udb/logs/db2odsq/archive/
    USEREXIT OFF
    there is enough space in arcival log

    Did you check whether you have enough rights to write to the above mentioned folder location???
    IBM Certified Database Associate, DB2 9 for LUW

Posting Permissions

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