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:
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.