473,396 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Integrity pending

Hey All..

What's the easiest way to query all the tables that are in a integrity
pending state?
Nov 12 '05 #1
3 1560
Jurgen Haan wrote:
Hey All..

What's the easiest way to query all the tables that are in a integrity
pending state?


Querying SYSCAT.TABLES.STATUS. If that column is set to 'C', then the table
is is "check pending" state.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2
Knut Stolze wrote:
Jurgen Haan wrote:

Hey All..

What's the easiest way to query all the tables that are in a integrity
pending state?

Querying SYSCAT.TABLES.STATUS. If that column is set to 'C', then the table
is is "check pending" state.


thanks :)
Nov 12 '05 #3
Jurgen Haan wrote:
Hey All..

What's the easiest way to query all the tables that are in a integrity
pending state?

http://publib.boulder.ibm.com/infoce...n/r0001063.htm
SYSCAT.TABLES.STATUS

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: maricel | last post by:
I have the following base table structure - DDL: CREATE TABLE "ADMINISTRATOR"."T1" ( "C1" INTEGER NOT NULL ) IN "TEST_TS" ; ALTER TABLE "ADMINISTRATOR"."T1" ADD PRIMARY KEY
2
by: bwmiller16 | last post by:
Folks - OpSys: RH Linux, AS3 DB: UDB 8.2.0 (FP7 Stinger) HW: 2 X-series We setup a HADR pair and they went into PEER state (after we backed-up the DB on primary and restored the DB on the...
12
by: technocrat | last post by:
I am trying to laod 2 tables and set integrtiy on them, but the second tables fails ( both are related and SET INTEGRITY ion first table succeeds) saying constraint violation....is there a way to...
3
by: technocrat | last post by:
I was runing load and then set integrity with for exception clause, still the statement failed , there are some reecords in the exception table but the actual table is still in check pending...
5
by: mahhsuri | last post by:
I have 120 tables which mostly dependent to each other. Just did a db2move for all data. Now causing SQL0668 error when accessing tables with dependencies. Now I am running SET INTEGRITY command...
16
by: Brian Tkatch | last post by:
Is there a way to check the order in which SET INTEGRITY needs to be applied? This would be for a script with a dynamic list of TABLEs. B.
1
by: Brian Tkatch | last post by:
A few questions about SET INTEGRITY. 1) Docs: The SET INTEGRITY statement is under transaction control. Using two sessions (different user, even) i tried the following. Session 1: UPDATE...
2
by: Doug | last post by:
Hi all, I have an issue with SET INTEGRITY after loading my table. Set integrity does not see integrity violations checking by trigger. My shell script does the following steps: - LOAD FROM ......
0
by: trixxnixon | last post by:
i have a form that is being designed to pend requests in a requests database. the pend form is opened from an update form used by an employee to enter updates. when the pend form is updated, the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.