Maintain Index to build/rebuild multiple indexes in one job.
search cancel

Maintain Index to build/rebuild multiple indexes in one job.

book

Article ID: 68246

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

Issue/Introduction

Can Maintain Index be used to build two indexes in one sweep or must it be two separate jobs?

 

 

Environment

All Supported releases.

Resolution

Maintain Index can be used to execute multiple build/rebuild operations in one job but the utility will process the first statement until complete, then the second, so they are not built in "one sweep": 

Here is the syntax in SYSIPT: 
MAINTAIN INDEX IN SEGMENT segment-name USING subschema-name 
BUILD index1-name FROM MEMBERS; 
MAINTAIN INDEX IN SEGMENT segment-name USING subschema-name 
BUILD index2-name FROM MEMBERS; 

 

Additional Information

CA IDMS Utilities Guide: Utility Statements; MAINTAIN INDEX. Section ‘Usage’.