Updating Table Space Group Names

Upgrades: All upgrades.

Environments: Development environment only.

Each Siebel table is assigned a group code number, which is stored in the GROUP_CD column of the S_TABLE table in the Siebel Repository. The group code identifies the name of the DB2 table space that is used when the table is created or re-created.

During the upgrade process, if the table space associated with a table does not match the group code defined for the table, errors occur. Therefore, it is recommended that you update S_TABLE with any changes that have been made to table space names, as reflected in the DB2 catalog. By updating S_TABLE, you ensure that the group names in the Siebel Repository and in your physical database environment are synchronized.

The following procedure describes how to update the S_TABLE table.

To update table space group names

• To update the table space group names, execute the following query:

  UPDATE SIEBEL.S_TABLE A 
  
  SET A.GROUP_CD = (SELECT B.TSNAME FROM SYSIBM.SYSTABLES B WHERE A.NAME = B.NAME 
  AND B.CREATOR = SIEBEL)
  WHERE A.INACTIVE_FLG = 'N' and A.REPOSITORY_ID = (SELECT B.ROW_ID FROM 
  SIEBEL.S_REPOSITORY B
  WHERE B.NAME = 'Siebel Repository')
  

where SIEBEL is your Siebel schema qualifier name.