Monday, July 20, 2009

CloudScape / DB2 Error - Database has exceeded largest log file number 4,194,303

When using Tivoli Directory Integrator to convert and integrate different sources of data, I encountered the following error :-
ERROR XSLAK: Database has exceeded largest log file number 4,194,303.
at db2j.de.b.newException(Unknown Source)
at db2j.ci.g.qm_(Unknown Source)
at db2j.ci.g._t6(Unknown Source)
at db2j.ci.g.checkpoint(Unknown Source)
at db2j.ci.g.recover(Unknown Source)

The appropriate solution that I found was simply increase the max file log id which is detailed in this article, http://osdir.com/ml/apache.db.derby.devel/2005-05/msg00685.html
However with little knowledge of cloudscape and integrator, and much more importantly little patience - I went with a more aggressive approach. Within the ./CloudScape/log directory which contains the log files -
log4194300.dat
log4194301.dat

log4194302.dat
I removed these dat files and restarted the TDI job. Voila! The job kicked off successfully and produced the resulting xml file (or whatever output file) correctly.

NOTE: I left the following files untouched
logmirror.ctrl
log.ctrl

No comments:

Post a Comment