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 and multiple UMON/ZCAT files are allowed as input. However, the
concatenated UMON/ZCAT files must all be zipped files or all unzipped files.
Note:
To access the loaded data, click on the checkbox: 'Use
Preloaded data' in the Analyzer report, 'Usage Monitor File Detail' from the
Discovery Tab.
Running the loading utility
To run the loading utility, use the job HZASTAG in the JCLLIB. This job is generated from the HZASCUST 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 HZASCUST.
- REPSCHEMA=
- Repository qualifier. Name of qualifier is &REPZSCHM.