IBM Support

Data Server Manager (DSM) showing SQLCODE=-206 "T1.TOTAL_RQST_TIME" is not valid in the context where it is used

Question & Answer


Question

Why is Data Server Manager (DSM) showing the following error in HealthSnapshotLogger file, after installing/migrating DSM to a newer version: "T1.TOTAL_RQST_TIME" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.69.56

Cause

Two new columns have been added to the IBMOTS.WORKLOAD_STATS table in DSM Repository Database after V1.1.2.1:
- TOTAL_ROLLBACK_PROC_TIME bigint"
- TOTAL_RQST_TIME bigint"

For some reason the migration process did not update the table successfully.

Answer

To fix the issue, stop DSM, connect to the DSM Repository Database using the DSM instance owner, and run the following DB2 commands:
- db2 "alter table IBMOTS.WORKLOAD_STATS add column TOTAL_ROLLBACK_PROC_TIME bigint"
- db2 "alter table IBMOTS.WORKLOAD_STATS add column TOTAL_RQST_TIME bigint"

Restart DSM.

[{"Product":{"code":"SS5Q8A","label":"IBM Data Server Manager"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"}],"Version":"1.1.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21979616

Page Feedback