IBM Content Manager OnDemand for Multiplatforms fails to create new tables after upgrading to DB2 V10
IBM Content Manager OnDemand uses the db2Runstats API to perform runstats on newly created tables or existing tables that are updated since their last runstats. This API uses a structure that has changed in DB2 V10. If the db2Runstats API fails, the Content Manager OnDemand server rolls the tables back and issues an error.
You might see messages on the console when creating new tables, for example:
RUNSTATS ON TABLE archive.SL21 -- SQLSTATE=Not Defined, SQLCODE=1, File=arssys.c, Line=1697
> arsdb -sv
ARS4042I Updating runstat statistics for table root.arsag
arsdb: ARS4042I Updating runstat statistics for table
ARS4090E Unable to do a runstats on table arsag. err=1
arsdb: ARS4043E Unable to update runstat statistics on table root.arsag
DB2 V10 has added a new parameter to the db2 runstats structure for Index Sampling Option. This did not exist in prior versions of DB2. The V10 db2Runstats API is not recognizing the older version of the structure and issuing an SQL1197N Invalid value specified for keyword "INDEX SAMPLE" in command "RUNSTATS".error.
This affects all versions of Content Manager OnDemand for Multiplatforms prior to V9 fix pack 1.
Diagnosing the problem
Check the system console or run one of the arsdb database maintenance commands that perform a runstats.
Resolving the problem
You need to request a special build of DB2 V10 with the patch for APAR IC89492 from DB2 support.
More support for:
Content Manager OnDemand for Multiplatforms
Software version: 8.4.1, 8.5, 9.0
Operating system(s): AIX, HP-UX, Linux, Platform Independent, Solaris, Windows
Software edition: All Editions
Reference #: 1623537
Modified date: 31 July 2013