Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 quiesce error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-22-04, 16:26
mmarin mmarin is offline
Registered User
  
Join Date: Apr 2004
Location: Belize City, Belize, Central Amercia
Posts: 4
Unhappy 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 16:38.
Reply With Quote
  #2 (permalink)  
Old 04-22-04, 16:44
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
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.
Reply With Quote
  #3 (permalink)  
Old 04-22-04, 18:14
mmarin mmarin is offline
Registered User
  
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
Reply With Quote
  #4 (permalink)  
Old 04-22-04, 19:07
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
Check your db2diag.log for additional information

Cheers
Sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #5 (permalink)  
Old 04-22-04, 19:19
mmarin mmarin is offline
Registered User
  
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.
Reply With Quote
  #6 (permalink)  
Old 04-22-04, 19:30
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
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.
Reply With Quote
  #7 (permalink)  
Old 04-22-04, 19:33
mmarin mmarin is offline
Registered User
  
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.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.