Adding a secondary index to a new primary DEDB

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

To add a secondary index:

1. Create a DBD definition for a DEDB primary database that has a secondary index defined.
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 ACB Maintenance utility with the definitions with Fast Path secondary index defined.
7. Allocate a new data set for the area.
8. Optional: Register new DB/DBDS/ADS for the new DEDB database to DBRC.
9. Format the new area data set using DEDB Initialization utility (DBFUMIN0).
10. Create a DMB directory entry (DDIR) for the new DEDB and its secondary index database using 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 and then perform an ACBLIB or member online change.
11. Take an image copy of the new primary DEDB database.
12. Optional: For data-sharing Fast Path secondary index databases, register the new Fast Path secondary index databases in DBRC.
13. Create an application program to load the primary DEDB database with a Fast Path secondary index defined.
14. Run the application program to build and load both the primary DEDB database and its Fast Path secondary index database.