Utility Statements › TUNE INDEX › Examples

Examples

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

tune index for dbname empdemo subschema empss01;

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;