Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    22

    Arrow Unanswered: 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
    **************************************

  2. #2
    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

Posting Permissions

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