Technote (troubleshooting)
Problem(Abstract)
IBM Content Manager OnDemand uses the db2Runstats API to perform runstats on newly created tables as well as existing tables that have been updated since their last runstats. This API uses a structure that has changed in DB2 V10. If the db2Runstats API fails, the OnDemand server will rollback the table creation and issue 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 apply a DB2 APAR Patch for IC89492. This patch will be part of DB2 V10 Fix Pack 3.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.