Increasing the size of the BSDS

Data sharing causes additional records to be written to the BSDS for member information.

About this task

Recommendations: To prevent the BSDS from expanding into secondary extents, change the size of the primary space allocation to 1500 records. This change is necessary only for members that have followed the recommended migration path from a previous Db2 version without altering that record size. New installations and member installations already do this for you.

Procedure

To increase the space allocation for the BSDS:

  1. Rename existing BSDSs.
  2. Define larger BSDSs with the original names.
  3. Copy the renamed BSDSs into the new BSDSs.

Results

You can do this using access method services. To see the definition that is used for the BSDSs, see the installation job DSNTIJIN.