TEP client logins fail with error KFWITM393E

Technote (troubleshooting)


Problem(Abstract)

TEP client logins fail after restarting the TEPS. Within the TEPS RAS logs the DB2 error SQL0668N is reported.

Diagnosing the problem

Review the TEPS RAS logs (hostname_cq_KfwServices_5*.log files) for the error

[IBM][CLI Driver][DB2/AIX64] SQL0668N Operation not allowed for reason code "1" on table "ITMUSER.KFWUSERALIAS". SQLSTATE=57016


Resolving the problem

This error occurs when the table is in the Check Pending state. The Check Pending state occurs when the integrity of the table is not enforced and the content of the table is invalid. This error can also occur when an operation on a parent table or an underlying table that is not in a Check Pending state, but its dependent tables are in a Check Pending state.

To bring the table out of the Check Pending state, perform the following:


1. Type the following commands at the command prompt:
db2 connect to TEPS user <USERNAME> using <password>
db2 set integrity for table_name immediate checked
Where,

  • user_id is the user ID of the database user.
  • password is the password for the user.
  • table_name is the table that is in the check pending state.

2. Restart TEPS

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Monitoring
Tivoli Distributed Monitoring

Software version:

6.2, 6.2.1, 6.2.2

Operating system(s):

All Platforms

Reference #:

1624801

Modified date:

2013-02-21

Translate my page

Machine Translation

Content navigation