IBM Content Manager OnDemand for Multiplatforms fails to create new tables after upgrading to DB2 V10

Technote (troubleshooting)


Problem(Abstract)

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.

Symptom

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

Or

> 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

Cause

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.

Environment

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Content Manager OnDemand for Multiplatforms
Database

Software version:

8.4.1, 8.5, 9.0

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Linux zSeries, Solaris, UNIX, Windows

Software edition:

All Editions

Reference #:

1623537

Modified date:

2013-07-31

Translate my page

Machine Translation

Content navigation