Siebel Database Upgrade Guide for DB2 for z/OS > Basic Database Preparations for a Siebel Upgrade >

Updating Group Names

Upgrades: All upgrades.

Environments: Development environment only.

If you are upgrading to the current release, table space group names are not updated for some of the tables in the Siebel-supplied ddl.ctl file. You must update the table space group names so that they match the names used in the DB2 catalog; this ensures the repository group names are the same as those used in your physical database environment.

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 B.S_REPOSITORY WHERE B.NAME = 'Siebel Repository')

  where SIEBEL is your Siebel schema qualifier name.