APAR status
Closed as program error.
Error description
When you are upgrading to DB2 Content Manager Version 8.4.1 and above, or when you are installing a new instance of DB2 Content Manager Version 8.4.1 and above, you might see all entry fields in the library server configuration panel disabled. You might also find the following error messages in the configuration log: Exit code: 129 Return code: 129 Message code: DBU01330E Message: Failed to complete necessary action on the file /opt/IBM/db2cmv8/config/icmplsddl.ddl. Exception: DB2 SQL Error: SQLCODE=-1582, SQLSTATE=428CB, SQLERRMC=ICMLOBCOL04;IBMDEFAULTBP, DRIVER=3.53.95 Exception stack trace: java.lang.Exception: DB2 SQL Error: SQLCODE=-1582, SQLSTATE=428CB, SQLERRMC=ICMLOBCOL04;IBMDEFAULTBP, DRIVER=3.53.95
Local fix
The work around is after failure, manually change the statement in %IBMCMROOT%\config\icmlsdb2def.ddl for fresh create and %IBMCMROOT%\config\icmplsddl.ddl for upgrade: CREATE LARGE TABLESPACE %ICM_LS_DBICMLOBCOL04% %EEE% in ICMLSONENODE PAGESIZE 4 K MANAGED BY DATABASE USING (FILE '%ICM_LS_DBICMLOBCOL04%' 10M) AUTORESIZE YES MAXSIZE NONE; to CREATE LARGE TABLESPACE %ICM_LS_DBICMLOBCOL04% %EEE% in ICMLSONENODE PAGESIZE xxx K MANAGED BY DATABASE USING (FILE '%ICM_LS_DBICMLOBCOL04%' 10M) AUTORESIZE YES MAXSIZE NONE; where xxx is the real page size of IBMDEFAULTBP. Another way is to create a 4K bufferpool and change the statement to CREATE LARGE TABLESPACE %ICM_LS_DBICMLOBCOL04% %EEE% in ICMLSONENODE PAGESIZE xxx K MANAGED BY DATABASE USING (FILE '%ICM_LS_DBICMLOBCOL04%' 10M) AUTORESIZE YES MAXSIZE NONE BUFFERPOOL <new 4K buffer pool> This table space are only used by BPM integration feature. BPM users need to follow the manual if you are using this feature to configure this table space.
Problem summary
If the DB2 default buffer pool IBMDEFAULTBP page size has been changed from the default size of 4K, this error will occur when the library server tries to create a table space ICMLOBCOL04, which uses the default buffer pool IBMDEFAULTBP. Starting in DB2 Content Manager Version 8.4.2 fix pack 3, the library server explicitly specifies a buffer pool of ICMLSVOLATILEBP4 when creating table space ICMLOBCOL04 to fix this problem.
Problem conclusion
DB2 Content Manager Version 8.4.2 Fix Pack 3 fixes this problem.
Temporary fix
When this failure occurs, manually change the following statement in %IBMCMROOT%\config\icmlsdb2def.ddl when installing or %IBMCMROOT%\config\icmplsddl.ddl when upgrading: CREATE LARGE TABLESPACE %ICM_LS_DBICMLOBCOL04% %EEE% in ICMLSONENODE PAGESIZE 4 K MANAGED BY DATABASE USING (FILE '%ICM_LS_DBICMLOBCOL04%' 10M) AUTORESIZE YES MAXSIZE NONE; to: CREATE LARGE TABLESPACE %ICM_LS_DBICMLOBCOL04% %EEE% in ICMLSONENODE PAGESIZE <page size number> K MANAGED BY DATABASE USING (FILE '%ICM_LS_DBICMLOBCOL04%' 10M) AUTORESIZE YES MAXSIZE NONE; where <page size number> is the actual page size for IBMDEFAULTBP.
Comments
APAR Information
APAR number
IO12416
Reported component name
LIBRARY SERVER
Reported component ID
5724B1907
Reported release
842
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-05-24
Closed date
2010-12-09
Last modified date
2010-12-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
LIBRARY SERVER
Fixed component ID
5724B1907
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"842","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
09 December 2010