Processing, DBUTLTY and SQL Messages › CA Datacom/DB Processing Messages (DB0xxxxc) › DB00104I

DB00104I

CHKPT JOB-jjjjjjjj NUMBER-nnnnn TSN=xxxxxxxx

Reason:

A task, for which transaction backout is specified, is probably not issuing checkpoints frequently enough to permit the spills required to clear the Log Area. CA Datacom/DB forced an artificial checkpoint for this task, identified by run unit number nnnnn of job name jjjjjjjj with a TSN (transaction sequence number) of xxxxxxxx, so that the required spill could be accomplished.

Action:

Evaluate the program to determine whether it is issuing checkpoints as frequently as needed. If not, modify the program. If the program is issuing checkpoints at a reasonable rate, enlarge the Log Area as follows:

1. Stop the Multi-User Facility by using the EOJ option of the DBUTLTY COMM function or the related console command.
2. If using inactive recovery, execute the SPILL function to clean out the old Log Area.
3. Allocate and initialize the new Log Area with the INIT AREA=LXX function.
4. Execute DBMUFPR to initiate the Multi-User Facility with a new Log Area.