Preventive Service Planning
Abstract
In a DB2 V12 environment with function level 504 enabled, each newly created tablespace is a universal tablespace, and only one table is allowed to be created in it.
If your Content Manager for z/OS library server is running in such an environment, and if this library server is configured to create multiple component type tables in a newly created tablespace when an item type is created, then the new item type creation will fail with a DB2 SQLCODE -646 error. You need to change your Content Manager for z/OS library server configuration to avoid this error.
Content
You can change your Content Manager for z/OS library server configuration so that each component type table for a new item type will be created in its own tablespace as follows:
Update the ICMST390CONTROL table as follows:
* In the ICMST390CONTROL table, the row with OPTIONKEY='SPACE', in column OPTIONTEXT, specify a CREATE TABLESPACE statement with tablespace name containing +COMPID+.
For example: 'CREATE TABLESPACE TS+COMPID+ IN ?DATABASE?'
For example: 'CREATE TABLESPACE TS+COMPID+ IN ?DATABASE?'
* In the ICMST390CONTROL table, the row with OPTIONKEY='TABLE', in column OPTIONTEXT, specify the optional IN clause using the tablespace name from the previous step:
For example: 'IN ?DATABASE?.TS+COMPID+'
For example: 'IN ?DATABASE?.TS+COMPID+'
* Update these 2 rows in the ICMST390CONTROL table with the above OPTIONTEXT content.
For example:
UPDATE ?CREATOR?.ICMST390CONTROL
SET OPTIONTEXT = 'CREATE TABLESPACE TS+COMPID+ IN ?DATABASE?'
WHERE OPTIONKEY = 'SPACE';
For example:
UPDATE ?CREATOR?.ICMST390CONTROL
SET OPTIONTEXT = 'CREATE TABLESPACE TS+COMPID+ IN ?DATABASE?'
WHERE OPTIONKEY = 'SPACE';
UPDATE ?CREATOR?.ICMST390CONTROL
SET OPTIONTEXT = 'IN ?DATABASE?.TS+COMPID+'
WHERE OPTIONKEY = 'TABLE';
Notes:
1. Before executing these two UPDATE statements, substitute ?DATABASE? with the database name of the library server, and substitute ?CREATOR? with the schema name of the library server.
2. You may add other optional clauses in the CREATE TABLESPACE statement.
SET OPTIONTEXT = 'IN ?DATABASE?.TS+COMPID+'
WHERE OPTIONKEY = 'TABLE';
Notes:
1. Before executing these two UPDATE statements, substitute ?DATABASE? with the database name of the library server, and substitute ?CREATOR? with the schema name of the library server.
2. You may add other optional clauses in the CREATE TABLESPACE statement.
With these changes in the ICMST390CONTROL table, Content Manager for z/OS library server will generate SQL to create a tablespace for each component type, and create the component type in it when a new item type is created.
[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLQWS","label":"Content Manager for z\/OS"},"ARM Category":[{"code":"a8m0z0000001jkvAAA","label":"Content Manager-\u003ECM8 for z\/OS"}],"Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
15 August 2023
UID
ibm17026957