Request for the IDCAMS DELETE and DEFINE JCL to initialize the Sysview for Db2 HSTSQLDB VSAM file

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Require sample IDCAMS JCL to create the Sysview Performance Management Option for Db2 for z/OS (IDB2) HSTSQLDB VSAM file.

Cause

 

Resolution

The Post Install process for IDB2 creates a hlq.SOURCE library and within this library the member IDDCVSAM (or it could be called ssidVSAM).
It is this job that deletes/defines the IDB2 data collector history VSAM files including the HSTSQLDB file. The cylinder allocation can be modified
per your history needs, but the values found here will be sufficient for initial processing.  Here is the JCL to define it:

//jobcard
//VSAMALLC EXEC PGM=IDCAMS,COND=(0,LT)            
//SYSPRINT DD  SYSOUT=*                           
//SYSIN    DD  *                                  
 DEFINE -                                         
   CLUSTER (NAME(highlevel.IDB2.ssid.HSTSTATS) -
            LINEAR     CYLINDERS(200) -           
           VOLUME(xxxxxx) -                       
            SHR(2 3)   CISZ(4096) )               
 DEFINE -                                         
   CLUSTER (NAME(highlevel.IDB2.ssid.HSTACCTG) -
            LINEAR     CYLINDERS(500) -           
           VOLUME(xxxxxx) -                       
            SHR(2 3)   CISZ(4096) )               
 DEFINE -                                         
   CLUSTER (NAME(highlevel.IDB2.ssid.HSTSQLDB) -
            LINEAR     CYLINDERS(500) -           
           VOLUME(xxxxxx) -                       
            SHR(3 3)   CISZ(16384) )              
/*                                                
 

These VSAM file names are referenced in the IDB2 data collector ssidSYSP member also found in hlq.SOURCE library.

It is within this member you will find the parameters:
HSTSTATS-DSN
HSTACCTG-DSN
HSTSQLDB-DSN 

These files get initialized upon the data collector startup.