To set up supplemental indexes

  1. Determine if supplemental indexes are recommended for any tables. At the Landmark command line, type

    dbverify dataarea

    If the output from dbverify indicates that there are missing indexes and that some of those indexes are supplemental, then you can set up supplemental indexes.

  2. Identify the database space that maps to the business classes that implement M3ClassicTable or S3ClassicTable. At the Landmark command line, type

    displayda dataarea

    If the data area has a space that maps to business classes that implement M3ClassicTable or S3ClassicTable, displayda will list a space where the IsView parameter is yes.

  3. Enable supplemental indexes for the space. At the Landmark command line, type

    changeda -s supplementalindexes=yes dataarea classicSpace

  4. Rebuild the product line to capture the configuration change. At the Landmark command line, type

    stagelandmark dataarea

  5. Reorganize the database to create the supplemental indexes. At the Landmark command line, type

    activatelandmark dataarea