did you do the steps in the order below ?

To verify the integrity of previously
unchecked data and have the system maintain the integrity of the
data in the table, issue the SET INTEGRITY...OFF statement to
place the table in the check pending state and then re-execute
the SET INTEGRITY...IMMEDIATE CHECKED statement with the NOT
INCREMENTAL option.




"Pham Anh "
<db2udbdba-ezmlms
hield-x92106540.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
05/31/2006 02:12
PM Subject
RE: SET INTEGRITY










Hi all.

I posted it again since I still have not yet to find the way out except to
load the data again, e.g LOAD ..REPLACE
to solve it

SQL1594W Integrity of non-incremental data remains unverified by the
database manager. SQLSTATE=01636

and not be able to tell UDB to get back to have the system check the RI for
me--I will be stuck over there, UDB keeps telling that
--this is USER check and it just not goes back to check it ?

Please you have ever seen that ?

Thanks all


-----Original Message-----
From: Pham Anh
[mailto:db2udbdba-ezmlmshield-x14119245.[Email address protected]
Sent: May 30, 2006 2:32 PM
To: LazyDBA Discussion
Subject: RE: SET INTEGRITY



Hi all,

I did quick thing to LOAD ...............REPLACE ....

and I solved the problem, it allows me to check again to successful

But That is not the good solution,

Any you could share with me is so much appreciated

Anh

-----Original Message-----
From: Pham Anh
[mailto:db2udbdba-ezmlmshield-x94016758.[Email address protected]
Sent: May 30, 2006 1:39 PM
To: LazyDBA Discussion
Subject: SET INTEGRITY



Could you please help me, many tests I could not get it..

SET INTEGRITY FOR .... IMMEDIATE CHECKED
SQL1594W Integrity of non-incremental data remains unverified by the
database manager. SQLSTATE=01636

Before, I had to turn on the CHECK without checking since I need to read
the data..
--> then now, I am back to INSERT, the INSERT is done and I want to check
all now but it kept saying the above and
puting back the table to normal -- but unverified

How could I check the whole now to successful without that error, I did try
to turn it off before checking, then doing the check again, I got this
error back!

Thanks so much for your reply

Anh


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page