Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    43

    Unanswered: 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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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.

  3. #3
    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

  4. #4
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    Ask your z/os DBA to run the CHECK utility to clean check pending status.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •