By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,787 Members | 2,251 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,787 IT Pros & Developers. It's quick & easy.

SQL1224N A database agent could not be started to service a request

P: n/a
Hi All:

I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I
have created a java UDF and trigger. When I update my database I get
the following 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

which is followed by a db2syscs.exe Appllication error.

Can anyone give me a clue as to what the problem might be. My
db2diag.log contains:

2004-02-16-15.45.42.726000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejCallUDF Probe:101 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-16-15.45.42.846000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejSuffixEnv Probe:20 Database:MEH

Setting environment variable:
5041 5448 PATH
2004-02-16-15.45.42.856000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejSuffixEnv Probe:21 Database:MEH

New value:
443a 5c5c 496f 6e61 5c62 696e 3b44 3a5c D:\\Iona\bin;D:\
5c49 6f6e 615c 746f 6f6c 735c 6a72 653b \Iona\tools\jre;
443a 5c5c 496f 6e61 5c43 4f4d 6574 5c62 D:\\Iona\COMet\b
696e 3b43 3a5c 5749 4e4e 545c 7379 7374 in;C:\WINNT\syst
656d 3332 3b43 3a5c 5749 4e4e 543b 433a em32;C:\WINNT;C:
5c57 494e 4e54 5c53 7973 7465 6d33 325c \WINNT\System32\
5762 656d 3b43 3a5c 5749 4e4e 545c 5359 Wbem;C:\WINNT\SY
5354 454d 3332 3b43 3a5c 5749 4e4e 543b STEM32;C:\WINNT;
433a 5c57 494e 4e54 5c53 5953 5445 4d33 C:\WINNT\SYSTEM3
325c 5742 454d 3b43 3a5c 5749 4e4e 545c 2\WBEM;C:\WINNT\
5359 5354 454d 3332 3b43 3a5c 5749 4e4e SYSTEM32;C:\WINN
543b 433a 5c57 494e 4e54 5c53 5953 5445 T;C:\WINNT\SYSTE
4d33 325c 5742 454d 3b43 3a5c 5072 6f67 M32\WBEM;C:\Prog
7261 7e31 5c50 6572 736f 6e61 6c20 436f ra~1\Personal Co
6d6d 756e 6963 6174 696f 6e73 3b43 3a5c mmunications;C:\
4e6f 7465 733b 453a 5c55 7469 6c69 7469 Notes;E:\Utiliti
6573 3b43 3a5c 494d 4e6e 715f 4e54 3b43 es;C:\IMNnq_NT;C
3a5c 4a44 4b31 2e33 5c62 696e 3b43 3a5c :\JDK1.3\bin;C:\
5072 6f67 7261 6d20 4669 6c65 735c 4d51 Program Files\MQ
5365 7269 6573 5c4a 6176 614a 4d53 5c6c Series\JavaJMS\l
6962 3b43 3a5c 5072 6f67 7261 6d20 4669 ib;C:\Program Fi
6c65 735c 4d51 5365 7269 6573 5c4a 6176 les\MQSeries\Jav
614a 4d53 5c6c 6962 3b43 3a5c 5072 6f67 aJMS\lib;C:\Prog
7261 6d20 4669 6c65 735c 4d51 5365 7269 ram Files\MQSeri
6573 5c74 6f6f 6c73 5c63 5c73 616d 706c es\tools\c\sampl
6573 5c62 696e 3b43 3a5c 5072 6f67 7261 es\bin;C:\Progra
6d20 4669 6c65 735c 4d51 5365 7269 6573 m Files\MQSeries
5c62 696e 3b43 3a5c 5072 6f67 7261 6d20 \bin;C:\Program
4669 6c65 735c 4f62 6a52 4558 583b 433a Files\ObjREXX;C:
5c50 726f 6772 616d 2046 696c 6573 5c4f \Program Files\O
626a 5245 5858 5c4f 4f44 4941 4c4f 473b bjREXX\OODIALOG;
443a 5c57 4e45 5446 494e 3b43 3a5c 5072 D:\WNETFIN;C:\Pr
6f67 7261 6d20 4669 6c65 735c 5351 4c4c ogram Files\SQLL
4942 5c42 494e 3b43 3a5c 5072 6f67 7261 IB\BIN;C:\Progra
6d20 4669 6c65 735c 5351 4c4c 4942 5c46 m Files\SQLLIB\F
554e 4354 494f 4e3b 433a 5c50 726f 6772 UNCTION;C:\Progr
616d 2046 696c 6573 5c53 514c 4c49 425c am Files\SQLLIB\
5341 4d50 4c45 535c 5245 504c 3b43 3a5c SAMPLES\REPL;C:\
5072 6f67 7261 6d20 4669 6c65 735c 5351 Program Files\SQ
4c4c 4942 5c48 454c 503b 633a 5c70 726f LLIB\HELP;c:\pro
6772 617e 315c 7371 6c6c 6962 5c6a 6176 gra~1\sqllib\jav
615c 6a61 7661 3132 5c6a 646b 5c62 696e a\java12\jdk\bin
2004-02-16-15.45.43.097000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejGetBlocks Probe:22 Database:MEH

Attempting to load JEXT DLL Path:
433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
4942 5c62 696e IB\bin
2004-02-16-15.45.43.137000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejGetBlocks Probe:27 Database:MEH

Attempting to load JEXT DLL Name:
433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
4942 5c62 696e 5c44 4232 4a45 5854 2e44 IB\bin\DB2JEXT.D
4c4c LL
2004-02-16-15.45.43.367000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejResolveUDFLob Probe:5 Database:MEH

Attempting to load APIE DLL Path:
433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
4942 5c62 696e IB\bin
2004-02-16-15.45.43.407000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejResolveUDFLob Probe:6 Database:MEH

Attempting to load APIE DLL Name:
433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
4942 5c62 696e 5c44 4232 454e 474e 2e44 IB\bin\DB2ENGN.D
4c4c LL
2004-02-16-15.45.43.668000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloSuffixEnv Probe:20 Database:MEH

Setting environment variable:
5041 5448 PATH
2004-02-16-15.45.43.708000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloSuffixEnv Probe:21 Database:MEH

New value:
443a 5c5c 496f 6e61 5c62 696e 3b44 3a5c D:\\Iona\bin;D:\
5c49 6f6e 615c 746f 6f6c 735c 6a72 653b \Iona\tools\jre;
443a 5c5c 496f 6e61 5c43 4f4d 6574 5c62 D:\\Iona\COMet\b
696e 3b43 3a5c 5749 4e4e 545c 7379 7374 in;C:\WINNT\syst
656d 3332 3b43 3a5c 5749 4e4e 543b 433a em32;C:\WINNT;C:
5c57 494e 4e54 5c53 7973 7465 6d33 325c \WINNT\System32\
5762 656d 3b43 3a5c 5749 4e4e 545c 5359 Wbem;C:\WINNT\SY
5354 454d 3332 3b43 3a5c 5749 4e4e 543b STEM32;C:\WINNT;
433a 5c57 494e 4e54 5c53 5953 5445 4d33 C:\WINNT\SYSTEM3
325c 5742 454d 3b43 3a5c 5749 4e4e 545c 2\WBEM;C:\WINNT\
5359 5354 454d 3332 3b43 3a5c 5749 4e4e SYSTEM32;C:\WINN
543b 433a 5c57 494e 4e54 5c53 5953 5445 T;C:\WINNT\SYSTE
4d33 325c 5742 454d 3b43 3a5c 5072 6f67 M32\WBEM;C:\Prog
7261 7e31 5c50 6572 736f 6e61 6c20 436f ra~1\Personal Co
6d6d 756e 6963 6174 696f 6e73 3b43 3a5c mmunications;C:\
4e6f 7465 733b 453a 5c55 7469 6c69 7469 Notes;E:\Utiliti
6573 3b43 3a5c 494d 4e6e 715f 4e54 3b43 es;C:\IMNnq_NT;C
3a5c 4a44 4b31 2e33 5c62 696e 3b43 3a5c :\JDK1.3\bin;C:\
5072 6f67 7261 6d20 4669 6c65 735c 4d51 Program Files\MQ
5365 7269 6573 5c4a 6176 614a 4d53 5c6c Series\JavaJMS\l
6962 3b43 3a5c 5072 6f67 7261 6d20 4669 ib;C:\Program Fi
6c65 735c 4d51 5365 7269 6573 5c4a 6176 les\MQSeries\Jav
614a 4d53 5c6c 6962 3b43 3a5c 5072 6f67 aJMS\lib;C:\Prog
7261 6d20 4669 6c65 735c 4d51 5365 7269 ram Files\MQSeri
6573 5c74 6f6f 6c73 5c63 5c73 616d 706c es\tools\c\sampl
6573 5c62 696e 3b43 3a5c 5072 6f67 7261 es\bin;C:\Progra
6d20 4669 6c65 735c 4d51 5365 7269 6573 m Files\MQSeries
5c62 696e 3b43 3a5c 5072 6f67 7261 6d20 \bin;C:\Program
4669 6c65 735c 4f62 6a52 4558 583b 433a Files\ObjREXX;C:
5c50 726f 6772 616d 2046 696c 6573 5c4f \Program Files\O
626a 5245 5858 5c4f 4f44 4941 4c4f 473b bjREXX\OODIALOG;
443a 5c57 4e45 5446 494e 3b43 3a5c 5072 D:\WNETFIN;C:\Pr
6f67 7261 6d20 4669 6c65 735c 5351 4c4c ogram Files\SQLL
4942 5c42 494e 3b43 3a5c 5072 6f67 7261 IB\BIN;C:\Progra
6d20 4669 6c65 735c 5351 4c4c 4942 5c46 m Files\SQLLIB\F
554e 4354 494f 4e3b 433a 5c50 726f 6772 UNCTION;C:\Progr
616d 2046 696c 6573 5c53 514c 4c49 425c am Files\SQLLIB\
5341 4d50 4c45 535c 5245 504c 3b43 3a5c SAMPLES\REPL;C:\
5072 6f67 7261 6d20 4669 6c65 735c 5351 Program Files\SQ
4c4c 4942 5c48 454c 503b 633a 5c70 726f LLIB\HELP;c:\pro
6772 617e 315c 7371 6c6c 6962 5c6a 6176 gra~1\sqllib\jav
615c 6a61 7661 3132 5c6a 646b 5c62 696e a\java12\jdk\bin
3b63 3a5c 7072 6f67 7261 7e31 5c73 716c ;c:\progra~1\sql
6c69 625c 6a61 7661 5c6a 6176 6131 325c lib\java\java12\
6a64 6b5c 6a72 655c 6269 6e5c 636c 6173 jdk\jre\bin\clas
7369 633b 633a 5c70 726f 6772 617e 315c sic;c:\progra~1\
7371 6c6c 6962 5c6a 6176 615c 6a61 7661 sqllib\java\java
3132 5c6a 646b 5c6a 7265 5c62 696e 5c3b 12\jdk\jre\bin\;
2004-02-16-15.45.44.048000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloSuffixEnv Probe:20 Database:MEH

Setting environment variable:
5041 5448 PATH
2004-02-16-15.45.44.088000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloSuffixEnv Probe:21 Database:MEH

New value:
443a 5c5c 496f 6e61 5c62 696e 3b44 3a5c D:\\Iona\bin;D:\
5c49 6f6e 615c 746f 6f6c 735c 6a72 653b \Iona\tools\jre;
443a 5c5c 496f 6e61 5c43 4f4d 6574 5c62 D:\\Iona\COMet\b
696e 3b43 3a5c 5749 4e4e 545c 7379 7374 in;C:\WINNT\syst
656d 3332 3b43 3a5c 5749 4e4e 543b 433a em32;C:\WINNT;C:
5c57 494e 4e54 5c53 7973 7465 6d33 325c \WINNT\System32\
5762 656d 3b43 3a5c 5749 4e4e 545c 5359 Wbem;C:\WINNT\SY
5354 454d 3332 3b43 3a5c 5749 4e4e 543b STEM32;C:\WINNT;
433a 5c57 494e 4e54 5c53 5953 5445 4d33 C:\WINNT\SYSTEM3
325c 5742 454d 3b43 3a5c 5749 4e4e 545c 2\WBEM;C:\WINNT\
5359 5354 454d 3332 3b43 3a5c 5749 4e4e SYSTEM32;C:\WINN
543b 433a 5c57 494e 4e54 5c53 5953 5445 T;C:\WINNT\SYSTE
4d33 325c 5742 454d 3b43 3a5c 5072 6f67 M32\WBEM;C:\Prog
7261 7e31 5c50 6572 736f 6e61 6c20 436f ra~1\Personal Co
6d6d 756e 6963 6174 696f 6e73 3b43 3a5c mmunications;C:\
4e6f 7465 733b 453a 5c55 7469 6c69 7469 Notes;E:\Utiliti
6573 3b43 3a5c 494d 4e6e 715f 4e54 3b43 es;C:\IMNnq_NT;C
3a5c 4a44 4b31 2e33 5c62 696e 3b43 3a5c :\JDK1.3\bin;C:\
5072 6f67 7261 6d20 4669 6c65 735c 4d51 Program Files\MQ
5365 7269 6573 5c4a 6176 614a 4d53 5c6c Series\JavaJMS\l
6962 3b43 3a5c 5072 6f67 7261 6d20 4669 ib;C:\Program Fi
6c65 735c 4d51 5365 7269 6573 5c4a 6176 les\MQSeries\Jav
614a 4d53 5c6c 6962 3b43 3a5c 5072 6f67 aJMS\lib;C:\Prog
7261 6d20 4669 6c65 735c 4d51 5365 7269 ram Files\MQSeri
6573 5c74 6f6f 6c73 5c63 5c73 616d 706c es\tools\c\sampl
6573 5c62 696e 3b43 3a5c 5072 6f67 7261 es\bin;C:\Progra
6d20 4669 6c65 735c 4d51 5365 7269 6573 m Files\MQSeries
5c62 696e 3b43 3a5c 5072 6f67 7261 6d20 \bin;C:\Program
4669 6c65 735c 4f62 6a52 4558 583b 433a Files\ObjREXX;C:
5c50 726f 6772 616d 2046 696c 6573 5c4f \Program Files\O
626a 5245 5858 5c4f 4f44 4941 4c4f 473b bjREXX\OODIALOG;
443a 5c57 4e45 5446 494e 3b43 3a5c 5072 D:\WNETFIN;C:\Pr
6f67 7261 6d20 4669 6c65 735c 5351 4c4c ogram Files\SQLL
4942 5c42 494e 3b43 3a5c 5072 6f67 7261 IB\BIN;C:\Progra
6d20 4669 6c65 735c 5351 4c4c 4942 5c46 m Files\SQLLIB\F
554e 4354 494f 4e3b 433a 5c50 726f 6772 UNCTION;C:\Progr
616d 2046 696c 6573 5c53 514c 4c49 425c am Files\SQLLIB\
5341 4d50 4c45 535c 5245 504c 3b43 3a5c SAMPLES\REPL;C:\
5072 6f67 7261 6d20 4669 6c65 735c 5351 Program Files\SQ
4c4c 4942 5c48 454c 503b 633a 5c70 726f LLIB\HELP;c:\pro
6772 617e 315c 7371 6c6c 6962 5c6a 6176 gra~1\sqllib\jav
615c 6a61 7661 3132 5c6a 646b 5c62 696e a\java12\jdk\bin
3b63 3a5c 7072 6f67 7261 7e31 5c73 716c ;c:\progra~1\sql
6c69 625c 6a61 7661 5c6a 6176 6131 325c lib\java\java12\
6a64 6b5c 6a72 655c 6269 6e5c 636c 6173 jdk\jre\bin\clas
7369 633b 633a 5c70 726f 6772 617e 315c sic;c:\progra~1\
7371 6c6c 6962 5c6a 6176 615c 6a61 7661 sqllib\java\java
3132 5c6a 646b 5c6a 7265 5c62 696e 5c3b 12\jdk\jre\bin\;
3b43 3a5c 5052 4f47 5241 7e31 5c53 514c ;C:\PROGRA~1\SQL
4c49 425c 6269 6e LIB\bin
2004-02-16-15.45.44.359000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloJVMstart Probe:35 Database:MEH

Attempting to load JNI Path:
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 ic
2004-02-16-15.45.44.399000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloJVMstart Probe:27 Database:MEH

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-16-15.45.44.719000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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-16-15.45.44.879000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloJVMstart Probe:40 Database:MEH

About to start Java interpreter thread

2004-02-16-15.45.44.899000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2548 Appid:none
oper_system_services sqloJVMstartEDU Probe:10

Started Java interpreter thread. EDU parms:
10b2 686c e0aa b001 44ab b001 88ac b001 .hlર.D..
2004-02-16-15.45.44.919000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2548 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 0b02 c0f8 606c 10f7 606c 90f5 606c 0..`l.`l.`l
0100 0000 0000 0000 0100 0000 0000 0000 ................
0000 0000 0000 0000 ........
2004-02-16-15.45.47.894000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2548 Appid:none
oper_system_services sqloJVMstartEDU Probe:25

Java interpreter is running.

2004-02-16-15.45.48.394000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejReload Probe:14 Database:MEH

loaderValidate: 0000 0000 ....
2004-02-16-15.45.48.615000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejGetPaths Probe:11 Database:MEH

C:\PROGRA~1\SQLLIB

2004-02-16-15.45.48.735000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqlofindn Probe:100 Database:MEH

GetLastError: 1200 0000 ....
2004-02-16-15.45.48.775000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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-16-15.45.48.825000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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-16-15.45.48.975000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloopenp Probe:120 Database:MEH

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

2004-02-16-15.45.51.028000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with coor_node:0000
..
2004-02-16-15.45.51.058000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with coor_agent_index:1300
..
2004-02-16-15.45.51.098000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with CLIENT PID:3234 3936
2496
2004-02-16-15.45.51.158000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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
3632 3034 3231 37 6204217
2004-02-16-15.45.51.279000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with INBOUND SEQUENCE NUMBER:3030
3031 0001
2004-02-16-15.45.51.329000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with OUTBOUND APPLICATION ID:

2004-02-16-15.45.51.419000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

2004-02-16-15.45.51.499000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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 ...............
2004-02-16-15.45.51.629000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with PRODUCT SIGNATURE:5351 4c30
3730 3239 SQL07029
2004-02-16-15.45.51.749000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with APPLICATION NAME:6462 3262
702e 6578 65 db2bp.exe
2004-02-16-15.45.51.829000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:1 Database:MEH

value of ptr to db2ra_as_cb30c0 9801
0.
2004-02-16-15.45.51.909000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:2 Database:MEH

contents of db2ra_as_cb70fa b001 9007 ab00 0000 0000 0000 0000
p............
0000 0000 30c1 9801 0000 0000 0000 0000 ....0.........
0000 0000 0000 0000 3000 b701 0000 0000 ........0......
0000 0000 68c0 9801 0000 0000 0000 0000 ....h.........
5351 4c44 4232 5241 0200 0b00 0000 0000 SQLDB2RA........
0000 1000 0001 0000 5351 4c44 4232 5241 ........SQLDB2RA
0100 0300 0501 0a23 0000 0000 1600 0000 .......#........
0200 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 7c01 0000 0000 0000 0501 0a13 ....|...........
0501 0a23 0000 0501 0000 0000 0000 0000 ...#............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0200 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 ........
2004-02-16-15.45.52.060000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:3 Database:MEH

value of ptr to ccb0000 0000 ....
2004-02-16-15.45.52.100000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:6 Database:MEH

contents of comm_handle50c1 9801 1400 d301 0000 0000 0000 0000
P............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 00f0 0000 ...............
0001 0000 0000 0000 0000 0000 0001 0000 ................
0600 0000 0000 0000 ........
2004-02-16-15.45.52.240000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:7 Database:MEH

contents of comm_handle buffer0100 0000 7c01 0000 f400 0000 5351 4c44
....|......SQLD
4232 5241 e000 0000 0501 0200 0a00 0a00 B2RA...........
8800 0000 0900 0080 5cfd 1200 0000 0000 ... ..\......
0400 0040 0000 0000 0c00 0000 0400 0040 ...@...........@
a4f9 1200 0200 0000 0300 0040 44fd 1200 .........@D..
0800 0000 0100 0040 b041 ca00 0800 0000 .......@A.....
0100 0040 ca41 ca00 0800 0000 0100 0040 ...@A........@
b841 ca00 0000 0000 0000 0000 0000 0000 A.............
0000 0000 0000 0000 0000 0000 4000 0000 ............@...
0100 0040 40ac 4400 0000 0000 0000 0000 ...@@D.........
0000 0000 cb00 2020 5351 4c43 3244 3034 ..... SQLC2D04
4e55 4c4c 4944 2020 4141 4141 4151 4553 NULLID AAAAAQES
7570 6461 7465 2076 6170 2e65 7175 6970 update vap.equip
6d65 6e74 2073 6574 2074 6f6f 6c5f 7479 ment set tool_ty
7065 3d32 2077 6865 7265 2074 6f6f 6c5f pe=2 where tool_
6e61 6d65 3d27 5761 6665 724d 6172 6b27 name='WaferMark'
2004-02-16-15.45.52.490000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

size of receive request area7c01 0000
|...
2004-02-16-15.45.52.530000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:11 Database:MEH

contents of receive request area5351 4c44 4232 5241 e000 0000 0501
0200 SQLDB2RA.......
0a00 0a00 8800 0000 0900 0080 f0fb b001 ....... ...
0000 0000 0400 0040 0000 0000 0c00 0000 .......@........
0400 0040 bc00 b701 0200 0000 0300 0040 ...@.........@
c800 b701 0800 0000 0100 0040 cc00 b701 .........@..
0800 0000 0100 0040 d400 b701 0800 0000 .......@......
0100 0040 dc00 b701 0000 0000 0000 0000 ...@..........
0000 0000 0000 0000 0000 0000 0000 0000 ................
4000 0000 0100 0040 e400 b701 0000 0000 @......@......
0000 0000 0000 0000 cb00 2020 5351 4c43 ......... SQLC
3244 3034 4e55 4c4c 4944 2020 4141 4141 2D04NULLID AAAA
4151 4553 7570 6461 7465 2076 6170 2e65 AQESupdate vap.e
7175 6970 6d65 6e74 2073 6574 2074 6f6f quipment set too
6c5f 7479 7065 3d32 2077 6865 7265 2074 l_type=2 where t
6f6f 6c5f 6e61 6d65 3d27 5761 6665 724d ool_name='WaferM
6172 6b27 0000 0000 0400 0000 0200 0040 ark'...........@
7f02 b701 0000 0000 0000 0000 0000 0000 ...............
0000 0000 0100 0000 0000 0000 0200 0000 ................
0300 0000 8302 b701 0000 0000 0000 0000 ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0100 0000 0000 0000 0400 0000 0700 0000 ................
8502 b701 d102 0000 0000 0000 0000 0000 .............
0000 0000 0000 0000 0153 0001 .........S..
2004-02-16-15.45.52.831000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_signal_handler Probe:10 Database:MEH
DIA7107I Execution of a component signal handling function has begun.

2004-02-16-15.45.52.971000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:MEH
DIA3816C A severe internal processing error has occurred.

2004-02-16-15.45.52.991000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:MEH
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFF707".

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

Dump File:c:\db2log\12562044.000 Data:SQLCA
Dump File:c:\db2log\12562044.000 Data:DB2RA

Data Title:CREATOR PID:1256 TID:2044 Node:000
4e55 4c4c 4944 2020 NULLID
Data Title:PACKAGE PID:1256 TID:2044 Node:000
5351 4c43 3244 3034 SQLC2D04

Dump File:c:\db2log\12562044.000 Data:CREATOR
Dump File:c:\db2log\12562044.000 Data:PACKAGE
Dump File:c:\db2log\12562044.000 Data:REQUEST TYPE
Dump File:c:\db2log\12562044.000 Data:APM COMMON INFO
Dump File:c:\db2log\12562044.000 Data:PACKAGE ENTRY
Dump File:c:\db2log\12562044.000 Data:USED_IN_UOW BIT VECTOR
Dump File:c:\db2log\12562044.000 Data:Recursive dump_sect
Dump File:c:\db2log\12562044.000 Data:SECTION NUMBER
Dump File:c:\db2log\12562044.000 Data:SECTION DIR ENTRY
Dump File:c:\db2log\12562044.000 Data:cache cb

Data Title:section stmt PID:1256 TID:2044 Node:000
7570 6461 7465 2076 6170 2e65 7175 6970 update vap.equip
6d65 6e74 2073 6574 2074 6f6f 6c5f 7479 ment set tool_ty
7065 3d32 2077 6865 7265 2074 6f6f 6c5f pe=2 where tool_
6e61 6d65 3d27 5761 6665 724d 6172 6b27 name='WaferMark'

Dump File:c:\db2log\12562044.000 Data:section stmt
Dump File:c:\db2log\12562044.000 Data:sentptr
Dump File:c:\db2log\12562044.000 Data:sentptr->sectlen
Dump File:c:\db2log\12562044.000 Data:sentptr->cache_cb
Dump File:c:\db2log\12562044.000
Data:sentptr->cache_cb->cached_sectptr
Dump File:c:\db2log\12562044.000
Data:sentptr->cache_cb->cached_sectptr->thread_list
Dump File:c:\db2log\12562044.000 Data:calculated section size (1): not
including thread list
Dump File:c:\db2log\12562044.000 Data:calculated section size(2):
including thread structure
Dump File:c:\db2log\12562044.000 Data:thd_table
Dump File:c:\db2log\12562044.000 Data:thd_table->size
Dump File:c:\db2log\12562044.000 Data:calculated section size(3):
including thread list table
Dump File:c:\db2log\12562044.000 Data:the_section
Dump File:c:\db2log\12562044.000 Data:Relocated section
Dump File:c:\db2log\12562044.000 Data:Section relocated; reltables
dumped
Dump File:c:\db2log\12562044.000 Data:section ptr
Dump File:c:\db2log\12562044.000 Data:section size
Dump File:c:\db2log\12562044.000 Data:dynamic ptr
Dump File:c:\db2log\12562044.000 Data:dynamic size
Dump File:c:\db2log\12562044.000 Data:shared dynamic ptr
Dump File:c:\db2log\12562044.000 Data:shared dynamic size
Dump File:c:\db2log\12562044.000 Data:dynamic section header
Dump File:c:\db2log\12562044.000 Data:offset in section
Dump File:c:\db2log\12562044.000 Data:opcode
Dump File:c:\db2log\12562044.000 Data:agg_mode
Dump File:c:\db2log\12562044.000 Data:section1
Dump File:c:\db2log\12562044.000 Data:dynamic buffer
Dump File:c:\db2log\12562044.000 Data:RDS AGENT CB
Dump File:c:\db2log\12562044.000 Data:RDS APPL CB

2004-02-16-15.45.54.663000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:MEH
DIA3816C A severe internal processing error has occurred.

ZRC=0xFFFFF707

2004-02-16-15.45.54.934000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:MEH
Dump File:c:\db2log\12562044.000 Data:SQLE_DBCB
Dump File:c:\db2log\12562044.000 Data:SQLD_DBCB
Dump File:c:\db2log\12562044.000 Data:SQLD_AGENT_CB
Dump File:c:\db2log\12562044.000 Data:SQLD_TRAN_CB

Data Title:SQLD_AGENT_CB Pointer: PID:1256 TID:2044 Node:000
3040 fb01 0@.
Data Title:SQLD_AGENT_CB PID:1256 TID:2044 Node:000
0000 0000 0000 0000 0000 0000 0000 0000 ................
2cc1 f901 0000 0000 0010 0000 4045 fb01 ,.........@E.
0010 0000 10a5 1402 0010 0000 30c0 1402 ...........0..
0000 0000 0000 0000 0080 0000 3040 fd01 ...........0@.
0010 0000 905c fb01 0000 0000 0000 0000 .....\.........
Data Title:SQLD_TRAN_CB Pointer PID:1256 TID:2044 Node:000
b0c0 f901 .
thank you for any help you can provide.

MarvL
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Marvin,

First question: Do you run your function unfenced?
If so switch to fenced.
This will help dteremine whether the UDF or DB2 is at fault.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
This is typically caused by old/invalid jvm levels. Make sure you're
using a supported jdk level, and move up to the latest version. Serge's
advice about moving the udf to fenced is also good.

Marvin Libson wrote:
Hi All:

I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I
have created a java UDF and trigger. When I update my database I get
the following 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

which is followed by a db2syscs.exe Appllication error.

Can anyone give me a clue as to what the problem might be. My
db2diag.log contains:

2004-02-16-15.45.42.726000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejCallUDF Probe:101 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-16-15.45.42.846000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejSuffixEnv Probe:20 Database:MEH

Setting environment variable:
5041 5448 PATH
2004-02-16-15.45.42.856000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejSuffixEnv Probe:21 Database:MEH

New value:
443a 5c5c 496f 6e61 5c62 696e 3b44 3a5c D:\\Iona\bin;D:\
5c49 6f6e 615c 746f 6f6c 735c 6a72 653b \Iona\tools\jre;
443a 5c5c 496f 6e61 5c43 4f4d 6574 5c62 D:\\Iona\COMet\b
696e 3b43 3a5c 5749 4e4e 545c 7379 7374 in;C:\WINNT\syst
656d 3332 3b43 3a5c 5749 4e4e 543b 433a em32;C:\WINNT;C:
5c57 494e 4e54 5c53 7973 7465 6d33 325c \WINNT\System32\
5762 656d 3b43 3a5c 5749 4e4e 545c 5359 Wbem;C:\WINNT\SY
5354 454d 3332 3b43 3a5c 5749 4e4e 543b STEM32;C:\WINNT;
433a 5c57 494e 4e54 5c53 5953 5445 4d33 C:\WINNT\SYSTEM3
325c 5742 454d 3b43 3a5c 5749 4e4e 545c 2\WBEM;C:\WINNT\
5359 5354 454d 3332 3b43 3a5c 5749 4e4e SYSTEM32;C:\WINN
543b 433a 5c57 494e 4e54 5c53 5953 5445 T;C:\WINNT\SYSTE
4d33 325c 5742 454d 3b43 3a5c 5072 6f67 M32\WBEM;C:\Prog
7261 7e31 5c50 6572 736f 6e61 6c20 436f ra~1\Personal Co
6d6d 756e 6963 6174 696f 6e73 3b43 3a5c mmunications;C:\
4e6f 7465 733b 453a 5c55 7469 6c69 7469 Notes;E:\Utiliti
6573 3b43 3a5c 494d 4e6e 715f 4e54 3b43 es;C:\IMNnq_NT;C
3a5c 4a44 4b31 2e33 5c62 696e 3b43 3a5c :\JDK1.3\bin;C:\
5072 6f67 7261 6d20 4669 6c65 735c 4d51 Program Files\MQ
5365 7269 6573 5c4a 6176 614a 4d53 5c6c Series\JavaJMS\l
6962 3b43 3a5c 5072 6f67 7261 6d20 4669 ib;C:\Program Fi
6c65 735c 4d51 5365 7269 6573 5c4a 6176 les\MQSeries\Jav
614a 4d53 5c6c 6962 3b43 3a5c 5072 6f67 aJMS\lib;C:\Prog
7261 6d20 4669 6c65 735c 4d51 5365 7269 ram Files\MQSeri
6573 5c74 6f6f 6c73 5c63 5c73 616d 706c es\tools\c\sampl
6573 5c62 696e 3b43 3a5c 5072 6f67 7261 es\bin;C:\Progra
6d20 4669 6c65 735c 4d51 5365 7269 6573 m Files\MQSeries
5c62 696e 3b43 3a5c 5072 6f67 7261 6d20 \bin;C:\Program
4669 6c65 735c 4f62 6a52 4558 583b 433a Files\ObjREXX;C:
5c50 726f 6772 616d 2046 696c 6573 5c4f \Program Files\O
626a 5245 5858 5c4f 4f44 4941 4c4f 473b bjREXX\OODIALOG;
443a 5c57 4e45 5446 494e 3b43 3a5c 5072 D:\WNETFIN;C:\Pr
6f67 7261 6d20 4669 6c65 735c 5351 4c4c ogram Files\SQLL
4942 5c42 494e 3b43 3a5c 5072 6f67 7261 IB\BIN;C:\Progra
6d20 4669 6c65 735c 5351 4c4c 4942 5c46 m Files\SQLLIB\F
554e 4354 494f 4e3b 433a 5c50 726f 6772 UNCTION;C:\Progr
616d 2046 696c 6573 5c53 514c 4c49 425c am Files\SQLLIB\
5341 4d50 4c45 535c 5245 504c 3b43 3a5c SAMPLES\REPL;C:\
5072 6f67 7261 6d20 4669 6c65 735c 5351 Program Files\SQ
4c4c 4942 5c48 454c 503b 633a 5c70 726f LLIB\HELP;c:\pro
6772 617e 315c 7371 6c6c 6962 5c6a 6176 gra~1\sqllib\jav
615c 6a61 7661 3132 5c6a 646b 5c62 696e a\java12\jdk\bin
2004-02-16-15.45.43.097000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejGetBlocks Probe:22 Database:MEH

Attempting to load JEXT DLL Path:
433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
4942 5c62 696e IB\bin
2004-02-16-15.45.43.137000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejGetBlocks Probe:27 Database:MEH

Attempting to load JEXT DLL Name:
433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
4942 5c62 696e 5c44 4232 4a45 5854 2e44 IB\bin\DB2JEXT.D
4c4c LL
2004-02-16-15.45.43.367000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejResolveUDFLob Probe:5 Database:MEH

Attempting to load APIE DLL Path:
433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
4942 5c62 696e IB\bin
2004-02-16-15.45.43.407000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejResolveUDFLob Probe:6 Database:MEH

Attempting to load APIE DLL Name:
433a 5c50 524f 4752 417e 315c 5351 4c4c C:\PROGRA~1\SQLL
4942 5c62 696e 5c44 4232 454e 474e 2e44 IB\bin\DB2ENGN.D
4c4c LL
2004-02-16-15.45.43.668000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloSuffixEnv Probe:20 Database:MEH

Setting environment variable:
5041 5448 PATH
2004-02-16-15.45.43.708000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloSuffixEnv Probe:21 Database:MEH

New value:
443a 5c5c 496f 6e61 5c62 696e 3b44 3a5c D:\\Iona\bin;D:\
5c49 6f6e 615c 746f 6f6c 735c 6a72 653b \Iona\tools\jre;
443a 5c5c 496f 6e61 5c43 4f4d 6574 5c62 D:\\Iona\COMet\b
696e 3b43 3a5c 5749 4e4e 545c 7379 7374 in;C:\WINNT\syst
656d 3332 3b43 3a5c 5749 4e4e 543b 433a em32;C:\WINNT;C:
5c57 494e 4e54 5c53 7973 7465 6d33 325c \WINNT\System32\
5762 656d 3b43 3a5c 5749 4e4e 545c 5359 Wbem;C:\WINNT\SY
5354 454d 3332 3b43 3a5c 5749 4e4e 543b STEM32;C:\WINNT;
433a 5c57 494e 4e54 5c53 5953 5445 4d33 C:\WINNT\SYSTEM3
325c 5742 454d 3b43 3a5c 5749 4e4e 545c 2\WBEM;C:\WINNT\
5359 5354 454d 3332 3b43 3a5c 5749 4e4e SYSTEM32;C:\WINN
543b 433a 5c57 494e 4e54 5c53 5953 5445 T;C:\WINNT\SYSTE
4d33 325c 5742 454d 3b43 3a5c 5072 6f67 M32\WBEM;C:\Prog
7261 7e31 5c50 6572 736f 6e61 6c20 436f ra~1\Personal Co
6d6d 756e 6963 6174 696f 6e73 3b43 3a5c mmunications;C:\
4e6f 7465 733b 453a 5c55 7469 6c69 7469 Notes;E:\Utiliti
6573 3b43 3a5c 494d 4e6e 715f 4e54 3b43 es;C:\IMNnq_NT;C
3a5c 4a44 4b31 2e33 5c62 696e 3b43 3a5c :\JDK1.3\bin;C:\
5072 6f67 7261 6d20 4669 6c65 735c 4d51 Program Files\MQ
5365 7269 6573 5c4a 6176 614a 4d53 5c6c Series\JavaJMS\l
6962 3b43 3a5c 5072 6f67 7261 6d20 4669 ib;C:\Program Fi
6c65 735c 4d51 5365 7269 6573 5c4a 6176 les\MQSeries\Jav
614a 4d53 5c6c 6962 3b43 3a5c 5072 6f67 aJMS\lib;C:\Prog
7261 6d20 4669 6c65 735c 4d51 5365 7269 ram Files\MQSeri
6573 5c74 6f6f 6c73 5c63 5c73 616d 706c es\tools\c\sampl
6573 5c62 696e 3b43 3a5c 5072 6f67 7261 es\bin;C:\Progra
6d20 4669 6c65 735c 4d51 5365 7269 6573 m Files\MQSeries
5c62 696e 3b43 3a5c 5072 6f67 7261 6d20 \bin;C:\Program
4669 6c65 735c 4f62 6a52 4558 583b 433a Files\ObjREXX;C:
5c50 726f 6772 616d 2046 696c 6573 5c4f \Program Files\O
626a 5245 5858 5c4f 4f44 4941 4c4f 473b bjREXX\OODIALOG;
443a 5c57 4e45 5446 494e 3b43 3a5c 5072 D:\WNETFIN;C:\Pr
6f67 7261 6d20 4669 6c65 735c 5351 4c4c ogram Files\SQLL
4942 5c42 494e 3b43 3a5c 5072 6f67 7261 IB\BIN;C:\Progra
6d20 4669 6c65 735c 5351 4c4c 4942 5c46 m Files\SQLLIB\F
554e 4354 494f 4e3b 433a 5c50 726f 6772 UNCTION;C:\Progr
616d 2046 696c 6573 5c53 514c 4c49 425c am Files\SQLLIB\
5341 4d50 4c45 535c 5245 504c 3b43 3a5c SAMPLES\REPL;C:\
5072 6f67 7261 6d20 4669 6c65 735c 5351 Program Files\SQ
4c4c 4942 5c48 454c 503b 633a 5c70 726f LLIB\HELP;c:\pro
6772 617e 315c 7371 6c6c 6962 5c6a 6176 gra~1\sqllib\jav
615c 6a61 7661 3132 5c6a 646b 5c62 696e a\java12\jdk\bin
3b63 3a5c 7072 6f67 7261 7e31 5c73 716c ;c:\progra~1\sql
6c69 625c 6a61 7661 5c6a 6176 6131 325c lib\java\java12\
6a64 6b5c 6a72 655c 6269 6e5c 636c 6173 jdk\jre\bin\clas
7369 633b 633a 5c70 726f 6772 617e 315c sic;c:\progra~1\
7371 6c6c 6962 5c6a 6176 615c 6a61 7661 sqllib\java\java
3132 5c6a 646b 5c6a 7265 5c62 696e 5c3b 12\jdk\jre\bin\;
2004-02-16-15.45.44.048000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloSuffixEnv Probe:20 Database:MEH

Setting environment variable:
5041 5448 PATH
2004-02-16-15.45.44.088000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloSuffixEnv Probe:21 Database:MEH

New value:
443a 5c5c 496f 6e61 5c62 696e 3b44 3a5c D:\\Iona\bin;D:\
5c49 6f6e 615c 746f 6f6c 735c 6a72 653b \Iona\tools\jre;
443a 5c5c 496f 6e61 5c43 4f4d 6574 5c62 D:\\Iona\COMet\b
696e 3b43 3a5c 5749 4e4e 545c 7379 7374 in;C:\WINNT\syst
656d 3332 3b43 3a5c 5749 4e4e 543b 433a em32;C:\WINNT;C:
5c57 494e 4e54 5c53 7973 7465 6d33 325c \WINNT\System32\
5762 656d 3b43 3a5c 5749 4e4e 545c 5359 Wbem;C:\WINNT\SY
5354 454d 3332 3b43 3a5c 5749 4e4e 543b STEM32;C:\WINNT;
433a 5c57 494e 4e54 5c53 5953 5445 4d33 C:\WINNT\SYSTEM3
325c 5742 454d 3b43 3a5c 5749 4e4e 545c 2\WBEM;C:\WINNT\
5359 5354 454d 3332 3b43 3a5c 5749 4e4e SYSTEM32;C:\WINN
543b 433a 5c57 494e 4e54 5c53 5953 5445 T;C:\WINNT\SYSTE
4d33 325c 5742 454d 3b43 3a5c 5072 6f67 M32\WBEM;C:\Prog
7261 7e31 5c50 6572 736f 6e61 6c20 436f ra~1\Personal Co
6d6d 756e 6963 6174 696f 6e73 3b43 3a5c mmunications;C:\
4e6f 7465 733b 453a 5c55 7469 6c69 7469 Notes;E:\Utiliti
6573 3b43 3a5c 494d 4e6e 715f 4e54 3b43 es;C:\IMNnq_NT;C
3a5c 4a44 4b31 2e33 5c62 696e 3b43 3a5c :\JDK1.3\bin;C:\
5072 6f67 7261 6d20 4669 6c65 735c 4d51 Program Files\MQ
5365 7269 6573 5c4a 6176 614a 4d53 5c6c Series\JavaJMS\l
6962 3b43 3a5c 5072 6f67 7261 6d20 4669 ib;C:\Program Fi
6c65 735c 4d51 5365 7269 6573 5c4a 6176 les\MQSeries\Jav
614a 4d53 5c6c 6962 3b43 3a5c 5072 6f67 aJMS\lib;C:\Prog
7261 6d20 4669 6c65 735c 4d51 5365 7269 ram Files\MQSeri
6573 5c74 6f6f 6c73 5c63 5c73 616d 706c es\tools\c\sampl
6573 5c62 696e 3b43 3a5c 5072 6f67 7261 es\bin;C:\Progra
6d20 4669 6c65 735c 4d51 5365 7269 6573 m Files\MQSeries
5c62 696e 3b43 3a5c 5072 6f67 7261 6d20 \bin;C:\Program
4669 6c65 735c 4f62 6a52 4558 583b 433a Files\ObjREXX;C:
5c50 726f 6772 616d 2046 696c 6573 5c4f \Program Files\O
626a 5245 5858 5c4f 4f44 4941 4c4f 473b bjREXX\OODIALOG;
443a 5c57 4e45 5446 494e 3b43 3a5c 5072 D:\WNETFIN;C:\Pr
6f67 7261 6d20 4669 6c65 735c 5351 4c4c ogram Files\SQLL
4942 5c42 494e 3b43 3a5c 5072 6f67 7261 IB\BIN;C:\Progra
6d20 4669 6c65 735c 5351 4c4c 4942 5c46 m Files\SQLLIB\F
554e 4354 494f 4e3b 433a 5c50 726f 6772 UNCTION;C:\Progr
616d 2046 696c 6573 5c53 514c 4c49 425c am Files\SQLLIB\
5341 4d50 4c45 535c 5245 504c 3b43 3a5c SAMPLES\REPL;C:\
5072 6f67 7261 6d20 4669 6c65 735c 5351 Program Files\SQ
4c4c 4942 5c48 454c 503b 633a 5c70 726f LLIB\HELP;c:\pro
6772 617e 315c 7371 6c6c 6962 5c6a 6176 gra~1\sqllib\jav
615c 6a61 7661 3132 5c6a 646b 5c62 696e a\java12\jdk\bin
3b63 3a5c 7072 6f67 7261 7e31 5c73 716c ;c:\progra~1\sql
6c69 625c 6a61 7661 5c6a 6176 6131 325c lib\java\java12\
6a64 6b5c 6a72 655c 6269 6e5c 636c 6173 jdk\jre\bin\clas
7369 633b 633a 5c70 726f 6772 617e 315c sic;c:\progra~1\
7371 6c6c 6962 5c6a 6176 615c 6a61 7661 sqllib\java\java
3132 5c6a 646b 5c6a 7265 5c62 696e 5c3b 12\jdk\jre\bin\;
3b43 3a5c 5052 4f47 5241 7e31 5c53 514c ;C:\PROGRA~1\SQL
4c49 425c 6269 6e LIB\bin
2004-02-16-15.45.44.359000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloJVMstart Probe:35 Database:MEH

Attempting to load JNI Path:
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 ic
2004-02-16-15.45.44.399000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloJVMstart Probe:27 Database:MEH

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-16-15.45.44.719000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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-16-15.45.44.879000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloJVMstart Probe:40 Database:MEH

About to start Java interpreter thread

2004-02-16-15.45.44.899000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2548 Appid:none
oper_system_services sqloJVMstartEDU Probe:10

Started Java interpreter thread. EDU parms:
10b2 686c e0aa b001 44ab b001 88ac b001 .hlર.D..
2004-02-16-15.45.44.919000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2548 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 0b02 c0f8 606c 10f7 606c 90f5 606c 0..`l.`l.`l
0100 0000 0000 0000 0100 0000 0000 0000 ................
0000 0000 0000 0000 ........
2004-02-16-15.45.47.894000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2548 Appid:none
oper_system_services sqloJVMstartEDU Probe:25

Java interpreter is running.

2004-02-16-15.45.48.394000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejReload Probe:14 Database:MEH

loaderValidate: 0000 0000 ....
2004-02-16-15.45.48.615000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
BSU Java support sqlejGetPaths Probe:11 Database:MEH

C:\PROGRA~1\SQLLIB

2004-02-16-15.45.48.735000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqlofindn Probe:100 Database:MEH

GetLastError: 1200 0000 ....
2004-02-16-15.45.48.775000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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-16-15.45.48.825000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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-16-15.45.48.975000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
oper_system_services sqloopenp Probe:120 Database:MEH

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

2004-02-16-15.45.51.028000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with coor_node:0000
..
2004-02-16-15.45.51.058000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with coor_agent_index:1300
..
2004-02-16-15.45.51.098000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with CLIENT PID:3234 3936
2496
2004-02-16-15.45.51.158000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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
3632 3034 3231 37 6204217
2004-02-16-15.45.51.279000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with INBOUND SEQUENCE NUMBER:3030
3031 0001
2004-02-16-15.45.51.329000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with OUTBOUND APPLICATION ID:

2004-02-16-15.45.51.419000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:

2004-02-16-15.45.51.499000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
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 ...............
2004-02-16-15.45.51.629000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with PRODUCT SIGNATURE:5351 4c30
3730 3239 SQL07029
2004-02-16-15.45.51.749000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

Error in agent servicing application with APPLICATION NAME:6462 3262
702e 6578 65 db2bp.exe
2004-02-16-15.45.51.829000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:1 Database:MEH

value of ptr to db2ra_as_cb30c0 9801
0.
2004-02-16-15.45.51.909000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:2 Database:MEH

contents of db2ra_as_cb70fa b001 9007 ab00 0000 0000 0000 0000
p............
0000 0000 30c1 9801 0000 0000 0000 0000 ....0.........
0000 0000 0000 0000 3000 b701 0000 0000 ........0......
0000 0000 68c0 9801 0000 0000 0000 0000 ....h.........
5351 4c44 4232 5241 0200 0b00 0000 0000 SQLDB2RA........
0000 1000 0001 0000 5351 4c44 4232 5241 ........SQLDB2RA
0100 0300 0501 0a23 0000 0000 1600 0000 .......#........
0200 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 7c01 0000 0000 0000 0501 0a13 ....|...........
0501 0a23 0000 0501 0000 0000 0000 0000 ...#............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0200 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 ........
2004-02-16-15.45.52.060000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:3 Database:MEH

value of ptr to ccb0000 0000 ....
2004-02-16-15.45.52.100000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:6 Database:MEH

contents of comm_handle50c1 9801 1400 d301 0000 0000 0000 0000
P............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 00f0 0000 ...............
0001 0000 0000 0000 0000 0000 0001 0000 ................
0600 0000 0000 0000 ........
2004-02-16-15.45.52.240000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:7 Database:MEH

contents of comm_handle buffer0100 0000 7c01 0000 f400 0000 5351 4c44
....|......SQLD
4232 5241 e000 0000 0501 0200 0a00 0a00 B2RA...........
8800 0000 0900 0080 5cfd 1200 0000 0000 ... ..\......
0400 0040 0000 0000 0c00 0000 0400 0040 ...@...........@
a4f9 1200 0200 0000 0300 0040 44fd 1200 .........@D..
0800 0000 0100 0040 b041 ca00 0800 0000 .......@A.....
0100 0040 ca41 ca00 0800 0000 0100 0040 ...@A........@
b841 ca00 0000 0000 0000 0000 0000 0000 A.............
0000 0000 0000 0000 0000 0000 4000 0000 ............@...
0100 0040 40ac 4400 0000 0000 0000 0000 ...@@D.........
0000 0000 cb00 2020 5351 4c43 3244 3034 ..... SQLC2D04
4e55 4c4c 4944 2020 4141 4141 4151 4553 NULLID AAAAAQES
7570 6461 7465 2076 6170 2e65 7175 6970 update vap.equip
6d65 6e74 2073 6574 2074 6f6f 6c5f 7479 ment set tool_ty
7065 3d32 2077 6865 7265 2074 6f6f 6c5f pe=2 where tool_
6e61 6d65 3d27 5761 6665 724d 6172 6b27 name='WaferMark'
2004-02-16-15.45.52.490000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:MEH

size of receive request area7c01 0000
|...
2004-02-16-15.45.52.530000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
base_sys_utilities sqleagnt_sigsegvh Probe:11 Database:MEH

contents of receive request area5351 4c44 4232 5241 e000 0000 0501
0200 SQLDB2RA.......
0a00 0a00 8800 0000 0900 0080 f0fb b001 ....... ...
0000 0000 0400 0040 0000 0000 0c00 0000 .......@........
0400 0040 bc00 b701 0200 0000 0300 0040 ...@.........@
c800 b701 0800 0000 0100 0040 cc00 b701 .........@..
0800 0000 0100 0040 d400 b701 0800 0000 .......@......
0100 0040 dc00 b701 0000 0000 0000 0000 ...@..........
0000 0000 0000 0000 0000 0000 0000 0000 ................
4000 0000 0100 0040 e400 b701 0000 0000 @......@......
0000 0000 0000 0000 cb00 2020 5351 4c43 ......... SQLC
3244 3034 4e55 4c4c 4944 2020 4141 4141 2D04NULLID AAAA
4151 4553 7570 6461 7465 2076 6170 2e65 AQESupdate vap.e
7175 6970 6d65 6e74 2073 6574 2074 6f6f quipment set too
6c5f 7479 7065 3d32 2077 6865 7265 2074 l_type=2 where t
6f6f 6c5f 6e61 6d65 3d27 5761 6665 724d ool_name='WaferM
6172 6b27 0000 0000 0400 0000 0200 0040 ark'...........@
7f02 b701 0000 0000 0000 0000 0000 0000 ...............
0000 0000 0100 0000 0000 0000 0200 0000 ................
0300 0000 8302 b701 0000 0000 0000 0000 ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0100 0000 0000 0000 0400 0000 0700 0000 ................
8502 b701 d102 0000 0000 0000 0000 0000 .............
0000 0000 0000 0000 0153 0001 .........S..
2004-02-16-15.45.52.831000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_signal_handler Probe:10 Database:MEH
DIA7107I Execution of a component signal handling function has begun.

2004-02-16-15.45.52.971000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:MEH
DIA3816C A severe internal processing error has occurred.

2004-02-16-15.45.52.991000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:MEH
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFF707".

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

Dump File:c:\db2log\12562044.000 Data:SQLCA
Dump File:c:\db2log\12562044.000 Data:DB2RA

Data Title:CREATOR PID:1256 TID:2044 Node:000
4e55 4c4c 4944 2020 NULLID
Data Title:PACKAGE PID:1256 TID:2044 Node:000
5351 4c43 3244 3034 SQLC2D04

Dump File:c:\db2log\12562044.000 Data:CREATOR
Dump File:c:\db2log\12562044.000 Data:PACKAGE
Dump File:c:\db2log\12562044.000 Data:REQUEST TYPE
Dump File:c:\db2log\12562044.000 Data:APM COMMON INFO
Dump File:c:\db2log\12562044.000 Data:PACKAGE ENTRY
Dump File:c:\db2log\12562044.000 Data:USED_IN_UOW BIT VECTOR
Dump File:c:\db2log\12562044.000 Data:Recursive dump_sect
Dump File:c:\db2log\12562044.000 Data:SECTION NUMBER
Dump File:c:\db2log\12562044.000 Data:SECTION DIR ENTRY
Dump File:c:\db2log\12562044.000 Data:cache cb

Data Title:section stmt PID:1256 TID:2044 Node:000
7570 6461 7465 2076 6170 2e65 7175 6970 update vap.equip
6d65 6e74 2073 6574 2074 6f6f 6c5f 7479 ment set tool_ty
7065 3d32 2077 6865 7265 2074 6f6f 6c5f pe=2 where tool_
6e61 6d65 3d27 5761 6665 724d 6172 6b27 name='WaferMark'

Dump File:c:\db2log\12562044.000 Data:section stmt
Dump File:c:\db2log\12562044.000 Data:sentptr
Dump File:c:\db2log\12562044.000 Data:sentptr->sectlen
Dump File:c:\db2log\12562044.000 Data:sentptr->cache_cb
Dump File:c:\db2log\12562044.000
Data:sentptr->cache_cb->cached_sectptr
Dump File:c:\db2log\12562044.000
Data:sentptr->cache_cb->cached_sectptr->thread_list
Dump File:c:\db2log\12562044.000 Data:calculated section size (1): not
including thread list
Dump File:c:\db2log\12562044.000 Data:calculated section size(2):
including thread structure
Dump File:c:\db2log\12562044.000 Data:thd_table
Dump File:c:\db2log\12562044.000 Data:thd_table->size
Dump File:c:\db2log\12562044.000 Data:calculated section size(3):
including thread list table
Dump File:c:\db2log\12562044.000 Data:the_section
Dump File:c:\db2log\12562044.000 Data:Relocated section
Dump File:c:\db2log\12562044.000 Data:Section relocated; reltables
dumped
Dump File:c:\db2log\12562044.000 Data:section ptr
Dump File:c:\db2log\12562044.000 Data:section size
Dump File:c:\db2log\12562044.000 Data:dynamic ptr
Dump File:c:\db2log\12562044.000 Data:dynamic size
Dump File:c:\db2log\12562044.000 Data:shared dynamic ptr
Dump File:c:\db2log\12562044.000 Data:shared dynamic size
Dump File:c:\db2log\12562044.000 Data:dynamic section header
Dump File:c:\db2log\12562044.000 Data:offset in section
Dump File:c:\db2log\12562044.000 Data:opcode
Dump File:c:\db2log\12562044.000 Data:agg_mode
Dump File:c:\db2log\12562044.000 Data:section1
Dump File:c:\db2log\12562044.000 Data:dynamic buffer
Dump File:c:\db2log\12562044.000 Data:RDS AGENT CB
Dump File:c:\db2log\12562044.000 Data:RDS APPL CB

2004-02-16-15.45.54.663000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:MEH
DIA3816C A severe internal processing error has occurred.

ZRC=0xFFFFF707

2004-02-16-15.45.54.934000 Instance:DB2 Node:000
PID:1256(db2syscs.exe) TID:2044 Appid:*LOCAL.DB2.040216204217
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:MEH
Dump File:c:\db2log\12562044.000 Data:SQLE_DBCB
Dump File:c:\db2log\12562044.000 Data:SQLD_DBCB
Dump File:c:\db2log\12562044.000 Data:SQLD_AGENT_CB
Dump File:c:\db2log\12562044.000 Data:SQLD_TRAN_CB

Data Title:SQLD_AGENT_CB Pointer: PID:1256 TID:2044 Node:000
3040 fb01 0@.
Data Title:SQLD_AGENT_CB PID:1256 TID:2044 Node:000
0000 0000 0000 0000 0000 0000 0000 0000 ................
2cc1 f901 0000 0000 0010 0000 4045 fb01 ,.........@E.
0010 0000 10a5 1402 0010 0000 30c0 1402 ...........0..
0000 0000 0000 0000 0080 0000 3040 fd01 ...........0@.
0010 0000 905c fb01 0000 0000 0000 0000 .....\.........
Data Title:SQLD_TRAN_CB Pointer PID:1256 TID:2044 Node:000
b0c0 f901 .
thank you for any help you can provide.

MarvL

Nov 12 '05 #3

P: n/a
Serge Rielau <sr*****@ca.eye-be-em.com> wrote in message news:<c0*********@hanover.torolab.ibm.com>...
Marvin,

First question: Do you run your function unfenced?
If so switch to fenced.
This will help dteremine whether the UDF or DB2 is at fault.

Cheers
Serge


Serge: Thank you for the suggestion. I was running my UDF unfenced
and when I changed it to fenced, the application error occurred in the
UDF. I hadn't geven that much thought because the UDF is so trivial.

import COM.ibm.db2.app.*;

import java.io.*;

/**
* This is a UDF test.
*/

public class testudf extends UDF
{
private static PrintWriter out;

public static void testudf(String pclot) throws java.lang.Exception
{
out = new PrintWriter(new
FileWriter("e:\\javaexs\\pdtftp.out",true),true);

out.println(pclot);
}
}

Do you see anything wrong with the UDF? The create function and
trigger I am using is:
db2 create function testudf(varchar(10)) returns integer language java
param
eter style java fenced not null call no sql external action external
name 'testu
df'
DB20000I The SQL command completed successfully.

db2 create trigger vap.testudf after update of tool_type on
vap.equipment fo
r each row mode db2sql values (testudf('0123456789'))
DB20000I The SQL command completed successfully.

When I run the UDF without the trigger, it still abends with the same
error. But when I convert it to a main standalone procedure, it works
fine.

Thanks so much for any suggestions you have.
Nov 12 '05 #4

P: n/a
Marvin Libson <a7*****@us.ibm.com> wrote:
Serge: Thank you for the suggestion. I was running my UDF unfenced
and when I changed it to fenced, the application error occurred in the
UDF. I hadn't geven that much thought because the UDF is so trivial.

import COM.ibm.db2.app.*;


/**
* This is a UDF test.
*/

public class testudf extends UDF
{
private static PrintWriter out;

public static void testudf(String pclot) throws java.lang.Exception
{
out = new PrintWriter(new
FileWriter("e:\\javaexs\\pdtftp.out",true),true);

out.println(pclot);
}
}

Do you see anything wrong with the UDF? The create function and
trigger I am using is:

db2 create function testudf(varchar(10)) returns integer language java
parameter style java fenced not null call no sql external action external
name 'testudf'
DB20000I The SQL command completed successfully.
You use PARAMETER STYLE JAVA and your UDF is supposed to return an INTEGER.
But your code says the function returns "void", which doesn't match.

Another issue with your CREATE FUNCTION statement is that it doesn't even
specify correctly the name of the external function to be called. If I try
to run your statement, I got this error:

SQL0449N The statement defining routine "STOLZE.TESTUDF" contains an
invalidly formatted library/function identification in the EXTERNAL NAME
clause. LINE NUMBER=1. SQLSTATE=42878

So I did use the following statement to register the UDF:

CREATE FUNCTION testudf(str VARCHAR(10))
RETURNS INTEGER
LANGUAGE JAVA
EXTERNAL NAME 'testudf.testudf'
PARAMETER STYLE JAVA
FENCED
RETURNS NULL ON NULL INPUT
NO SQL
EXTERNAL ACTION

With this, I get an error saying that the UDF could not be called and in the
db2diag.log, I see the exception "java.lang.NoSuchMethodError.
Changing the return parameter of the Java function to be "int" got things
working for me:

import COM.ibm.db2.app.*;
import java.io.*;

public class testudf extends UDF
{
public static int testudf(String pclot) throws java.lang.Exception
{
PrintWriter out = new PrintWriter(
new FileWriter("/home/stolze/udf.out", true), true);
out.println(pclot);
return 1;
}
}

Btw, you might want to be careful with allocating static object the way you
did. Have a look at the manual to see how DB2 manages Java objects.
When I run the UDF without the trigger, it still abends with the same
error. But when I convert it to a main standalone procedure, it works
fine.


I guess it works fine as procedure because the parameters expected on the
stack actually do match (a procedure does not give a scalar return value).

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #5

P: n/a
Yes, thank you so much Knut. Those were my problems exactly. I was
using the nudft1 example in the Create Function section of the SQL Ref
V2 as a guide and it does a Returns smallint on a void function. It
is a language C, so maybe differences between C & Java??? I had also
played around with the external name, but had gotten misled because I
was using the not fenced parameter and at the time thought I was
crashing in DB2.

Thanks again - It will be nice to start making some real headway
finally.
Nov 12 '05 #6

P: n/a
Marvin Libson <a7*****@us.ibm.com> wrote:
Yes, thank you so much Knut. Those were my problems exactly. I was
using the nudft1 example in the Create Function section of the SQL Ref
V2 as a guide and it does a Returns smallint on a void function. It
is a language C, so maybe differences between C & Java??? I had also
played around with the external name, but had gotten misled because I
was using the not fenced parameter and at the time thought I was
crashing in DB2.

Thanks again - It will be nice to start making some real headway
finally.


LANGUAGE C function use PARAMETER STYLE SQL. In that style, you get the
input and output parameters on the stack like this:

void udfEntry(
inparameter1,
inparameter2,
inparameter3,
outparameter,
null-indicator-for-inparameter1,
null-indicator-for-inparameter2,
null-indicator-for-inparameter3,
null-indicator-for-outparameter,
...some other stuff)

For LANGUAGE JAVA functions, you can choose between PARAMETER STYLE JAVA and
PARAMETER STYLE DB2GENERAL. Parm style JAVA requires that the function
returns its value as result like this:

int udfEntry(inparameter1, inparameter2, inparameter3)

For parm style DB2GENERAL you have a convention that is similar to C code
functions:

public static void udfEntry(
inparameter1,
inparameter2,
inparameter3,
outparameter)

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.