Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2011
    Posts
    14

    Unanswered: old logs are pending for archive

    Hi,

    DB2 Version 9.7.0.7
    OS- AIX 6.1.0.0

    few logs generated with a day old are pending for archive. due to this log dir is getting heated. Currenly no secondary logs are in usage. pleae provide some suppport to get them archived.

    Regards,

  2. #2
    Join Date
    Oct 2008
    Posts
    82
    Please check wheteher archive log file system have enough space.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    please publish some details about current settings
    logging-archiving
    details about the problem...
    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

  4. #4
    Join Date
    Apr 2011
    Posts
    14
    There is enough space to survive , TSM parameters are same as earlier. i belive backup stg session at TSM causing this.

    Archive logging is default.

  5. #5
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    do you have an uncommitted thread that has been running for more than a day?

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2_dpf View Post
    few logs generated with a day old are pending for archive.
    How did you determine that?
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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