Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: tables in check pending and tablespace in quiesce exclusive mode after failed load

    I ran some load commands for seven tables and the loads failed to run leaving the tables in a check pending mode and the 2 tablespaces in exclusive quiesced mode. First I re-ran the load command with the terminate option then I tried to un-quiesce the tables using the reset
    option which failed to solve the problem. Any hints? Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: tables in check pending and tablespace in quiesce exclusive mode after failed load

    Load Pending - Removed using the LOAD TERMINATE

    Check Pending - Use SET INTEGRITY FOR <tablename> IMMEDIATE CHECKED

    HTH

    Sathyaram

    Originally posted by mixxalot
    I ran some load commands for seven tables and the loads failed to run leaving the tables in a check pending mode and the 2 tablespaces in exclusive quiesced mode. First I re-ran the load command with the terminate option then I tried to un-quiesce the tables using the reset
    option which failed to solve the problem. Any hints? Thanks
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Posts
    369

    cannot fix problem

    SQL3805N The state of the application or of one or more table spaces for the table specified prohibits the loadapi action or quiescemode "9". Reason code = "1".

    DB2 LOAD FROM 'blah.del' of DEL MODIFIED BY NOHEADER TERMINATE INTO BLAH NONRECOVERABLE;

    DB2 QUIESCE TABLESPACES FOR TABLE blah

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: cannot fix problem

    Did you do this using the same id as the original LOAD ?

    If yes and still there is a problem, terminate all applications from the database and reconnect and reissue the LOAD TERMINATE Command (It worked for me once... Could be a coincidence !! ... Worth a try, anyways)

    Good luck

    Sathyaram

    Originally posted by mixxalot
    SQL3805N The state of the application or of one or more table spaces for the table specified prohibits the loadapi action or quiescemode "9". Reason code = "1".

    DB2 LOAD FROM 'blah.del' of DEL MODIFIED BY NOHEADER TERMINATE INTO BLAH NONRECOVERABLE;

    DB2 QUIESCE TABLESPACES FOR TABLE blah
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    May 2003
    Posts
    369

    it did and didnt work

    Sathyaram,

    It worked on the two tables that were on the tablespace in non-quiesced mode. However it does not work for the 5 tables that are on the tablespace stuck in quiesced exclusive mode after the load failed. IBM support told me to use db2dart so will keep you posted.

    Scott

Posting Permissions

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