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 > HELP!!! DIA8402C A disk error has occurred

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-05-04, 22:38
huyuhui huyuhui is offline
Registered User
 
Join Date: Apr 2004
Posts: 22
Arrow HELP!!! DIA8402C A disk error has occurred

What does DIA8402C mean?
Is it dangerous?????

Sometims when i did reorg tables , i found that the tablespace which the reorged table in would become full, when the tablespace was full ,i got the 'DIA8402C A disk error has occurred' .
Sometimes I executed a procedure, I could got same error message.
Sometimes I do LOAD,I could got same error message.

OS: linux as 3 core 2.6
HOSTELL 6650 +SAN CX200
DB: DB2 V8 ,FP6, the tablespace containers is raw device.

************************
"db2diag.log"

2004-06-30-15.18.28.296202 Instance:biw Node:000
PID:19892(db2pfchr) TID:1130027744 Appid:none
oper system services sqlobufreset Probe:100
errno:
0xBFFFCC50 : 0x00000005 ....

2004-06-30-15.18.28.332719 Instance:biw Node:000
PID:19892(db2pfchr) TID:1130027744 Appid:none
buffer pool services sqlbSMSTruncateObject Probe:820

DIA8402C A disk error has occurred.
ZRC=0x860F0003

2004-06-30-15.18.28.344631 Instance:biw Node:000
PID:19892(db2pfchr) TID:1130027744 Appid:none
buffer pool services sqlbSMSTruncateObject Probe:820

Obj={pool:1;obj:2;type:128} State=x37 Page=32 Cont=0

PID:19892 TID:1130027744 Node:000 Title: SQLB_OBJECT_DESC
0x7F147FB0 : 0100 0200 0100 0200 8000 0000 1508 2985 ..............).
0x7F147FC0 : 1808 0000 0000 0000 0000 0000 0000 0000 ................
0x7F147FD0 : 0000 0000 1101 0000 3700 0000 0000 0000 ........7.......
0x7F147FE0 : 0010 0000 2000 0000 0100 0000 0100 0280 .... ...........
0x7F147FF0 : B096 6F50 ..oP

2004-06-30-15.18.28.356391 Instance:biw Node:000
PID:19892(db2pfchr) TID:1130027744 Appid:none
buffer pool services sqlbSMSDeleteObject Probe:860

DIA8402C A disk error has occurred.
ZRC=0x860F0003

2004-06-30-15.18.28.358736 Instance:biw Node:000
PID:19892(db2pfchr) TID:1130027744 Appid:none
buffer pool services sqlbSMSDeleteObject Probe:860

Obj={pool:1;obj:2;type:128} State=x37 Cont=0

PID:19892 TID:1130027744 Node:000 Title: SQLB_OBJECT_DESC
0x7F147FB0 : 0100 0200 0100 0200 8000 0000 1508 2985 ..............).
0x7F147FC0 : 1808 0000 0000 0000 0000 0000 0000 0000 ................
0x7F147FD0 : 0000 0000 1101 0000 3700 0000 0000 0000 ........7.......
0x7F147FE0 : 0010 0000 2000 0000 0100 0000 0100 0280 .... ...........
0x7F147FF0 : B096 6F50 ..oP

2004-06-30-15.18.28.363106 Instance:biw Node:000
PID:19892(db2pfchr) TID:1130027744 Appid:none
data management sqldDropTable Probe:468

DIA8402C A disk error has occurred.
ZRC=0x860F0003

PID:19892 TID:1130027744 Node:000 Title: SQLD_TCB:
Temp Table(1:2)=<2161><U00 >.TEMP (00001,00002)

PID:19892 TID:1130027744 Node:000 Title: SQLD_TCB_NAME.tcbSchemaName
Dump File:/u/biw/sqllib/db2dump/198921130027744.000

PID:19892 TID:1130027744 Node:000 Title: SQLD_TCB_NAME.tcbTableName
Dump File:/u/biw/sqllib/db2dump/198921130027744.000

PID:19892 TID:1130027744 Node:000 Title: SQLD_TCB
Dump File:/u/biw/sqllib/db2dump/198921130027744.000

PID:19892 TID:1130027744 Node:000 Title: SQLD_COLUMN
Dump File:/u/biw/sqllib/db2dump/198921130027744.000

2004-06-30-15.18.28.393917 Instance:biw Node:000
PID:19892(db2pfchr) TID:1130027744 Appid:none
base sys utilities sqle_panic Probe:10

sqle_panic: Panic/sleep =
0x10008160 : 0x00000000 ....

2004-06-30-15.18.28.406119 Instance:biw Node:000
PID:19892(db2pfchr) TID:1130027744 Appid:none
oper system services sqloEDUCodeTrapHandler Probe:10

ADM0503C An unexpected internal processing error has occurred. ALL DB2
PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Diagnostic
information has been recorded. Contact IBM Support for further assistance.

2004-06-30-15.18.28.410273 Instance:biw Node:000
PID:19892(db2pfchr) TID:1130027744 Appid:none
oper system services sqloEDUCodeTrapHandler Probe:20

Signal number received

0xBFFFC884 : 0x00000006 ....

PID:19892 TID:1130027744 Node:000 Title: siginfo_t...

0xBFFFC890 : 0600 0000 0000 0000 FAFF FFFF B44D 0000 .............M..
0xBFFFC8A0 : F701 0000 B44D 0000 409A 2ECE 80A9 70C9 .....M..@.....p.
0xBFFFC8B0 : 00A0 A3F6 FC4A 3DF3 274E 20C0 FC4A 3DF3 .....J=.'N ..J=.
0xBFFFC8C0 : 800A FCF7 B882 16C0 0100 0000 0000 0000 ................
0xBFFFC8D0 : 0000 0000 AD5B 12C0 0000 0000 F2FF FFFF .....[..........
0xBFFFC8E0 : A81F 17F5 0000 0000 A01F 17F5 B65C 12C0 .............\..
0xBFFFC8F0 : 0100 0000 A81F 17F5 A01F 17F5 0000 0000 ................
0xBFFFC900 : 0000 0000 2000 0000 0000 0000 0100 0000 .... ...........

2004-06-30-15.18.28.519193 Instance:biw Node:000
PID:16178(db2gds) TID:1130027744 Appid:none
oper system services sqloEDUSIGCHLDHandler Probe:50

Detected the death of an EDU with process id 19892
The signal number that terminated this process was 6
Look for trap files (t19892.*) in the dump directory


2004-06-30-15.18.28.529687 Instance:biw Node:000
PID:16178(db2gds) TID:1130027744 Appid:none
oper system services sqloEDUCodeTrapHandler Probe:10

ADM0503C An unexpected internal processing error has occurred. ALL DB2
PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Diagnostic
information has been recorded. Contact IBM Support for further assistance.

2004-06-30-15.18.28.535133 Instance:biw Node:000
PID:16178(db2gds) TID:1130027744 Appid:none
oper system services sqloEDUCodeTrapHandler Probe:20

Signal number received

0xBFFFC9C4 : 0x00000006 ....

PID:16178 TID:1130027744 Node:000 Title: siginfo_t...

0xBFFFC9D0 : 0600 0000 0000 0000 FAFF FFFF 323F 0000 ............2?..
0xBFFFC9E0 : F701 0000 323F 0000 409A 2ECE 80A9 70C9 ....2?..@.....p.
0xBFFFC9F0 : 00A0 A3F6 FC4A 3DF3 274E 20C0 FC4A 3DF3 .....J=.'N ..J=.
0xBFFFCA00 : 800A FCF7 B882 16C0 0100 0000 0000 0100 ................
0xBFFFCA10 : 0000 0000 AD5B 12C0 0000 0000 F2FF FFFF .....[..........
0xBFFFCA20 : A8FF 45CE 0000 0000 A0FF 45CE B65C 12C0 ..E.......E..\..
0xBFFFCA30 : 0100 0000 A8FF 45CE A0FF 45CE 0000 0100 ......E...E.....
0xBFFFCA40 : 0000 0000 2000 0000 0000 0000 0100 0000 .... ...........

2004-06-30-15.18.33.164070 Instance:biw Node:000
PID:16078(db2sysc) TID:1130027744 Appid:none
base sys utilities sqleChildCrashHandler Probe:15

DiagData
0x0805280C : 416E 2045 4455 2063 7261 7368 6564 2E An EDU crashed.

2004-06-30-15.18.33.170460 Instance:biw Node:000
PID:16078(db2sysc) TID:1130027744 Appid:none
base sys utilities sqleChildCrashHandler Probe:16

DiagData
0xBFFFD1E8 : 0x00003F32 2?..

2004-06-30-15.18.33.176235 Instance:biw Node:000
PID:16078(db2sysc) TID:1130027744 Appid:none
base sys utilities sqleChildCrashHandler Probe:17

DiagData
0xBFFFD1E0 : 0x00000101 ....

2004-06-30-15.18.33.181500 Instance:biw Node:000
PID:16078(db2sysc) TID:1130027744 Appid:none
base sys utilities sqleChildCrashHandler Probe:18

DiagData
0xBFFFD1E4 : 0xFFFFFFFF ....

2004-06-30-15.18.33.186095 Instance:biw Node:000
PID:16078(db2sysc) TID:1130027744 Appid:none
base sys utilities sqleChildCrashHandler Probe:19

DiagData
0xBFFFD1DC : 0xFFFFFC88 ....

2004-06-30-15.18.33.191712 Instance:biw Node:000
PID:16078(db2sysc) TID:1130027744 Appid:none
base sys utilities sqleSysCtlr Probe:10

DiagData
0xBFFFD484 : 0x00000001 ....

2004-06-30-15.18.33.611823 Instance:biw Node:000
PID:16009(db2wdog) TID:1130027744 Appid:none
oper system services sqloRunInstance Probe:490

ADM0503C An unexpected internal processing error has occurred. ALL DB2
PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Diagnostic
information has been recorded. Contact IBM Support for further assistance.

2004-06-30-15.18.34.645478 Instance:biw Node:000
PID:16009(db2wdog) TID:1130027744 Appid:none
oper system services sqloRunInstance Probe:500

DiagData
0xBFFFD684 : 0x0000000900000102 ........

2004-06-30-15.18.34.655146 Instance:biw Node:000
PID:16009(db2wdog) TID:1130027744 Appid:none
base sys utilities sqleCleanupResources Probe:5

DiagData
0xBFFFD494 : 0x00000102 ....

2004-06-30-15.20.06.795733 Instance:biw Node:000
PID:20607(db2star2) TID:1130027680 Appid:none
base sys utilities DB2StartMain Probe:911

ADM7513W Database manager has started.

2004-06-30-15.20.10.787020 Instance:biw Node:000
PID:20710(db2agent (BIW)) TID:1130027744 Appid:*LOCAL.biw.05A250072010
base sys utilities sqledint Probe:30 Database:BIW

Crash Recovery is needed.

2004-06-30-15.20.14.411224 Instance:biw Node:000
PID:20710(db2agent (BIW)) TID:1130027744 Appid:*LOCAL.biw.05A250072010
recovery manager sqlpresr Probe:410 Database:BIW

Crash recovery started. LowtranLSN 000000F2215DA85A MinbuffLSN 000000F22149F543

2004-06-30-15.20.14.418773 Instance:biw Node:000
PID:20710(db2agent (BIW)) TID:1130027744 Appid:*LOCAL.biw.05A250072010
recovery manager sqlprecm Probe:2000 Database:BIW

Using parallel recovery with 9 agents 6 QSets 48 queues and 64 chunks


2004-06-30-15.20.23.888515 Instance:biw Node:000
PID:20711(db2loggr (BIW)) TID:1130027744 Appid:none
data protection sqlpgarl Probe:8150

Flushing pong page at index 38073 to disk for extent 1.
__________________
**************************************
Make progress everyday
Mail: hoo.jimmy@gmail.com
**************************************
Reply With Quote
  #2 (permalink)  
Old 07-06-04, 11:42
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
I have seen during the reorganization the demand for tablespace increases 1.5-2 times the size of the table . you can use another tablespace during the reorg command.

regards,

mujeeb
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