Loading data into a staging table (for Db2® only)
Use this utility to load data from a UMON/ZCAT file into the TSTAGE table. Once the TSTAGE table is populated, the data can be browsed using an Analyzer report. Pre-loading into a table that is indexed speeds up the process.
As the search fields are now indexed, there will be better performance when searching for usage data .
Data input
DDNAME INSTAGE contains the UMON or ZCAT file. The file can either be a zipped or unzipped file. Only a single UMON/ZCAT file is allowed as input.
Running the loading utility
To run the loading utility, use the job HSISSTAG in the JCLLIB. This job is generated from the HSISCUST post- installation customization job.
TPARAM parameters
- COMMIT=
- Default is 1000. Number of records stored before issuing of COMMIT.
- DSN=
- Db2® location. Value assigned, as defined in job HSISCUST.
- REPSCHEMA=
- Repository qualifier. Name of qualifier is &REPZSCHM.