Using data compression to tape
Run a job such that shown in the following figure to determine the impact of writing processed archive logs to tape.
After filtering, the processed logs are compressed by using the tape drive hardware compression that is specified by TRTCH COMP. Because the job runs in simulation mode, it makes no changes to the original archive log data sets. Message BMC93658I (written to the ALMPRINT data set) provides the percentage compression that PACLOG achieved for this job. See the following figure for a sample job. The job header provides more detailed information.
All processing is specified in the ALMIN data set. You can simplify the syntax shown in the following figure by omitting the keywords that specify defaults, as shown in the following example:
SIMULATE NOKEEP
ARCHIVE2
TAPE UNIT CART RETPD 1 STACK YES TRTCH COMP REDO
For more syntax information, see Command-and-syntax-reference. For DD statement information, see Building-PACLOG-jobs.
//***************************************************************
//*
//* THIS JOB CAN BE USED TO SEE THE EFFECT OF USING TRTCH COMP
//* TO STACKED TAPE OUTPUT. IT WILL NOT MAKE ANY MODIFICATIONS
//* TO YOUR DB2 ARCHIVE LOGS!
//*
//* LIKE EXAMPLE 1, IT CAN BE RUN MULTIPLE TIMES AGAINST THE
//* SAME DB2 SUBSYSTEM, VARYING THE NUMBER OF LOGS PROCESSED
//* TO DETERMINE HOW THE COMPRESSION PERCENTAGE IS AFFECTED.
//*
//* THE JOB AS SHOWN BELOW, WILL INPUT THE LAST THREE ARCHIVE LOG
//* DATA SETS AND CREATE THREE FILES PER ARCHIVE LOG. THESE FILES
//* WILL NOT BE CATALOGED, BUT THE STACKED TAPE WILL HAVE A ONE
//* DAY RETENTION PERIOD. EACH FILE NAME WILL BE BUILT USING THE
//* ARCHIVE LOG DATA SET NAME AS FOLLOWS:
//*
//* <ARCLOG2PREFIX>.Y<DSNUMBER> FOR THE BSDS
//* <ARCLOG2PREFIX>.Z<DSNUMBER> FOR THE ARCHIVE LOG DATA SET
//* <ARCLOG2PREFIX>.H<DSNUMBER> FOR THE PACLOG HISTORY FILE
//*
//* NOTE: THIS JOB DOES NOT UPDATE THE PACLOG HISTORY FILE, SO
//* IF IT IS RUN REPEATEDLY, IT WILL PROCESS THE SAME ARCHIVE LOGS
//* PROCESSED PREVIOUSLY.
//*
//***************************************************************
//COMP2 EXEC PGM=ALMMAIN,REGION=4M,
// PARM='DECI' <=== DESIRED DB2 SSID
//STEPLIB DD DISP=SHR,DSN=BMCALM.TEST.OVERRIDE1
// DD DISP=SHR,DSN=BMCALM.DBLINK <=== PACLOG LOAD LIB
// DD DISP=SHR,DSN=BMCALM.XXLINK <=== INFRASTRUCTURE 1
// DD DISP=SHR,DSN=BMCALM.BBLINK <=== INFRASTRUCTURE 2
// DD DISP=SHR,DSN=SYS3.DECI.DSNEXIT <=== DB2 DSNEXIT LIB
// DD DISP=SHR,DSN=SYS2.DB2V81M.DSNLOAD <=== DB2 DSNLOAD LIB
//SYSUT1 DD DISP=SHR,DSN=DECICAT.BSDS01 <=== DB2 BSDS
//ALMMSGS DD DISP=SHR,DSN=BMCALM.DBCNTL(ALMMSGS) <=== MSGS DS
//ALMOPTS DD DISP=SHR,DSN=BMCALM.DBCNTL(ALM$OPTS) <=== OPTS DS
//*
//ALMPRINT DD SYSOUT=* REQUIRED PRINT OUTPUT
//ALMXPIRE DD SYSOUT=* REQUIRED EXPIRED ARCHIVE REPORT
//ALMLIST1 DD SYSOUT=* REQUIRED LOCAL PRIMARY ARCHIVE LIST
//ALMLIST2 DD SYSOUT=* REQUIRED LOCAL SECONDARY ARCHIVE LIST
//*
//ALMLIST3 DD SYSOUT=* OPTIONAL OFFSITE PRIMARY ARCHIVE LIST
//ALMLIST4 DD SYSOUT=* OPTIONAL OFFSITE SECONDARY ARCHIVE LIST
//ALMLSTAT DD SYSOUT=* OPTIONAL RECORD TYPE REPORT
//ALMOSTAT DD SYSOUT=* OPTIONAL DB2 OBJECT REPORT
//BMCERROR DD SYSOUT=* OPTIONAL SAS/C ERROR MESSAGES
//ALMIN DD *
LIMIT LOGS 3
SIMULATE NOKEEP
ARCHIVE2
TAPE UNIT CART RETPD 1 STACK YES TRTCH COMP
FILTERIX ALL
FILTERRECTYPE ALL
REDO