DB2 check pending mode - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> DB2 check pending mode

Reply

Search this Thread

#1 (permalink)

Old

03-27-06, 02:14

nelapsi

nelapsi is offline

Registered User

Join Date: Dec 2004

Posts: 43

DB2 check pending mode

I have an DB2 7.?.? somewhere on Mainframe and DB2 CPE 8 on linux...

Then I add foreign key to a not empty table...
After this corresponding tablespace going to "check pending mode" and I can't even do "select" from this table...
What I must to do to correct this situation?
PS sorry for my english

Reply With Quote

#2 (permalink)

Old

03-27-06, 02:53

sathyaram_s sathyaram_s is offline

sathyaram_s is offline

Super Moderator

Join Date: Aug 2001

Location: UK

Posts: 4,534

If the database is on Linux, do
set integrity for <table> immediate checked
If on mainframe, run the CHECK Utility

Sathyaram

__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.

Reply With Quote

#3 (permalink)

Old

03-27-06, 03:20

nelapsi

nelapsi is offline

Registered User

Join Date: Dec 2004

Posts: 43

as I say database is on Mainframe (on s390)
I can connect to it only from my linux machine with CPE - I can't access Mainframe directly

Reply With Quote

#4 (permalink)

Old

03-27-06, 15:40

schintala

schintala is offline

Registered User

Join Date: Apr 2005

Location: USA

Posts: 119

Ask your z/os DBA to run the CHECK utility to clean check pending status.

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules