Adding a secondary index to a DEDB

You can add a secondary index to an existing DEDB database to process a segment type in a sequence other than the one defined by the segment's key.

1. Modify the DBD definition for a DEDB primary database to add secondary index information.
2. Create a DBD definition for a Fast Path secondary index database.
3. Add the PROCSEQD= parameter with a Fast Path secondary index DBD name in the PCB for the primary DEDB database that will be accessed through the Fast Path secondary index database.
4. Run the DBDGEN utility with the definitions with Fast Path secondary index defined.
5. Run the PSBGEN utility with the definitions with Fast Path secondary index defined.
6. Run the ACBGEN utility with the definitions with Fast Path secondary index defined.
7. For data-sharing Fast Path secondary index databases, register the new Fast Path secondary index databases in DBRC.
8. Change the access of the primary DEDB database to Read Only or take the primary DEDB database offline in preparation to build its Fast Path secondary index database.
9. Build and load a Fast Path secondary index database. Use a tool that is offered by IMS Tools vendors.
10. If you have not already done so, take the primary DEDB database offline before performing an online change.
11. Create a DMB directory entry (DDIR) for the new Fast Path secondary index database. You can create the DDIR by one of the following methods:
    • Perform a MODBLKS system definition and use the ACBLIB online change process.
    • If you are using dynamic resource definition, issue the CREATE DB command to create the DDIR for the new Fast Path secondary index database and then perform an online change (ACBLIB online change or member online change).
12. Start the primary DEDB database and its Fast Path secondary index database.