OnDemand User Group

Support Forums => MP Server => Topic started by: hyuzen on December 11, 2012, 12:38:44 AM

Title: SQL0964C
Post by: hyuzen on December 11, 2012, 12:38:44 AM

Hi all,

When I load AFP file to backup OnDemand system (OD MP V7.1.2.8 and DB2 V8.1.8.762) I received error below:

DB Error: [IBM][CLI Driver][DB2/NT] SQL0964C  The transaction log for the database is full.  
SQLSTATE=57011   -- SQLSTATE=57011, SQLCODE=-964, File=arsdoc.c, Line=4001

2012-12-10-13.38.28.348000   Instance:DB2   Node:000
PID:2004(db2syscs.exe)   TID:5896   Appid:*LOCAL.DB2.121202000628
data protection  sqlpgResSpace Probe:1660   Database:TCELLINV
ADM1822W  The active log is being held by dirty pages.  This is not an error,
but database performance may be impacted.  If possible, reduce the database
work load.  If this problem persists, either decrease the SOFTMAX and/or
increase the NUM_IOCLEANERS DB configuration parameters.

I checked db2 setting (get db cfg) of backup system with Prod system. Both of settings are same! If so why I received the error above only in the backup system ?

Thanks in advance,
Best Regards.
Huseyin

Title: Re: SQL0964C
Post by: Justin Derrick on December 11, 2012, 11:01:45 AM

I'd start by bringing down the database, and doing a full offline backup, and making sure your transaction logs are being properly archived.

Then I'd do what the error message recommends...  NUM_IOCLEANERS is one of the parameters that the CMOD developers have (in the distant past) recommended increasing.  My rule of thumb for increasing database parameters is to go in increments of 50% until the situation is resolved.  4 to 6, 6 to 9, 9 to 15, etc.

-JD.

Title: Re: SQL0964C
Post by: hyuzen on December 13, 2012, 11:39:23 PM

Thank you very much Justin,

Although configuration advisor suggests to set NUM_IOCLEANERS as 13 I set 18 by increasing %50. Then I loaded a few millions records with successfully.

Best regards,
Huseyin