Host Encyclopedia Utilities › TIUSIDU › Recommendations Prior to Running Utility

Recommendations Prior to Running Utility

Follow these steps:

1. Backup encyclopedia database.
2. For performance reasons, it may be desirable to create an additional temporary DB2 index on encyclopedia table DSETDF and bind the TIUSIDU plan or package prior to submitting the generated utility JCL.

TIUSIDU performance of aggregate set processing can be significantly improved by creating a temporary index on DSETDF as follows:

CREATE TYPE 2 UNIQUE INDEX DSETDFI2 
ON DSETDF (ASD_AGGREGATE_ID, ASD_SET_ID) 
USING STOGROUP xxxx 
             PRIQTY xxxx 
             SECQTY xxx 
             CLOSE NO;

If you create this index be sure to bind TIUSIDU again so that the new index will be included in the DB2 plan access path. Also, remember to drop this index when you are finished running TIUSIDU so that this index does not degrade other host encyclopedia functions. Do not bind any other encyclopedia plan/package while this temporary index exists.