Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013
    Posts
    1

    Unanswered: Load terminate command doesn't work. It is not removing the load pending state

    I have table which was in "load pending" state. When I issue the "load terminate command", the output comes as follows.

    Agent Type Node SQL Code Result
    __________________________________________________ ____________________________
    LOAD 001 +00000000 Success.
    __________________________________________________ ____________________________
    LOAD 002 -00027902 Init error. Table unchanged.
    __________________________________________________ ____________________________
    LOAD 003 -00027902 Init error. Table unchanged.
    __________________________________________________ ____________________________
    LOAD 004 -00027902 Init error. Table unchanged.
    __________________________________________________ ____________________________
    RESULTS: 1 of 4 LOADs completed successfully.
    __________________________________________________ ____________________________

    Summary of LOAD Agents:
    Number of rows read = 0
    Number of rows skipped = 0
    Number of rows loaded = 0
    Number of rows rejected = 0
    Number of rows deleted = 0
    Number of rows committed = 0

    SQL27902N LOAD RESTART/TERMINATE is not allowed on a table that is not in LOAD PENDING state.

    It is not completely removing the "load pending" state. I am unable to run any query on this table. It is failing with SQL0668N Operation not allowed for reason code "3" error.

    Please help on this.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What shows up in db2diag.log for the failing partitions?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

Posting Permissions

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