HDB(LOAD examples

The following job is provided as member CPAHDB in the sample library SCPASAMP. This JCL runs the SMF Dump process, followed by Shared System Take-up from an SMF file, HDB Load, and selected reports. By combining take-up, HDB load and reporting into a single job step, all CICS PA functions can be performed by a single pass of the SMF data.

//CPAHDB   JOB ,CLASS=A,NOTIFY=&SYSUID
//* SMF Dump                                               
//SMFDUMP  EXEC PGM=IFASMFDP                               
//INDD     DD   DSN=SYS1.MAN1,DISP=SHR                     
//OUTDD1   DD   DISP=(NEW,CATLG),DSN=CICSPROD.SMFDAILY(+1) 
//SYSPRINT DD   SYSOUT=A                                   
//SYSIN    DD   *                                          
  INDD(INDD,OPTIONS(ALL))                                  
  OUTDD(OUTDD1,TYPE(110))                                  
/*                                                         
//*                                                        
//* CICS PA Take-up, HDB Load, and selected reports
//CICSPA   EXEC PGM=CPAMAIN,REGION=4M,PARM=NOSTAE
//STEPLIB  DD  DSN=CPA.V5R1M0.SCPALINK,DISP=SHR
//SYSPRINT DD  SYSOUT=*
//* SMF Input Files
//SMFIN001 DD  DISP=(SHR,KEEP),DSN=CICSPROD.SMFDAILY(+1)
//* Repository
//CPAHDBRG  DD  DISP=SHR,DSN=USER.CICSPA.XYX.REPOSTRY
//*
//* CICS PA command requests
//SYSIN    DD  *
   CICSPA IN(SMFIN001),
          APPLID(*),
                                                   
*   Take-up from SMF into Shared System Definitions
    HDB(TAKEUP,SYSTEMS,FILESYSTEM,OUTPUT(TAKEUP)), 
                                                   
*   HDB Load requests                              
    HDB(LOAD(WEEKLY),OUTPUT(WEEKLY)),              
    HDB(LOAD(DAILY),OUTPUT(DAILY)),                
    HDB(LOAD(STATS),OUTPUT(STATS)),                
                                                   
*   CMF Performance Report requests                
    SUMMARY(FIELDS(TRAN),OUTPUT(SUMM0001)),        
    WAITANAL(BY(TRAN),OUTPUT(WAIT0001))            
/*                                                 
Successful completion of the Load request generates a Recap report that provides information about the HDB Load, including a list of container data sets created by the Load process.
Figure 1. HDB Load Recap report
 V5R1M0                                                  CICS Performance Analyzer
                                                           HDB Load Recap Report
 
WEEKLY   Printed at 9:28:48 8/08/2004  Data from 09:02:00 8/07/2004 to 16:29:00 8/07/2004                         Page  1
                                                                                                   
                                                                                                                                   
LOAD requested for HDB: WEEKLY    Repository DSN: USER.CICSPA.XYX.REPOSTRY                                                           
                                                                                                                                   
The following Containers were created and loaded:                                                                                
  Container DSN: CPA.WEEKLY.D03219.T092846.HDB               No of Records: 54,567                                                
    Start Time Stamp: 2004-08-07-09.00.00       End Time Stamp: 2004-08-07-16.00.00                                                
                                                                                                                                   
LOAD process complete.                                                                                                             
In this example, CICS PA created container data set CPA.WEEKLY.D03219.T092846.HDB for HDB WEEKLY. It contains 54,567 records for the period 9:00am to 4:00pm on August 7, 2004.

Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//cpaug194.htm