Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    58

    Unanswered: LOADED data is all in Check Pending state

    Still trying to master getting DB data from AIX to a PC.

    I create a new DB, assign authorizations, and then create the
    schemas and tables with output from db2look. All good so far.

    Next I export the data from AIX with db2move and load it
    to the PC with db2move.

    Now all of my tables with foreign keys are unusable with the
    following error:

    SQL0668N Operation not allowed when the underlying table (or a dependent table) is in the Check Pending state. SQLSTATE=57016

    I have tried QUIESCE RESET on a number of the tables with no affect.
    LIST TABLESPACES SHOW DETAIL seems to show no problems or
    pending backup.


    I have also tried backing up the database, dropping it, and then
    restoring it but I get:

    SQL1117N A connection to or activation of database "MSTRDATA" cannot be made
    because of ROLL-FORWARD PENDING. SQLSTATE=57019

    db2 rollforward database mstrdata
    SQL0956C Not enough storage is available in the database heap to process the
    statement. SQLSTATE=57011

    After bumping the heap size I get this:
    D:\dbData\backup\export>db2 rollforward database mstrdata

    Rollforward Status

    Input database alias = mstrdata
    Number of nodes have returned status = 1

    Node number = 0
    Rollforward status = DB pending
    Next log file to be read = S0000000.LOG
    Log files processed = -
    Last committed transaction = 2003-09-04-16.30.21.000000

    and I still cant connect due to a rollfoward pending.


    Why is this so difficult?

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

    Re: LOADED data is all in Check Pending state

    for check pending, the correct action is

    set integrity on table immediate checked

    Cheers
    Sathyaram

    Originally posted by wayneb64
    Still trying to master getting DB data from AIX to a PC.

    I create a new DB, assign authorizations, and then create the
    schemas and tables with output from db2look. All good so far.

    Next I export the data from AIX with db2move and load it
    to the PC with db2move.

    Now all of my tables with foreign keys are unusable with the
    following error:

    SQL0668N Operation not allowed when the underlying table (or a dependent table) is in the Check Pending state. SQLSTATE=57016

    I have tried QUIESCE RESET on a number of the tables with no affect.
    LIST TABLESPACES SHOW DETAIL seems to show no problems or
    pending backup.


    I have also tried backing up the database, dropping it, and then
    restoring it but I get:

    SQL1117N A connection to or activation of database "MSTRDATA" cannot be made
    because of ROLL-FORWARD PENDING. SQLSTATE=57019

    db2 rollforward database mstrdata
    SQL0956C Not enough storage is available in the database heap to process the
    statement. SQLSTATE=57011

    After bumping the heap size I get this:
    D:\dbData\backup\export>db2 rollforward database mstrdata

    Rollforward Status

    Input database alias = mstrdata
    Number of nodes have returned status = 1

    Node number = 0
    Rollforward status = DB pending
    Next log file to be read = S0000000.LOG
    Log files processed = -
    Last committed transaction = 2003-09-04-16.30.21.000000

    and I still cant connect due to a rollfoward pending.


    Why is this so difficult?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

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

    Re: LOADED data is all in Check Pending state

    Try issuing

    rollforward database <dbname> to end of logs and complete

    and then the set integrity statement (refer sql reference for detailed information)

    Cheers

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

Posting Permissions

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