LXX Log File for CA

Products

Datacom DATACOM - AD Jobtrac

Issue/Introduction

CA-Datacom/AD uses a log file, known as the LXX, to allow data to be cached while maintaining the data's integrity. As updates are made to the database, the LXX is updated with each change that is made. The updates themselves may not be written to the database at the time they are made. They are kept in storage and written to the database periodically. This limits I/O and increases the performance of the database accesses.

Important! If the LXX is allowed to fill up, the database stops processing until the spill job is run. This causes the Unicenter CA-Jobtrac processing to hang until space is freed in the LXX. We Strongly suggest that you put in place ASAP a method to capture the following message that will appear in the Datacom task and then submit the DBSPILL job. You can use Jobtrac AMR utility to do this a draw back to using Jobtrac AMR is if CA-DATACOM/AD log is full prior to starting Jobtrac. An alternative would be to use CA-OPS/MVS to capture the message.

Environment

Release:
Component: 11

Resolution

When the LXX has reached the reporting percentage specified in the LXXSPILL CA-Datacom/AD startup options, the following message is issued:

AD11STRT:DB00308I - LOG AREA IS  nn% FULL, nnnnnn BLOCKS SPILLABLE

Below is the AMR table setup to capture the CA-DATACOM/AD log full message. You will need to check the CA-DATACOM/AD startup options to find out the full percentage 'nn%' that will be issued.

CA-Jobtrac                     AMR Table                 Row 1 to 2 of 2
COMMAND ===>                                             SCROLL ===> PAGE
                                                         07/02/14   10:38
Table: DAILY                                                                
--------------------------------------------------------------------------
  Msg Text   : '//DB00308I'                                   Offset= 000
Command/Reply:                                                            
Altered Text :                                                Offset= 000
Process Pe   :        Create Event: AD11STRT     Trigger Event: DBSPILL       
TOD Range    :        SYS:               Trg Act: ( RUN  )

Below is the sample JCL that is provided in the SAMPJCL library and will need to be moved to the location 000 library in order for AMR to submit it when CA-DATACOM/AD log is full.

//DBSPILL  JOB (40600000),MSGCLASS=X,CLASS=A,                
//    MSGLEVEL=(1,1),REGION=0M 
//*                                                          
//***********************************************************
//*                                                          
//*     SAMPLE SPILL OF CA-DATACOM LOG RECORDS TO TAPE       
//*                                                          
//*     PLEASE REFER TO CA-DATACOM MANUALS FOR THE USE OF LOG
//*     RECORDS FOR FORWARD AND BACKWARD RECOVERY.           
//*                                                          
//***********************************************************
//*                                                          
//SPILL    EXEC PGM=DBUTLTY,REGION=4M                        
//STEPLIB  DD  DSN=DATACOM.R1102.CUSLIB,              
//          DISP=SHR                                         
//         DD   DSN=DATACOM.R1102.CAILIB,             
//         DISP=SHR                                          
//SYSPRINT DD   SYSOUT=*                                     
//CXX      DD  DSN=DATACOM.R1102.CXX,                 
//         DISP=SHR                                          
//RXX      DD DSN=DATACOM.R1102.TRAC0161.RXX(+1),     
//         DISP=(NEW,CATLG),                                 
//         UNIT=TAPE,LABEL=EXPDT=99000                      
//SYSIN    DD   *                                            
 SPILL                                                       
/*