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


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