Sample jobs

This topic provides sample PACLOG JCL. For additional sample jobs, see Examples-of-PACLOG-JCL.

The following figure shows a sample of a PACLOG job that processes a primary archive log data set and writes the filtered output to disk. The job completes after creating and cataloging the processed data set.

The BSDS, PACLOG messages and options, print files, and listings of processed log data sets and expired log data sets are all specified in the JCL by the DD statements described in previous topics.

Related topic

Building-PACLOG-jobs

The ALMIN DD statement specifies log processing options. By default, PACLOG compresses the processed log data set before writing it to the disk.

    MVSVXV1.RMD.JCL121.ALMMAIN.DOCOUT(PACLOG02) - 01.05               
 ===>                                                         
//* *************************************************************** */
//ALMMAIN EXEC PGM=ALMMAIN,                                           
//             PARM='DEJM'                           
//             REGION=4M                                              
//*     INCLUDE MEMBER=ARMSTEP
//*INCLUDE MEMBER=ALMMSGS                                            
//ALMERROR DD SYSOUT=*                                                
//ALMPRINT DD SYSOUT=*                                                
//ALMLIST1 DD SYSOUT=*                                                
//ALMLIST2 DD SYSOUT=*                                                
//ALMXPIRE DD SYSOUT=*                                            
//ALMIN    DD *                                      
  ARCHIVE3 PREFIX ARM.PACLOG.DEJMT3                          
     DISK UNIT WORK
     COMPRESS YES
     FILTERIX NONE
     FILTERRECTYPE NONE                                                 
     FILTERS (BMCARM*)                                                      
     LIMIT LOGS 2                      
/*                                                                     
***************************************************************

The following figure echoes the ALMIN control statement from the JCL, provides progress reports on the operations performed by PACLOG, and provides the following statistics:

  • The percentage of compression
  • The filtered byte count for each filter option that is specified
  • The total filtered byte count
  • The total unfiltered byte count
  • The total processed byte count
  • The unfiltered byte count for uncommitted transactions
  • The unfiltered byte count for records that are required by Db2

Important

In jobs that process more than one log data set, separate statistics are provided for each one.

Sample job's print output

   SDSF OUTPUT DISPLAY ARMC1C1  J0040859  DSID   103 LINE 0       COLUMNS 02- 133             
 COMMAND INPUT ===>                                            SCROLL ===> CSR              
********************************* TOP OF DATA **********************************************

                     
**   PACLOG  - V13.1.00 BASE  *****  BMC SOFTWARE, INC. *****  01/20/2022 13:06:01 **  
(c) COPYRIGHT 1994-2023 BMC SOFTWARE, INC.                                        
PACLOG TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBER 5761676                      
                                                                                 
BMC93223I MAINT:  NO PACLOG PTFS APPLIED                                          
BMC93223I SOLUTION COMMON CODE V13.1.00 BASE                                          
BMC93223I MAINT:  BPJ1541 BPJ1713  BPJ1727 BPJ2211                                                                                     
                                                                                 
BMC93799I USING PRODUCT OPTION SET ALM$OPTS FROM DATA SET RMD.TEST1211.BMCCNTL       
                                                                                 
  ARCHIVE3 PREFIX ARM.PACLOG.DEJMT3                                                                                                         
     DISK UNIT WORK
     COMPRESS YES
     FILTERIX NONE
     FILTERRECTYPE NONE                                                 
     FILTERS (BMCARM*)                                                      
     LIMIT LOGS 2  

 BMC93799I ZIIP ENABLED (0) USING XBM SUBSYSTEM XBMN                          
                                                                             
 BMC93649I BSDS ANALYSIS COMPLETE 01/20/2022 13:06:32                                                          
                                                                             
 BMC93799I USING HISTORY FILE DSN:BMCARM.DEJM.HISTV3                                  
                                                                             
 BMC93649I HIST ANALYSIS COMPLETE 01/20/2022 13:06:33                                                          
                                                                             
 BMC93649I CKPT ANALYSIS COMPLETE 01/20/2022 13:06:38                                                          
                                                                             
                                                                             
                                                                             
 BMC93650I ARM.PACLOG.DEJMT3.B0081080 CREATED FROM DEJMCAT.ARCHLOG1.B0081080             
                                                                             
 BMC93669I XCA RC=00000000 COMPRESSION ENABLED                                        
BMC93671I     FOR DSN=ARM.PACLOG.DEJMT3.A0081080                                     
                                                                                    
                                                                                    
BMC93650I ARM.PACLOG.DEJMT3.A0081080 CREATED FROM DEJMCAT.ARCHLOG1.A0081080          
BMC93655I           0 BYTES NOT FILTERED - UNCOMMITTED                               
BMC93655I   400509860 BYTES NOT FILTERED - REQUIRED BY DB2                           
BMC93655I        1385 BYTES FILTERED - EXCLUDED TS                             
BMC93655I   400509860 BYTES NOT FILTERED - TOTAL                               
BMC93655I        1385 BYTES FILTERED - TOTAL                                   
BMC93655I   400511245 BYTES PROCESSED - TOTAL                                  
BMC93658I       53.08 PERCENT COMPRESSION                                      
BMC93799I DATA ACCELERATOR Compression  V1R6                                   
                                                                              
BMC93650I ARM.PACLOG.DEJMT3.H0081080 CREATED FROM UPDATED ARCHIVE HISTORY      
                                                                              
BMC93649I ARCHIVE LOG PROCESS COMPLETE 01/20/2022 13:07:08                     
                                                                              
                                                                              
                                                                              
BMC93650I ARM.PACLOG.DEJMT3.B0081081 CREATED FROM DEJMCAT.ARCHLOG1.B0081081    
                                                                              
BMC93669I XCA RC=00000000 COMPRESSION ENABLED                                  
BMC93671I     FOR DSN=ARM.PACLOG.DEJMT3.A0081081                               
                                                                              
                                                                              
BMC93650I ARM.PACLOG.DEJMT3.A0081081 CREATED FROM DEJMCAT.ARCHLOG1.A0081081    
BMC93655I     3442192 BYTES NOT FILTERED - UNCOMMITTED                         
BMC93655I   397064387 BYTES NOT FILTERED - REQUIRED BY DB2                     
BMC93655I        2566 BYTES FILTERED - EXCLUDED TS                              
BMC93655I   400506579 BYTES NOT FILTERED - TOTAL                                
BMC93655I        2566 BYTES FILTERED - TOTAL                                    
BMC93655I   400509145 BYTES PROCESSED - TOTAL                                   
BMC93658I       53.09 PERCENT COMPRESSION                                       
BMC93799I DATA ACCELERATOR Compression  V1R6                                    
                                                                               
BMC93650I ARM.PACLOG.DEJMT3.H0081081 CREATED FROM UPDATED ARCHIVE HISTORY       
                                                                               
BMC93649I ARCHIVE LOG PROCESS COMPLETE 01/20/2022 13:07:19                      
                                                                               
                                                                               
                                                                               
BMC93571I PROGRAM COMPLETE RC = 0                                               
******************************** BOTTOM OF DATA ********************************

The following figure shows the total number of records in the log for each record type.

Important

The record type numbers are described in the IBM Db2 administration guide.

Total log records by type (ALMLSTAT)

**   PACLOG- V13.01.00 BASE   *****  BMC SOFTWARE, INC. *****  03/17/2022 1300010000
                                                                        00020000
  DEB2CAT.ARCHLOG1.D06137.T1238038.A0001368                             00030000
 BMC93656I RECORD TYPE 00020001 -         25 RECORDS TOTALING       400000040000
 BMC93656I RECORD TYPE 00020002 -          9 RECORDS TOTALING        90000050000
 BMC93656I RECORD TYPE 00020003 -          9 RECORDS TOTALING        37800060000
 BMC93656I RECORD TYPE 00020004 -         12 RECORDS TOTALING        51600070000
 BMC93656I RECORD TYPE 00020007 -        702 RECORDS TOTALING     14866800080000
 BMC93656I RECORD TYPE 00020009 -         48 RECORDS TOTALING       489600090000
 BMC93656I RECORD TYPE 00080002 -          1 RECORDS TOTALING        13400100000
 BMC93656I RECORD TYPE 00080003 -          1 RECORDS TOTALING        13400110000
 BMC93656I RECORD TYPE 00100001 -          7 RECORDS TOTALING       127400120000
 BMC93656I RECORD TYPE 00100002 -          7 RECORDS TOTALING        77000130000
 BMC93656I RECORD TYPE 00200001 -         57 RECORDS TOTALING       820800140000
 BMC93656I RECORD TYPE 00200002 -         56 RECORDS TOTALING       515200150000
 BMC93656I RECORD TYPE 0020000C -         56 RECORDS TOTALING       291200160000
 BMC93656I RECORD TYPE 00200010 -         56 RECORDS TOTALING       291200170000
 BMC93656I RECORD TYPE 00200020 -          1 RECORDS TOTALING         5200180000
 BMC93656I RECORD TYPE 00200040 -          1 RECORDS TOTALING         5200190000
 BMC93656I RECORD TYPE 01000001 -        448 RECORDS TOTALING      1971200200000
 BMC93656I RECORD TYPE 01000010 -          7 RECORDS TOTALING        44800210000
 BMC93656I RECORD TYPE 01000017 -          7 RECORDS TOTALING        48200220000
 BMC93656I RECORD TYPE 01000031 -          7 RECORDS TOTALING        71400230000
 BMC93656I RECORD TYPE 01020005 -         97 RECORDS TOTALING      1670800240000
 BMC93656I RECORD TYPE 04000003 -         14 RECORDS TOTALING        85400250000
 BMC93656I RECORD TYPE 04000019 -          7 RECORDS TOTALING       107900260000
 BMC93656I RECORD TYPE 06000001 -     311048 RECORDS TOTALING   4426116400270000
 BMC93656I RECORD TYPE 06000003 -         14 RECORDS TOTALING        85400280000
 BMC93656I RECORD TYPE 06000019 -        152 RECORDS TOTALING      1517600290000
 BMC93656I RECORD TYPE 2100001D -       5201 RECORDS TOTALING     56410900300000
 BMC93656I RECORD TYPE 22000014 -         21 RECORDS TOTALING        98700310000
 BMC93656I RECORD TYPE 2600001D -         64 RECORDS TOTALING       972800320000
 BMC93656I RECORD TYPE Totals   -     318135 RECORDS TOTALING   4507297300330000

The following figure shows the total number of records in the log for each Db2 object

Total log records by Db2 object (ALMOSTAT)

**   PACLOG  - V13.01.00   *****  BMC SOFTWARE, INC. *****  03/17/2022 1300010000
                                                                        00020000
  DEB2CAT.ARCHLOG1.D06137.T1238038.A0001368                             00030000
   DBNAME   OBNAME   DBID/OBID  TYP     RECORDS       BYTES             00040000
  DSNDB01  DSNLUX01  00010044    X            2         180             00050000
  DSNDB01  DSNLUX02  00010046    X           10        1022             00060000
  DSNDB01  DSNLLX02  00010086    X           19        1596             00070000
  DSNDB01  DSNLLX01  00010087    X           19        1672             00080000
  DSNDB01  SYSUTILX  000100AF    T           28       56538             00090000
  DSNDB01  SYSLGRNX  000100CF    T           38        4230             00100000
  DSNDB06  SYSCOPY   00060010    T           17        3627             00110000
  DSNDB06  DSNUCH01  00060072    X           14        1484             00120000
  DSNDB06  DSNUCX01  00060076    X           14        1652             00130000
  BMCUTIL  BMCUTIL   01040002    T            4         586             00140000
  BMCUTIL  BMCSYNC   01040004    T           47       20795             00150000
  BMCUTIL  CUTX      01040036    X            2         180             00160000
  BMCUTIL  SYX1      01040038    X           26        3248             00170000
  BMCUTIL  SYX2      0104003A    X           26        2706             00180000
  BMCUTIL  CUTX2     0104005E    X            2         212             00190000
  BMCUTIL  SYX3      01040060    X           25        2303             00200000
  ARMLOGSP TS80N5    01120007    T        80000     8920000             00210000
  ARMLOGSP TS80P6    0112000C    T        40000     5480000             00220000
  ARMLOGSP TS80P9    01120013    T        60000     7200000             00230000
  ARMLOGSP TS80N10   0112001B    T        94199    15669412             00240000
  ARMLOGSP TS80N14   01120020    T        33697     6335036             00250000

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*