Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    10

    Unanswered: Crash: db2syscs.exe - application error

    I am running DB2 UDB FP11 on windows 2000. Have created a UDF with trigger. When I update the column that triggers the UDF, DB2 crashes with the subject application error and returns error:

    SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command.
    SQLSTATE=55032

    An excerpt from my db2diag.log is:



    Attempting to load JNI Name:
    633a 5c70 726f 6772 617e 315c 7371 6c6c c:\progra~1\sqll
    6962 5c6a 6176 615c 6a61 7661 3132 5c6a ib\java\java12\j
    646b 5c6a 7265 5c62 696e 5c63 6c61 7373 dk\jre\bin\class
    6963 5c6a 766d 2e64 6c6c ic\jvm.dll


    2004-02-13-14.35.24.220000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    oper_system_services sqloJVMstart Probe:21 Database:MEH

    Path given to the jvm
    433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
    4942 5c6a 6176 615c 4442 324a 4156 412e IB\java\DB2JAVA.
    5a49 503b 433a 5c50 524f 4752 417e 315c ZIP;C:\PROGRA~1\
    5351 4c4c 4942 5c6a 6176 615c 7371 6c6a SQLLIB\java\sqlj
    2e7a 6970 3b43 3a5c 5052 4f47 5241 7e31 .zip;C:\PROGRA~1
    5c53 514c 4c49 425c 6a61 7661 5c72 756e \SQLLIB\java\run
    7469 6d65 2e7a 6970 3b63 3a5c 7072 6f67 time.zip;c:\prog
    7261 7e31 5c73 716c 6c69 625c 6a61 7661 ra~1\sqllib\java
    5c6a 6176 6131 325c 6a64 6b5c 6a72 655c \java12\jdk\jre\
    6c69 623b 633a 5c70 726f 6772 617e 315c lib;c:\progra~1\
    7371 6c6c 6962 5c6a 6176 615c 6a61 7661 sqllib\java\java
    3132 5c6a 646b 5c6a 7265 5c6c 6962 5c72 12\jdk\jre\lib\r
    742e 6a61 723b 633a 5c70 726f 6772 617e t.jar;c:\progra~
    315c 7371 6c6c 6962 5c6a 6176 615c 6a61 1\sqllib\java\ja
    7661 3132 5c6a 646b 5c6a 7265 5c6c 6962 va12\jdk\jre\lib
    5c69 3138 6e2e 6a61 723b 633a 5c70 726f \i18n.jar;c:\pro
    6772 617e 315c 7371 6c6c 6962 5c6a 6176 gra~1\sqllib\jav
    615c 6a61 7661 3132 5c6a 646b 5c6a 7265 a\java12\jdk\jre
    5c6c 6962 5c74 6f6f 6c73 2e6a 6172 3b \lib\tools.jar;


    2004-02-13-14.35.24.381000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    oper_system_services sqloJVMstart Probe:40 Database:MEH

    About to start Java interpreter thread

    2004-02-13-14.35.24.401000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:1652 Appid:none
    oper_system_services sqloJVMstartEDU Probe:10

    Started Java interpreter thread. EDU parms:
    10b2 686c e0aa 5501 44ab 5501 88ac 5501 .hlU.DU.U.


    2004-02-13-14.35.24.431000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:1652 Appid:none
    oper_system_services sqloJVMstartEDU Probe:15

    About to call JNI_CreateJavaVM. JDK 1.1 args:
    0100 0100 b4c6 686c 0000 0000 0000 0000 ....hl........
    0040 0600 0000 0000 0000 0001 0100 0000 .@..............
    30c0 9301 c0f8 606c 10f7 606c 90f5 606c 0.`l.`l.`l
    0100 0000 0000 0000 0100 0000 0000 0000 ................
    0000 0000 0000 0000 ........


    2004-02-13-14.35.24.711000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:1652 Appid:none
    oper_system_services sqloJVMstartEDU Probe:25

    Java interpreter is running.

    2004-02-13-14.35.25.232000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    BSU Java support sqlejReload Probe:14 Database:MEH

    loaderValidate: 0000 0000 ....


    2004-02-13-14.35.25.272000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    BSU Java support sqlejGetPaths Probe:11 Database:MEH

    C:\PROGRA~1\SQLLIB

    2004-02-13-14.35.25.302000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    oper_system_services sqlofindn Probe:100 Database:MEH

    GetLastError: 1200 0000 ....


    2004-02-13-14.35.25.352000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    BSU Java support sqlejGetPaths Probe:61 Database:MEH

    C:\Program Files\MQSeries\JavaJMS\Lib;.;C:\Program Files\SQLLIB\java\db2java.zip;C:\Program Files\SQLLIB\java\runtime.zip;C:\Program Files\SQLLIB\bin

    2004-02-13-14.35.25.402000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    BSU Java support sqlejReload Probe:43 Database:MEH

    class loader path 433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
    4942 5c66 756e 6374 696f 6e3b 433a 5c50 IB\function;C:\P
    726f 6772 616d 2046 696c 6573 5c4d 5153 rogram Files\MQS
    6572 6965 735c 4a61 7661 4a4d 535c 4c69 eries\JavaJMS\Li
    623b 2e3b 433a 5c50 726f 6772 616d 2046 b;.;C:\Program F
    696c 6573 5c53 514c 4c49 425c 6a61 7661 iles\SQLLIB\java
    5c64 6232 6a61 7661 2e7a 6970 3b43 3a5c \db2java.zip;C:\
    5072 6f67 7261 6d20 4669 6c65 735c 5351 Program Files\SQ
    4c4c 4942 5c6a 6176 615c 7275 6e74 696d LLIB\java\runtim
    652e 7a69 703b 433a 5c50 726f 6772 616d e.zip;C:\Program
    2046 696c 6573 5c53 514c 4c49 425c 6269 Files\SQLLIB\bi
    6e n


    2004-02-13-14.35.25.652000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    oper_system_services sqloopenp Probe:120 Database:MEH

    GetLastError: 0200 0000 ....


    String Title:Path/Filename PID:1284 Node:000
    C:\PROGRA~1\SQLLIB/conv/1252ucs2.cnv

    2004-02-13-14.35.25.793000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

    Error in agent servicing application with coor_node:0000 ..


    2004-02-13-14.35.25.823000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

    Error in agent servicing application with coor_agent_index:0000 ..


    2004-02-13-14.35.25.853000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

    Error in agent servicing application with CLIENT PID:3136 3634 1664


    2004-02-13-14.35.25.893000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

    Error in agent servicing application with INBOUND APPLICATION ID:2a4c 4f43 414c 2e44 4232 2e30 3430 3231 *LOCAL.DB2.04021
    3331 3933 3530 38 3193508


    2004-02-13-14.35.25.963000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

    Error in agent servicing application with INBOUND SEQUENCE NUMBER:3030 3031 0001


    2004-02-13-14.35.26.013000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

    Error in agent servicing application with OUTBOUND APPLICATION ID:

    2004-02-13-14.35.26.103000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

    Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

    2004-02-13-14.35.26.173000 Instance:DB2 Node:000
    PID:1284(db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.040213193508
    base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

    Error in agent servicing application with AUTHORIZATION ID:5445 4e4e 4953 2020 0000 0000 0000 0000 TENNIS ........
    0000 0000 0000 0000 0000 0000 0000 00 ...............



    Can someone please give me a clue as to what the problem is.
    Thank you.

    MarvL

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    FP11

    hi.

    Can you please elighthen us with your db2version.

    Cheers

    Nitin
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Feb 2004
    Posts
    10

    Crash: db2syscs.exe - application error

    Sorry. DB2 UDB 7.2 FixPack 11. Windows 2000.

Posting Permissions

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