Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2008
    Posts
    6

    Unanswered: Archive queue is full

    Hi,

    we got this error message "Archive queue is full.
    DB2 will not call userexit program for this database for 5 minutes"

    we fixed this by stoping the services and started the services (DB2 v7 on Windows). But how can we prevent this in future?
    Please advise

    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the entire error message you are getting?

    You should also consider upgrading your DB2 version. V7 went out of service several years ago, and V8 is about to go out of service early next year.

    Andy

  3. #3
    Join Date
    Sep 2008
    Posts
    6
    Following is the entire message

    Archive queue is full.
    DB2 will not call userexit program for this database for 5 minutes.

    2008-09-24-01.28.26.984000 InstanceB2 Node:000
    PID:1904(db2syscs.exe) TID:2220 Appid:*LOCAL.DB2.080924050626
    database_utilities sqlubcka Probe:0 Database:AEVAL

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Are there any messages in db2diag.log that indicate that the logs are being successfully archived?

    Andy

  5. #5
    Join Date
    Sep 2008
    Posts
    6
    I didn't see any messages like logs are being successfully archived, but i saw one file in archived folder with todays date. I saw may of the following messages with yesterday date
    "User Exit returned error when archiving log file S0008629.LOG from D:\DB2\NODE0000\SQL00002\SQLOGDIR\ for database AE, error code 8"

    Thanks

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by purushotham
    "User Exit returned error when archiving log file S0008629.LOG from D:\DB2\NODE0000\SQL00002\SQLOGDIR\ for database AE, error code 8"

    Thanks
    This indicates that log files are not being archived. You need to fix the situation.

    Andy

Posting Permissions

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