IO12416: During upgrade or installation of DB2 Content Manager Version 8.4.1 and above,the configuration panel fields might be disabled

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 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