With my ENF IMUF, I received an error message:
DBH6007E One or more CA Datacom/DB transactions have been force check pointed.
This was related to the Health Checker item DTCM_DB_FORCE_CHKPT@ENFMUF2
What do I need to do to address this?
Release : 15.0
Release : 15.1
Component : CA Datacom/AD
Component : CA Datacom/DB
Based on the name shown in the message, this message was produced on a MUF that supports the CA Common Services/ENF application. However, it can apply to any MUF, and this article will address all situations.
Several factors could lead to this Health Checker message, but the most common cause is that the Log Area (LXX) for this MUF is not large enough to handle the volume of updates being processed. If the MUF uses the LOGRCV NEVER MUF Startup Option, this MUF may not spill recovery records to an RXX to use for database recovery, but the LXX is still used for transaction backout processing, in the event that a currently-running, non-committed activity fails.
The explanation for this Health Check text says:
DBH6007E - One or more CA Datacom/DB transactions have been force check pointed. Explanation: One or more tasks for which transaction backout was specified, did not issue checkpoints (commits) frequently enough relative to the LXX's size. The LXX is DB's log.
If using MUF Startup Option LOGRCV NO, the RXXROLLBACK settings need to be reviewed to be sure that rollback processing is adequately managed for your MUF.
If using LOGRCV NEVER, the LOGRCV and RXXROLLBACK changes do not apply to this MUF.
Within the explanation of the message is the change needed:
In addition, the LXX could be enlarged. If this route is chosen you must bring MUF down and run a DBUTLTY INIT of the LXX with a larger dataset.
Here are the steps to enlarge the LXX:
//JCL JCLLIB ORDER=(<<YOUR DATACOM>>.CUSPROC)
//*
//INITLXX EXEC PGM=DBUTLTY,REGION=6M,PARM='/PGMMONTH=1'
// INCLUDE MEMBER=B15STLIB <<-- CHANGE 15 TO 14 FOR VERSION 14
// INCLUDE MEMBER=B15DDCXX <<--/ /
// INCLUDE MEMBER=B15DDOUT <<---/
//SYSIN DD *
INIT AREA=LXX,BLKSIZE=32760,TSN=########,VARIABLE=YES
*
* NOTE: SET THE TSN VALUE TO 10,000 HIGHER THAN THE DECIMAL CONVERSION
* OF THE VALUE SHOWN IN THE MUF "RESTART" OUTPUT FOR:
* LOG FILE HIGHEST TRANSACTION SEQUENCE NUMBER
*
/*
In the MUF output, the DD file called RESTART contains the Sequence Number referenced above. The report looks like this excerpt:
LOG FILE (LXX) OUTPUT
LOG FILE OPEN - NO
LOG FILE SPILLING - NO
LOG FILE SPILL PENDING - YES
MASTER LIST RCV OPTION - NO
LOG FILE HIGHEST TRANSACTION SEQUENCE NUMBER - 00000A1A Here, A1A converts to 2586. Therefore, use 12586 in the INIT job above.
OPEN USER FILES - NO
When the above job has completed successfully, you can restart your MUF and then the applications that use the MUF.
As always, please contact Broadcom support for CA Datacom if you have further questions.