Importing subcapacity reporting data with the SCRT Import utility

The SCRT Import utility imports data (CSV files) which is generated from the IBM Subcapacity Reporting Tool.

Running the SCRT Import utility

To run the SCRT import utility, use the job HZASSCRT in the JCLLIB. This job is generated from the HZASCUST post-installation customization job.

Data input

DDNAME CSVIN contains the CSV output from the IBM® SCRT tool which can be from a data set with DSORG of PS or PO. Binary uploaded CSV files are supported. DDNAME SIDMAP maps duplicate SMFIDs to a unique SID. The SCRT Import utility handles data where the same SMFID is used on multiple machines concurrently.

To support Multiplex reports, the IBM SCRT Tool needs to be 25.3.1 or higher.

Data input example

Map SMFID on specific machines to your desired SID. As described in this example, when processing data for CPU serial 11111, SMFID IP01, use SID QIP1, and so on.

//SIDMAP   DD *   
11111-IPO1=QIP1
11111-IPO2=QIP2
11111-IPO3=QIP3   
/*                
CPU serial
5 alphanumeric characters
SMFID
1 to 4 alphanumeric characters
Unique SID
1 to 4 alphanumeric characters. This must be the same as the SID value being used by the Usage Monitor for that z/OS® system.

Data output

Several Db2® tables are populated from the data contained in CSVIN, including NODE, NODE_CAPACITY, and PRODUCT_NODE_CAPACITY. Ensure that the CSVIN DD points to the .CSV output file created by the SCRT tool. This may be a DSORG=PO or PS data set.

TPARAM parameters

COMMIT=
Default is 1000. Number of records stored before issuing a COMMIT.
DSN=
Db2 location. Value assigned, as defined in job HZASCUST.
GKBSCHEMA=

Global Knowledge Base qualifier for z/OS. Name of qualifier is &GKBZSCHM_GKB7.

REPSCHEMA=
Repository qualifier. Name of qualifier is &REPZSCHM.