My Data Warehouse is Crashing!

I've had my data warehouse crash 3 times in the last 3 days. The last
thing a DBA did was start a large load process. We have a number of SAS
users hitting the database all the time as well as a good number of
Database Marketing personnel running ad-hoc queries.

Can anyone see anything that pops-out and makes sense to you?

Starting LOAD phase at 06-29-2006 09:47:12.819319. Table MK
.PROSPECTS_200606

2006-06-29-10.13.50.929415 Instance:dbw1 Node:000

PID:1101918(db2agntp (Q1)) Appid:AC110285.BDCA.060629141412

buffer_Q_services sqlkqopn Probe:60 Database:Q1

DIA9999E An internal error occurred. Report the following error code :

"alloc_rqb conn=0".

2006-06-29-10.13.51.053346 Instance:dbw1 Node:000

PID:1101918(db2agntp (Q1)) Appid:AC110285.BDCA.060629141412

table_Q_services sqlktopn Probe:160 Database:Q1

DIA9999E An internal error occurred. Report the following error code :

"Line=01733, rc1=0xFFFFDC29, rc2=0x00000001, rc3=0, msg=sqlkqopn()".

Dump File:/dbwork/db2diag/dbw1/1101918.000 Data:TAOB

Dump File:/dbwork/db2diag/dbw1/1101918.000 Data:PEOB

Dump File:/dbwork/db2diag/dbw1/1101918.000 Data:TQOB

Dump File:/dbwork/db2diag/dbw1/1101918.000 Data:SMP_TQ_INFO

Dump File:/dbwork/db2diag/dbw1/1101918.000 Data:TQCONN

Dump File:/dbwork/db2diag/dbw1/1101918.000 Data:TQS_CB

Dump File:/dbwork/db2diag/dbw1/1101918.000 Data:TQS_MEM

2006-06-29-10.13.51.429896 Instance:dbw1 Node:000

PID:1667186(db2agntp (Q1)) Appid:AC110285.BDCA.060629141412

buffer_Q_services sqlkqopn Probe:60 Database:Q1

DIA9999E An internal error occurred. Report the following error code :

"alloc_rqb conn=0".

2006-06-29-10.13.51.459482 Instance:dbw1 Node:000

PID:1667186(db2agntp (Q1)) Appid:AC110285.BDCA.060629141412

table_Q_services sqlktopn Probe:160 Database:Q1

DIA9999E An internal error occurred. Report the following error code :

"Line=01733, rc1=0xFFFFDC29, rc2=0x00000001, rc3=0, msg=sqlkqopn()".

Dump File:/dbwork/db2diag/dbw1/1667186.000 Data:TAOB

Dump File:/dbwork/db2diag/dbw1/1667186.000 Data:PEOB

Dump File:/dbwork/db2diag/dbw1/1667186.000 Data:TQOB

Dump File:/dbwork/db2diag/dbw1/1667186.000 Data:SMP_TQ_INFO

Dump File:/dbwork/db2diag/dbw1/1667186.000 Data:TQCONN

Dump File:/dbwork/db2diag/dbw1/1667186.000 Data:TQS_CB

Dump File:/dbwork/db2diag/dbw1/1667186.000 Data:TQS_MEM

2006-06-29-10.13.51.610611 Instance:dbw1 Node:000

PID:1802252(db2agent (Q1)) Appid:AC110285.BDCA.060629141412

oper_system_services sqlofmblk Probe:21 Database:Q1

DiagData

200c 8652 ..R

Douglas Kostelnik

Senior Database Administrator/Architect

AAA Auto Club South

<html>
 <align=justify> 
_____________________________________________________________ 
The information transmitted is intended only for the person(s) or entity to which it is addressed and may contain confidential and or privileged material and should be treated as a confidential AAA Auto Club South communication. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
</html>

DB2 & UDB email list listserv db2-l LazyDBA home page