The table is in Check Pending State and you need to run the SET
INTEGRITY on it. See explanation below:
SQL0668N Operation not allowed for reason code reason-code on table
table-name .
Explanation:
Access to table table-name is restricted. The cause is based on the
following reason codes reason-code :
1
The table is in Check Pending state. The integrity of the table is not
enforced and the content of the table may be invalid. An operation on a
parent table or an underlying table that is not in a check pending state
may also receive this error if a dependent table is in a check pending
state.
User Response:
1
Execute the SET INTEGRITY statement with the IMMEDIATE CHECKED option on
table table-name to bring the table out of the Check Pending state. For
a user maintained materialized query table, execute the statement with
the IMMEDIATE UNCHECKED option instead of the IMMEDIATE CHECKED option.
Thanks & Regards,
Divakar
-----Original Message-----
From: Neelmani_Parmar
[mailto:db2udbdba-ezmlmshield-x54385483.[Email address protected]
Sent: Tuesday, November 29, 2005 11:34 AM
To: LazyDBA Discussion
Subject: Help!!!
Hi All,
I m new to db2........
SQL0668N Operation not allowed for reason code "1" on table
"MODUSR04.ITEMGROUPDETAIL". SQLSTATE=57016
sqlstate = 57016
Can smone figure out how to fix this..
Needed urgently
Thanx In Advance
Thanks & Regards
Neelu
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.
DB2 & UDB email list listserv db2-l LazyDBA home page