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.