Require sample IDCAMS JCL to create the Sysview Performance Management Option for Db2 for z/OS (IDB2) HSTSQLDB VSAM file.
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.