var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Archive queue is full
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?
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.
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 Instance B2 Node:000
PID:1904(db2syscs.exe) TID:2220 Appid:*LOCAL.DB2.080924050626
database_utilities sqlubcka Probe:0 Database:AEVAL
Are there any messages in db2diag.log that indicate that the logs are being successfully archived?
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"
This indicates that log files are not being archived. You need to fix the situation.
Originally Posted by