1. Applications Upgrade Guide for IBM i with DB2 for IBM i
  2. Rebuilding Cross Reference Tables on the IBM i

Rebuilding Cross Reference Tables on the IBM i

To rebuild cross reference tables on the IBM i:

  1. Stop all subsystems using this command:

    ENDSBS *ALL *IMMED

  2. After the jobs have successfully stopped, run the following command:

    RCLSTG SELECT(*DBXREF)

    Note that this command may run for as much as several hours.

  3. Restart all subsystems using this command:

    STRSBS QCTL

    The cross-reference table is now rebuilt and ready for use.