Determining the PSID for base and clone objects

You can determine the PSID for base and clone objects by querying the SYSIBM.SYSTABLESPACE catalog table. You can specify the PSID on the DBID and OBID keywords of the DSN1LOGP utility control statement.

Procedure

To determine the PSID to specify for base or clone objects:

  1. Determine the PSID by querying the SYSIBM.SYSTABLESPACE catalog table.
    The value is displayed in decimal format. Use the SQL HEX function in your select statement to convert the value to hexadecimal.
  2. Determine the instance number of the clone or base object.
    You can determine the instance number in two ways:
    • Look at the TYPE column in the DISPLAY DATABASE command output. The output indicates the base and clone objects with a 'B' or a 'C' character respectively along with the data set instance number.
    • Look at the Db2 catalog. The SYSIBM.SYSTABLESPACE catalog table INSTANCE column indicates the current instance number of the base table.
  3. Determine whether to alter the PSID value or leave the PSID value the same.
    For example, if the PSID value of the base or clone is '0009'X and the instance number is 1, specify a PSID value of '0009'X to DSN1LOGP. If the PSID of the base or clone is '0009'X and the instance number is 2, specify a PSID value of '8009'X to DSN1LOGP.