Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    84

    Unanswered: database manager crashes - help needed

    UDB V8.1 AIX -
    we are creating views with no. of columns > 100 and there are read activity on the db. There are no updates on inserts occurring.
    We have seen the database manager crashing twice.
    When I do a list applications it shows some applications but these cannot be forced by using the force application.
    When we try to db2stop it says that applications are connected to the db and hence cannot be stopped.
    We had to reboot in order to get db2 up again.
    I don't have much clue to the root of the problem. Any help is much appreciated. I am enclosing excerpts of the diagonostic data.

    db2diag.log
    -----------
    2004-09-16-13.04.18.618867 Instance:db2inst2 Node:000
    PID:35770(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A15.GF0A.009946070225
    routine_infrastructure sqlerGetFmpThread Probe:20 Database:ORDWDDB2

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0xFFFFFBEE".

    2004-09-16-13.04.18.624550 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    routine_infrastructure sqlerMasterThreadReq Probe:10 Database:ORDWDDB2

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0xFFFFFBEE".

    2004-09-16-13.04.18.625747 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    routine_infrastructure sqlerGetFmpThread Probe:20 Database:ORDWDDB2

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0xFFFFFBEE".

    2004-09-16-13.04.18.654280 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:1 Database:ORDWDDB2

    Error in agent servicing application with coor_node:0000 ..

    2004-09-16-13.04.18.655365 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:2 Database:ORDWDDB2

    Error in agent servicing application with coor_agent_index:0191 ..

    2004-09-16-13.04.18.656266 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:3 Database:ORDWDDB2

    Error in agent servicing application with CLIENT PID:3231 3838 2188

    2004-09-16-13.04.18.657163 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:4 Database:ORDWDDB2

    Error in agent servicing application with INBOUND APPLICATION ID:4330 4138 3141 3143 2e4b 3130 352e 3031 C0A81A1C.K105.01
    3131 4336 3037 3032 3138 11C6070218

    2004-09-16-13.04.18.658348 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:5 Database:ORDWDDB2

    Error in agent servicing application with INBOUND SEQUENCE NUMBER:0001 ..

    2004-09-16-13.04.18.659243 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:6 Database:ORDWDDB2

    Error in agent servicing application with OUTBOUND APPLICATION ID:

    2004-09-16-13.04.18.660134 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:7 Database:ORDWDDB2

    Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

    2004-09-16-13.04.18.661027 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:8 Database:ORDWDDB2

    Error in agent servicing application with AUTHORIZATION ID:4154 5452 5553 4552 0000 0000 0000 0000 ATTRUSER........
    0000 0000 0000 0000 0000 0000 0000 00 ...............

    2004-09-16-13.04.18.662330 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:9 Database:ORDWDDB2

    Error in agent servicing application with PRODUCT SIGNATURE:5351 4c30 3830 3132 SQL08012

    2004-09-16-13.04.18.663233 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    base sys utilities sqleagnt_sigsegvh Probe:10 Database:ORDWDDB2

    Error in agent servicing application with APPLICATION NAME:6462 3262 702e 6578 65 db2bp.exe

    2004-09-16-13.04.18.671230 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    oper system services sqloEDUCodeTrapHandler Probe:10 Database:ORDWDDB2

    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-09-16-13.04.18.679729 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    oper system services sqloEDUCodeTrapHandler Probe:20 Database:ORDWDDB2

    Signal number received
    0000 000b ....

    PID:40150 TID:1 Node:000 Title: siginfo_t...

    0000 000b 0000 0000 0000 0032 0000 0000 ...........2....
    0000 0000 a014 8034 0000 0000 0000 0000 ....*..4........
    0000 0000 0000 0000 0000 0000 0000 0000 ................
    0000 0000 0000 0000 0000 0000 0000 0000 ................

    2004-09-16-13.04.18.693478 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    relation data serv sqlrr_signal_handler Probe:10 Database:ORDWDDB2

    DIA0505I Execution of a component signal handling function has begun.


    Dump File:/bis4/db2inst2/sqllib/db2dump/401501.000 Data:RDS AGENT CB

    PID:40150 TID:1 Node:000 Title: SQLCA
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQL08010
    sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:


    PID:40150 TID:1 Node:000 Title: RDS UCINTFC: pCurrentPID =
    2023 6f98 #o.

    PID:40150 TID:1 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =
    4e55 4c4c 4944 2020 NULLID

    PID:40150 TID:1 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbcolidLen =
    0008 ..

    PID:40150 TID:1 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbname =
    4f52 4457 4444 4232 2020 2020 2020 2020 ORDWDDB2
    2020

    PID:40150 TID:1 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgname =
    5351 4c43 3245 3033 2020 2020 2020 2020 SQLC2E03
    2020

    PID:40150 TID:1 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgcnstkn =
    4141 4141 414a 4852 AAAAAJHR

    PID:40150 TID:1 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgsn =
    00c9 .


    2004-09-16-13.04.18.723723 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    relation data serv sqlrr_dump_ffdc Probe:20 Database:ORDWDDB2

    DIA8516C A severe internal processing error has occurred.
    ZRC=0x87120007


    db2inst2.nfy
    ------------

    2004-09-16-13.04.18.671230 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    oper system services sqloEDUCodeTrapHandler Probe:10 Database:ORDWDDB2

    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-09-16-13.04.18.718903 Instance:db2inst2 Node:000
    PID:40150(db2agent (ORDWDDB2) 0) TID:1 Appid:C0A81A1C.K105.0111C6070218
    relation data serv sqlrr_dump_ffdc Probe:10 Database:ORDWDDB2

    ADM0001C A severe error has occurred. Examine the administration notification
    log and contact IBM Support if necessary.
    
    2004-09-16-13.04.27.760365 Instance:db2inst2 Node:000
    PID:16566(db2gds 0) TID:1 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.

  2. #2
    Join Date
    Sep 2003
    Posts
    84
    can someone help me with this diagnostic ?

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Only IBM can
    Contact IBM support and open a PMR
    Last edited by sathyaram_s; 09-17-04 at 10:24.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Sep 2003
    Posts
    84
    Very interesting choice of icons!!!

  5. #5
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61
    hi,

    i am using DB2 8.1.5 under AIX 5.1 ML 5 and RHL 9

    i had db2 system crash, this happend when i used 16 k tablespace only

    can u check the OS errors ( login as root , errpt -a )
    it may give you an indication
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

Posting Permissions

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