Previous Topic: ExamplesNext Topic: More Information

Utility Statements › TUNE INDEX › Sample Output

Sample Output

The following example directs the TUNE INDEX utility to adopt orphaned index records in the EMPDEMO dbname using subschema EMPSS01:

IDMSBCF  nn.n                            CA IDMS Batch Command Facility

TUNE INDEX FOR DBNAME EMPDEMO SUBSCHEMA EMPSS01;
Status = 0        SQLSTATE = 00000        Messages follow:
DB002994 C0M333: IDMSTUNE  -  processing started
DB002994 C0M333: IDMSTUNE  -  Indexes selected for processing:
DB002994 C0M333: IDMSTUNE  -  SKILL-EXPERTISE (IBC=30) in area EMPDEMO.ORG-DEMO-REGION (PGRSV=0)
DB002994 C0M333: IDMSTUNE  -  EMP-NAME-NDX (IBC=40) in area EMPDEMO.EMP-DEMO-REGION (PGRSV=0)
DB002994 C0M333: IDMSTUNE  -  OFFICE-EMPLOYEE (IBC=30) in area EMPDEMO.ORG-DEMO-REGION (PGRSV=0)
DB002994 C0M333: IDMSTUNE  -  SKILL-NAME-NDX (IBC=30) in area EMPDEMO.ORG-DEMO-REGION (PGRSV=0)
DB002994 C0M333: IDMSTUNE  -  JOB-TITLE-NDX (IBC=30) in area EMPDEMO.ORG-DEMO-REGION (PGRSV=0)
DB002994 C0M333: IDMSTUNE  -  Statistics for area EMP-DEMO-REGION
DB002994 C0M333: IDMSTUNE  -  Orphan adoption read 36 records (of which 8 SR8s)
DB002994 C0M333: IDMSTUNE  -  Orphan adoption adopted 20 index orphans
DB002994 C0M333: IDMSTUNE  -  Resequencing read 4 records
DB002994 C0M333: IDMSTUNE  -  Statistics for area ORG-DEMO-REGION
DB002994 C0M333: IDMSTUNE  -  Orphan adoption read 259 records (of which 63 SR8s)
DB002994 C0M333: IDMSTUNE  -  Orphan adoption adopted 0 index orphans
DB002994 C0M333: IDMSTUNE  -  Resequencing read 126 records
DB002994 C0M333: IDMSTUNE  -  425 total records read
DB002994 C0M333: IDMSTUNE  -  20 total index orphans adopted
DB002994 C0M333: IDMSTUNE  -  5 indexes/sets processed
DB002994 C0M333: IDMSTUNE  -  processing completed

AutoCommit will COMMIT transaction

Command Facility ended with no errors or warnings

The following example directs the TUNE INDEX utility to adopt orphaned index records, rebalance and resequence the index. It also shows how to temporarily override the DMCL or subschema values for PAGE RESERVE and INDEX BLOCK CONTAINS.

TUNE INDEX FOR DBNAME EMPDEMO SUBSCHEMA EMPSS01
           SET (EMP-NAME-NDX)
           DEFAULT TUNE OPTIONS
              REBALANCE  YES
              RESEQUENCE YES
              TEMPORARY INDEX UTILIZATION IS 80 %
              TEMPORARY PAGE RESERVE IS 15 PERCENT
           NOTIFY INTERVAL 1000;

The following report sample is produced by the TUNE INDEX utility.

TUNE INDEX FOR DBNAME EMPDEMO SUBSCHEMA EMPSS01
           SET (EMP-NAME-NDX)
           DEFAULT TUNE OPTIONS
              REBALANCE  YES
              RESEQUENCE YES
              TEMPORARY INDEX UTILIZATION IS 80 %
              TEMPORARY PAGE RESERVE IS 15 PERCENT
           NOTIFY INTERVAL 1000;
Status = 0        SQLSTATE = 00000        Messages follow:
DB002994 C0M333: IDMSTUNE  -  processing started
DB002994 C0M333: IDMSTUNE  -  Indexes selected for processing:
DB002994 C0M333: IDMSTUNE  -  EMP-NAME-NDX (IBC=32) in area EMPDEMO.EMP-DEMO-REGION (PGRSV=644)
DB002994 C0M333: IDMSTUNE  -  Statistics for area EMP-DEMO-REGION
DB002994 C0M333: IDMSTUNE  -  Orphan adoption read 34 records (of which 6 SR8s)
DB002994 C0M333: IDMSTUNE  -  Orphan adoption adopted 20 index orphans
DB002994 C0M333: IDMSTUNE  -  Rebalancing read 65 records
DB002994 C0M333: IDMSTUNE  -  Resequencing read 35 records
DB002994 C0M333: IDMSTUNE  -  134 total records read
DB002994 C0M333: IDMSTUNE  -  20 total index orphans adopted
DB002994 C0M333: IDMSTUNE  -  1 indexes/sets processed
DB002994 C0M333: IDMSTUNE  -  processing completed