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.

Note: If the connection by the application to the CA Datacom/DB MUF is not successful, it is possible to see this message with a value of 0 for NUMBER representing the run unit.

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 either the EOJ, EOJKEEP, or EOJFREE option of the DBUTLTY COMM function or the related console command: COMM EOJ, COMM EOJKEEP, or COMM EOJFREE. (EOJKEEP and EOJFREE are for z/OS only.)
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.