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 > Tablespace 1(TEMPSPACE1) is full

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-13-04, 15:01
asnmur asnmur is offline
Registered User
 
Join Date: Aug 2004
Posts: 2
Tablespace 1(TEMPSPACE1) is full

Some body please help to analyse this db2diag.log and advise me what to do.
our TEMPSPACE1 is Database managed and on raw devices of size 16 GB
------------------------------------------------

2004-08-13-10.26.42.468157 Instance:INSTANCE Node:000
PID:2097(db2agntp (SLDGSL_P)) Appid:82010A77.08F2.040813145123
buffer_pool_services sqlbAllocateExtent Probe:830 DatabaseATABASE

Tablespace 1(TEMPSPACE1) is full

2004-08-13-10.26.42.502504 Instance:INSTANCE Node:000
PID:2097(db2agntp (DATABASE)) Appid:82010A77.08F2.040813145123
buffer_pool_services sqlbObtainDataExtent Probe:800 DatabaseATABASE
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFD121".

2004-08-13-10.26.42.532894 Instance:INSATNCE Node:000
PID:2097(db2agntp (DATABASE)) Appid:82010A77.08F2.040813145123
buffer_pool_services sqlbObtainDataExtent Probe:800 DatabaseATABASE

Obj={pool:1;obj:6;type:128} State=x27 Parent={1;6}, EM=2592, PP0=4960

Data TitleQLB_OBJECT_DESC PID:2097 Node:000
0001 0006 0001 0006 8000 0000 0954 1657 .............T.W
3994 0000 0000 0000 0000 0a20 0000 0020 9.......... ...

After couple of errors like this it generated this message and wrote in to dump files, also it stopped logging to db2diag.log

2004-08-13-10.26.43.313210 Instance:INSTANCE Node:000
PID:2097(db2agntp (ALIAS)) Appid:82010A77.08F2.040813145123
relation_data_serv sqlrr_signal_handler Probe:10 DatabaseATABASE
DIA7107I Execution of a component signal handling function has begun.
Dump File:/usr/udb/duip501/sqllib/db2dump/2097.000 Data:Recursive dump_sect
Dump File:/usr/udb/duip501/sqllib/db2dump/2097.000 Data:PACKAGE ENTRY
Dump File:/usr/udb/duip501/sqllib/db2dump/2097.000 Data:USED_IN_UOW BIT VECTOR
Dump File:/usr/udb/duip501/sqllib/db2dump/2097.000 DataECTION NUMBER
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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