Converting page sets to the 10-byte RBA or LRSN format

To prevent RBAs and LRSNs from reaching the hard limits, convert user, catalog, and directory page sets to the 10-byte RBA or LRSN format.

About this task

If the RBA or LRSN has already reached the hard limit Db2 subsystems, the RBA or LRSN reset procedure must be used first, unless all the necessary tables and indexes have previously been converted to the extended 10-byte format. If database objects are in the basic 6-byte format, they cannot be updated after the hard limit is reached.

Tip: Data pages and space map pages for the work file database use the 10-byte format as soon as they are first accessed in Db2 11 or later (in any migration mode), regardless of whether the Db2 subsystem is migrated from DB2® 10 or is a new installation. However, for migrated subsystems, the Db2 catalog is not updated to reflect the format of the work files.

For more information about how Db2 uses 10-byte format values used at migration to Db2 11, see The extended 10-byte RBA and LRSN in Db2 13.

Db2 might issue message DSNB233I to remind you to convert page sets to the 10-byte format.

Procedure

To convert the RBA and LRSN to extended 10-byte format, complete the following steps:

  1. Identify the objects to convert by querying the RBA_FORMAT columns of the SYSIBM.SYSTABLEPART and SYSIBM.SYSINDEXPART catalog tables.
    If the RBA_FORMAT value is 'B' or blank, the object is in the basic 6-byte format.
  2. Enable Db2 to create new table spaces and indexes with the RBA or LRSN in extended 10-byte format, and convert the RBA for existing table spaces and indexes to extended 10-byte format:
    1. Run the updated DSNTIJUZ job to rebuild the subsystem parameter (DSNZPxxx) module.
    2. Issue the -SET SYSPARM command, or restart Db2.
  3. Run the LOAD REPLACE, REBUILD, or REORG utilities.
    During utility processing, any objects processed by the utility that are in basic 6-byte format are converted to extended 10-byte format. To verify the conversion, check the RBA_FORMAT column value of the SYSIBM.SYSTABLEPART and SYSIBM.SYSINDEXPART catalog tables. The value is 'E' for converted objects.

Results

New table spaces and indexes are created in extended format with 10-byte RBA or LRSN values, and existing table spaces and indexes are converted to extended format with 10-byte RBA or LRSN values.