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