Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Location
    Belize City, Belize, Central Amercia
    Posts
    4

    Unhappy Unanswered: DB2 quiesce error

    HI all, Help Please. I have a tablespace locked in exclusive quiesced Load pending error. We were doing a load when we had a network failure, now I cannot seem to remove the quiesced lock on my tablespace. I have read passed question/answer on this issue but without results. These are the option I have tried:

    1. have found the tablespace and tablename that are the culprits.
    2. I have tried prevoius suggestions being
    quiesce tablespaces for table (tablename) reset (also exclusive to try and restart the loading.
    These are the errors I received back:
    "SQL2048N an error occurred while accessing object <objectname> Reason code:8"

    I have checked the db2diag.log and it contains this:
    2004-04-22-13.38.22.784991 Instance:db2inst1 Node:000
    PID:13551(db2agent (TDWDB)) Appid:*LOCAL.db2inst1.040422051239
    database_utilities sqlu_quiesce_datapools_for_ta Probe:60 Database:TDWDB

    Quiesce Error: Failed to rollback.

    2004-04-22-13.38.22.974255 Instance:db2inst1 Node:000
    PID:13551(db2agent (TDWDB)) Appid:*LOCAL.db2inst1.040422051239
    database_utilities sqlu_quiesce_datapools_for_ta Probe:60 Database:TDWDB

    rc= -2048, sqlcode= 0.

    2004-04-22-13.38.23.164704 Instance:db2inst1 Node:000
    PID:13551(db2agent (TDWDB)) Appid:*LOCAL.db2inst1.040422051239
    database_utilities sqlu_quiesce_datapools_for_ta Probe:60 Database:TDWDB

    obj_id= 0, quiescemode= 2, num_of_tablespaces= 25780776.

    Data Title:table_tspid_list PID:13551 Node:000
    110b c030 0044 7de0 154e 0000 ...0.D}..N..

    Dump File:/sunfire2/home/db2inst1/sqllib/db2dump/13551.000 Data:ACB
    Dump File:/sunfire2/home/db2inst1/sqllib/db2dump/13551.000 DataQLP_DBCB
    Dump File:/sunfire2/home/db2inst1/sqllib/db2dump/13551.000 DataQLP_ACB
    Dump File:/sunfire2/home/db2inst1/sqllib/db2dump/13551.000 DataQLP_TENTRY

    2004-04-22-13.38.46.698492 Instance:db2inst1 Node:000
    PID:26631(db2agent (TDWDB)) Appid:*LOCAL.db2inst1.040422073846
    data_management sqldmdrp Probe:352 Database:TDWDB

    Unable to drop table.
    RC=FFFF812F, Pool=14, Object=4, Class=0

    any help is much appreciated.

    we are running solaris 8 on a sun box with DB2 7.2
    Last edited by mmarin; 04-22-04 at 17:38.

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

    Re: DB2 quiesce error

    Did you try LOAD... TERMINATE

    ie , in the original command , use TERMINATE instead of INSERT or REPLACE

    HTH

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

  3. #3
    Join Date
    Apr 2004
    Location
    Belize City, Belize, Central Amercia
    Posts
    4
    I just did but all it do was remove the load pending portion . When I did a list tablespaces again ---it shows that its still quiesced: exclusive.
    When I do a replace then it gives a different error. SQL0901N reason -6646 sqlstate 58004

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Check your db2diag.log for additional information

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

  5. #5
    Join Date
    Apr 2004
    Location
    Belize City, Belize, Central Amercia
    Posts
    4
    I did but all I can see which would likely point me in any direction was that a file was not found but it did not say which file it was looking for.

    Here is the extract from the db2diag.log which pertains to the error.
    2004-04-22-17.01.05.223754 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    buffer_pool_services sqlbFixDataEMP Probe:820 Database:TDWDB

    Obj={pool:14;obj:65535;type:0} State=x27 Parent={14;65535}, EM=1, PP0=64 Page=1

    Data TitleQLB_OBJECT_DESC PID:26629 Node:000
    000e ffff 000e ffff 0000 0000 006a 750b .............ju.
    668f 0000 0000 0000 0000 0001 0000 0000 f...............
    0000 0040 0000 0102 0000 0027 0000 0000 ...@.......'....
    0000 1000 0000 0020 0000 0001 ffff 000e ....... ........
    110a 3894 110b c030 ..8....0


    2004-04-22-17.01.05.551480 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    buffer_pool_services sqlbDMSMapObj2Pool Probe:820 Database:TDWDB
    DIA3711C A file "" could not be found.

    ZRC=FFFFE60A

    2004-04-22-17.01.05.640815 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    buffer_pool_services sqlbDMSMapObj2Pool Probe:820 Database:TDWDB

    Obj={pool:14;obj:65535;type:0} State=x27 Parent={14;65535}, EM=1, PP0=64 Page=0 Cont=0 Offset=4290677984 BlkSize=0


    Data TitleQLB_OBJECT_DESC PID:26629 Node:000
    000e ffff 000e ffff 0000 0000 006a 750b .............ju.
    668f 0000 0000 0000 0000 0001 0000 0000 f...............
    0000 0040 0000 0102 0000 0027 0000 0000 ...@.......'....
    0000 1000 0000 0020 0000 0001 ffff 000e ....... ........
    110a 3894 110b c030 ..8....0


    2004-04-22-17.01.05.968578 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    data_management loadDMSDesc Probe:1637 Database:TDWDB
    DIA3711C A file "" could not be found.

    ZRC=FFFFE60A

    Data Title:Object descriptor: PID:26629 Node:000
    000e 0004 000e 0004 0000 0000 0000 0000 ................
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0102 0000 0000 0000 0000 ................
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0000 ........


    2004-04-22-17.01.06.266553 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    data_management sqldLoadTCB Probe:7 Database:TDWDB
    DIA3711C A file "" could not be found.

    ZRC=FFFFE60A
    Dump File:/sunfire2/home/db2inst1/sqllib/db2dump/26629.000 DataQLD_TCB

    2004-04-22-17.01.06.427493 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    relation_data_serv sqlrr_signal_handler Probe:10 Database:TDWDB
    DIA7107I Execution of a component signal handling function has begun.

    2004-04-22-17.01.06.463338 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    relation_data_serv sqlrr_signal_handler Probe:20 Database:TDWDB
    DIA7108I Execution of a component signal handling function is complete.

    2004-04-22-17.01.06.486872 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    data_management sqldFixTCB Probe:2704 Database:TDWDB
    DIA3711C A file "" could not be found.

    ZRC=FFFFE60A

    2004-04-22-17.01.06.594145 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    database_utilities sqlu_quiesce_datapools_for_ta Probe:15 Database:TDWDB

    Quiesce Error: Failed to get object list for table.

    2004-04-22-17.01.06.707271 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    database_utilities sqlu_quiesce_datapools_for_ta Probe:15 Database:TDWDB

    rc= -6646, sqlcode= -901.

    2004-04-22-17.01.06.814463 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    database_utilities sqlu_quiesce_datapools_for_ta Probe:15 Database:TDWDB

    obj_id= 4, quiescemode= 9, num_of_tablespaces= 0.

    Data Title:table_tspid_list PID:26629 Node:000
    0000 0000 0000 0000 0000 0000 ............

    Dump File:/sunfire2/home/db2inst1/sqllib/db2dump/26629.000 Data:ACB

    2004-04-22-17.01.11.173835 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    buffer_pool_services sqlbFixDataEMP Probe:820 Database:TDWDB
    DIA3711C A file "" could not be found.

    ZRC=FFFFE60A

    2004-04-22-17.01.11.330339 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    buffer_pool_services sqlbFixDataEMP Probe:820 Database:TDWDB

    Obj={pool:14;obj:65535;type:0} State=x27 Parent={14;65535}, EM=1, PP0=64 Page=1

    Data TitleQLB_OBJECT_DESC PID:26629 Node:000
    000e ffff 000e ffff 0000 0000 006a 750b .............ju.
    668f 0000 0000 0000 0000 0001 0000 0000 f...............
    0000 0040 0000 0102 0000 0027 0000 0000 ...@.......'....
    0000 1000 0000 0020 0000 0001 ffff 000e ....... ........
    110a 3894 110b c030 ..8....0


    2004-04-22-17.01.11.717127 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    buffer_pool_services sqlbDMSMapObj2Pool Probe:820 Database:TDWDB
    DIA3711C A file "" could not be found.

    ZRC=FFFFE60A

    2004-04-22-17.01.11.878441 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    buffer_pool_services sqlbDMSMapObj2Pool Probe:820 Database:TDWDB

    Obj={pool:14;obj:65535;type:0} State=x27 Parent={14;65535}, EM=1, PP0=64 Page=0 Cont=0 Offset=4290677984 BlkSize=0


    Data TitleQLB_OBJECT_DESC PID:26629 Node:000
    000e ffff 000e ffff 0000 0000 006a 750b .............ju.
    668f 0000 0000 0000 0000 0001 0000 0000 f...............
    0000 0040 0000 0102 0000 0027 0000 0000 ...@.......'....
    0000 1000 0000 0020 0000 0001 ffff 000e ....... ........
    110a 3894 110b c030 ..8....0


    2004-04-22-17.01.12.277671 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    data_management loadDMSDesc Probe:1637 Database:TDWDB
    DIA3711C A file "" could not be found.

    ZRC=FFFFE60A

    Data Title:Object descriptor: PID:26629 Node:000
    000e 0004 000e 0004 0000 0000 0000 0000 ................
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0102 0000 0000 0000 0000 ................
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0000 ........


    2004-04-22-17.01.12.635079 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    data_management sqldLoadTCB Probe:7 Database:TDWDB
    DIA3711C A file "" could not be found.

    ZRC=FFFFE60A
    Dump File:/sunfire2/home/db2inst1/sqllib/db2dump/26629.000 DataQLD_TCB

    2004-04-22-17.01.12.801417 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    relation_data_serv sqlrr_signal_handler Probe:10 Database:TDWDB
    DIA7107I Execution of a component signal handling function has begun.

    2004-04-22-17.01.12.831741 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    relation_data_serv sqlrr_signal_handler Probe:20 Database:TDWDB
    DIA7108I Execution of a component signal handling function is complete.

    2004-04-22-17.01.12.872929 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    data_management sqldFixTCB Probe:2704 Database:TDWDB
    DIA3711C A file "" could not be found.

    ZRC=FFFFE60A

    2004-04-22-17.01.13.004544 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    database_utilities sqlu_quiesce_datapools_for_ta Probe:15 Database:TDWDB

    Quiesce Error: Failed to get object list for table.

    2004-04-22-17.01.13.129500 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    database_utilities sqlu_quiesce_datapools_for_ta Probe:15 Database:TDWDB

    rc= -6646, sqlcode= -901.

    2004-04-22-17.01.13.254626 Instance:db2inst1 Node:000
    PID:26629(db2agent (TDWDB)) Appid:0A321117.07F2.040422045321
    database_utilities sqlu_quiesce_datapools_for_ta Probe:15 Database:TDWDB

    obj_id= 4, quiescemode= 0, num_of_tablespaces= 0.

    Data Title:table_tspid_list PID:26629 Node:000
    0000 0000 0000 0000 0000 0000 ............

    Dump File:/sunfire2/home/db2inst1/sqllib/db2dump/26629.000 Data:ACB

    sorry if i'm being a nuisance. THX for all your responses.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Why not get in touch wiht IBM, especially if this is prod data ?

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

  7. #7
    Join Date
    Apr 2004
    Location
    Belize City, Belize, Central Amercia
    Posts
    4
    I guess that's my next move. But THX for all you help.

Posting Permissions

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