> SQL3603N Check data processing through the SET INTEGRITY statement has found > integrity violation involving a constraint with name > "FOO.TABLE_X.SQL021007103120890". SQLSTATE=23514 > > I'm running the command: > > db2 SET INTEGRITY FOR FOO.TABLE_X IMMEDIATE CHECKED > > I know this is not a lot of info to go on, but is there something > easy (obvious) to correct this problem?
Run a db2look to get the definitions for all your constraints and grep through that to find the constraint with that name. Look at that constraint and come up with a query to locate elements that would be in violation of it. You may need to set constraints on unchecked in order to deal with everything. -HJC - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
