SQL1131N DARI (Stored Procedure) process has been terminated abnormally

1 New Member

Hi,

I am getting error SQL1131N during sqlj.install_ja r(...). There is no useful message in the diag.log (even with diag level 4). I am giving the diag.log entries at the end of this posting (would have been ideal if there was an option to attach the file).

command:
db2 call sqlj.install_ja r('file:/home/xyz/abc.jar','def.a bc')

response:
SQL1131N DARI (Stored Procedure) process has been terminated abnormally.
SQLSTATE=38503

db2level:
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08020" with level identifier "03010106". Informational tokens are "DB2 v8.1.0.64", "s040812", "MI00086", and FixPak "7". Product is installed at "/opt/IBM/db2/V8.1".

I am on Linux (Fedora Core-6).

Any help/hints will be highly appreciated.

Thanks.
Ravi

diag.log
-------------
2007-05-21-11.59.55.324030 +330 I6066077G313 LEVEL: Info
PID : 23938 TID : 3064723136
FUNCTION: DB2 Common, Security, Users and Groups, secLoadClientAu thPlugin, probe:10
DATA #1 : String, 91 bytes
Loaded plugin library /home/db2inst1/sqllib/security32/plugin/IBM/client/IBMOSauthclient .so

2007-05-21-11.59.55.324205 +330 I6066391G249 LEVEL: Info
PID : 23938 TID : 3064723136
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
DATA #1 : String, 37 bytes
db2secClientAut hPluginInit successful

2007-05-21-11.59.55.342807 +330 I6066641G387 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, data protection, sqlpinit, probe:2160
MESSAGE : Database started with next LSN of 000000001964000 C.

2007-05-21-11.59.55.385232 +330 I6067029G588 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, BSU Java support, sqlejInstallJar , probe:30
MESSAGE : make jar dir:
DATA #1 : Hexdump, 34 bytes
0xBF9BA1E8 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0xBF9BA1F8 : 716C 6C69 622F 6675 6E63 7469 6F6E 2F6A qllib/function/j
0xBF9BA208 : 6172 ar

2007-05-21-11.59.55.385352 +330 I6067618G597 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, BSU Java support, sqlejInstallJar , probe:30
MESSAGE : make jar dir:
DATA #1 : Hexdump, 43 bytes
0xBF9BA1E8 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0xBF9BA1F8 : 716C 6C69 622F 6675 6E63 7469 6F6E 2F6A qllib/function/j
0xBF9BA208 : 6172 2F44 4232 494E 5354 31 ar/DB2INST1

2007-05-21-11.59.55.385434 +330 I6068216G664 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, BSU Java support, sqlejInstallJar , probe:45
MESSAGE : copy jar to:
DATA #1 : Hexdump, 54 bytes
0xBF9BA1E8 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0xBF9BA1F8 : 716C 6C69 622F 6675 6E63 7469 6F6E 2F6A qllib/function/j
0xBF9BA208 : 6172 2F44 4232 494E 5354 312F 4E53 5044 ar/DB2INST1/NSPD
0xBF9BA218 : 4232 2E6A 6172 B2.jar

2007-05-21-11.59.55.387247 +330 I6068881G995 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
MESSAGE : First time procedure resolution failed
DATA #1 : Hexdump, 136 bytes
0x00544CE4 : 5351 4C43 4120 2020 8800 0000 0000 0000 SQLCA ........
0x00544CF4 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x00544D04 : 2020 2020 2020 2020 2020 2020 2020 2020
0x00544D14 : 2020 2020 2020 2020 2020 2020 2020 2020
0x00544D24 : 2020 2020 2020 2020 2020 2020 2020 2020
0x00544D34 : 2020 2020 2020 2020 5351 4C30 3830 3230 SQL08020
0x00544D44 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x00544D54 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x00544D64 : 2020 2020 2020 2020

2007-05-21-11.59.55.387361 +330 I6069877G996 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
MESSAGE : Second time procedure resolution failed
DATA #1 : Hexdump, 136 bytes
0x00544CE4 : 5351 4C43 4120 2020 8800 0000 0000 0000 SQLCA ........
0x00544CF4 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x00544D04 : 2020 2020 2020 2020 2020 2020 2020 2020
0x00544D14 : 2020 2020 2020 2020 2020 2020 2020 2020
0x00544D24 : 2020 2020 2020 2020 2020 2020 2020 2020
0x00544D34 : 2020 2020 2020 2020 5351 4C30 3830 3230 SQL08020
0x00544D44 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x00544D54 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x00544D64 : 2020 2020 2020 2020

2007-05-21-11.59.55.473013 +330 I6070874G370 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejSuffixEnv, probe:20
MESSAGE : Setting environment variable:
DATA #1 : Hexdump, 15 bytes
0x012079F4 : 4C44 5F4C 4942 5241 5259 5F50 4154 48 LD_LIBRARY_PATH

2007-05-21-11.59.55.473171 +330 I6071245G483 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejSuffixEnv, probe:21
MESSAGE : New value:
DATA #1 : Hexdump, 33 bytes
0xBFE2A9F8 : 2F6F 7074 2F49 424D 4A61 7661 322D 3134 /opt/IBMJava2-14
0xBFE2AA08 : 312F 6A72 652F 6269 6E2F 636C 6173 7369 1/jre/bin/classi
0xBFE2AA18 : 63 c

2007-05-21-11.59.55.473234 +330 I6071729G443 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejGetBlocks, probe:22
MESSAGE : Attempting to load JEXT DLL Path:
DATA #1 : Hexdump, 27 bytes
0xBFE2ACF8 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0xBFE2AD08 : 716C 6C69 622F 6C69 6233 32 qllib/lib32

2007-05-21-11.59.55.473287 +330 I6072173G372 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejGetBlocks, probe:27
MESSAGE : Attempting to load JEXT DLL Name:
DATA #1 : Hexdump, 13 bytes
0x010EAF2C : 6C69 6264 6232 6A65 7874 2E73 6F libdb2jext.so

2007-05-21-11.59.55.483091 +330 I6072546G373 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:20
MESSAGE : Setting environment variable:
DATA #1 : Hexdump, 15 bytes
0x012079F4 : 4C44 5F4C 4942 5241 5259 5F50 4154 48 LD_LIBRARY_PATH

2007-05-21-11.59.55.483189 +330 I6072920G718 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:21
MESSAGE : New value:
DATA #1 : Hexdump, 94 bytes
0x0044B890 : 2F6F 7074 2F49 424D 4A61 7661 322D 3134 /opt/IBMJava2-14
0x0044B8A0 : 312F 6A72 652F 6269 6E2F 636C 6173 7369 1/jre/bin/classi
0x0044B8B0 : 633A 2F6F 7074 2F49 424D 4A61 7661 322D c:/opt/IBMJava2-
0x0044B8C0 : 3134 312F 6A72 652F 6269 6E2F 636C 6173 141/jre/bin/clas
0x0044B8D0 : 7369 633A 2F6F 7074 2F49 424D 4A61 7661 sic:/opt/IBMJava
0x0044B8E0 : 322D 3134 312F 6A72 652F 6269 6E3A 2-141/jre/bin:

2007-05-21-11.59.55.483265 +330 I6073639G373 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:20
MESSAGE : Setting environment variable:
DATA #1 : Hexdump, 15 bytes
0x012079F4 : 4C44 5F4C 4942 5241 5259 5F50 4154 48 LD_LIBRARY_PATH

2007-05-21-11.59.55.483317 +330 I6074013G861 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:21
MESSAGE : New value:
DATA #1 : Hexdump, 122 bytes
0x0044B890 : 2F6F 7074 2F49 424D 4A61 7661 322D 3134 /opt/IBMJava2-14
0x0044B8A0 : 312F 6A72 652F 6269 6E2F 636C 6173 7369 1/jre/bin/classi
0x0044B8B0 : 633A 2F6F 7074 2F49 424D 4A61 7661 322D c:/opt/IBMJava2-
0x0044B8C0 : 3134 312F 6A72 652F 6269 6E2F 636C 6173 141/jre/bin/clas
0x0044B8D0 : 7369 633A 2F6F 7074 2F49 424D 4A61 7661 sic:/opt/IBMJava
0x0044B8E0 : 322D 3134 312F 6A72 652F 6269 6E3A 3A2F 2-141/jre/bin::/
0x0044B8F0 : 686F 6D65 2F64 6232 696E 7374 312F 7371 home/db2inst1/sq
0x0044B900 : 6C6C 6962 2F6C 6962 3332 llib/lib32

2007-05-21-11.59.55.483447 +330 I6074875G503 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:35
MESSAGE : Attempting to load JNI Path:
DATA #1 : Hexdump, 33 bytes
0xBFE269E4 : 2F6F 7074 2F49 424D 4A61 7661 322D 3134 /opt/IBMJava2-14
0xBFE269F4 : 312F 6A72 652F 6269 6E2F 636C 6173 7369 1/jre/bin/classi
0xBFE26A04 : 63 c

2007-05-21-11.59.55.483506 +330 I6075379G368 LEVEL: Info
PID : 23955 TID : 4493152 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:36
MESSAGE : Attempting to load JNI DLL Name:
DATA #1 : Hexdump, 9 bytes
0x010EB33C : 6C69 626A 766D 2E73 6F libjvm.so

2007-05-21-11.59.55.484510 +330 I6075748G448 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0xBF9B5B98 : 4700 0000 G...

2007-05-21-11.59.55.484616 +330 I6076197G435 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
RETCODE : ZRC=0x8136001C=-2127167460=SQLZ _RC_NO_CONNECTI ON, SQLT_SQLJC
"No connection"

2007-05-21-11.59.55.486474 +330 I6076633G686 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
DATA #1 : String, 320 bytes
CALL STACK:
[0] 0x02653344 _Z12sqljcReceiv eP10sqljCmnMgr + 0x1FA
[1] 0x0132B4CC _Z19sqljsDrdaAs SPDriverP11UCco nHandleP15sqlcc _comhandlePPh + 0x1F4
[2] 0x0242CE0D _Z24sqlerInvoke FencedRoutineP1 3sqlerFmpParms + 0x5B5
[3] 0x01F254E2 _Z18sqlriInvoke InvokerP10sqlri _ufob + 0xC1C
[4] 0x01F2064B _Z9sqlricallP8s qlrr_cb + 0x153

2007-05-21-12.00.05.496991 +330 I6077320G1001 LEVEL: Severe
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, common communication, sqlccIPCSignalD ariEnd, probe:10
MESSAGE : FMP didn't respond in 10 seconds, initStruct =
DATA #1 : Hexdump, 116 bytes
0x1014EA20 : 4080 0C00 0000 0600 0001 0000 0100 0000 @.............. .
0x1014EA30 : 4000 3511 0080 2811 00C0 5F01 0C80 0A00 @.5...(..._.... .
0x1014EA40 : 0200 0000 14E0 0100 2100 8D17 0300 0000 ........!...... .
0x1014EA50 : FFFF FFFF FFFF FFFF 0200 0000 FFFF FFFF ............... .
0x1014EA60 : 0000 0000 0100 0000 0200 0000 0000 0000 ............... .
0x1014EA70 : 0100 0000 0000 0000 0100 0000 0000 0000 ............... .
0x1014EA80 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014EA90 : 0000 0000 ....

2007-05-21-12.00.05.497182 +330 I6078322G1597 LEVEL: Severe
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, routine_infrast ructure, sqlerCleanThrea dResource, probe:1
MESSAGE : FMP process didn't respond for 10 seconds, fmpThread =
DATA #1 : Hexdump, 244 bytes
0x1014FB4C : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FB5C : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FB6C : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FB7C : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FB8C : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FB9C : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBAC : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBBC : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBCC : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBDC : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBEC : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBFC : 0000 0000 0000 0000 00F0 0000 0000 0000 ............... .
0x1014FC0C : 0000 0000 04EC 0000 EC04 0000 0000 0000 ............... .
0x1014FC1C : 0000 0000 0000 0000 0000 0000 40FB 1410 ............@.. .
0x1014FC2C : 20EA 1410 0000 0000 0100 0000 0000 0000 ...............
0x1014FC3C : 0000 0000 ....

2007-05-21-12.00.05.497347 +330 I6079920G1748 LEVEL: Severe
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, routine_infrast ructure, sqlerCleanThrea dResource, probe:1
MESSAGE : FMP process didn't respond for 10 seconds, fmpRow =
DATA #1 : Hexdump, 284 bytes
0x1014FB40 : 935D 0000 00CC BD01 00CC BE01 0000 0000 .]..............
0x1014FB50 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FB60 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FB70 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FB80 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FB90 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FBF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... .
0x1014FC00 : 0000 0000 00F0 0000 0000 0000 0000 0000 ............... .
0x1014FC10 : 04EC 0000 EC04 0000 0000 0000 0000 0000 ............... .
0x1014FC20 : 0000 0000 0000 0000 40FB 1410 20EA 1410 ........@... ...
0x1014FC30 : 0000 0000 0100 0000 0000 0000 0000 0000 ............... .
0x1014FC40 : 0000 0000 40BC 0E10 0000 0000 1100 0000 ....@.......... .
0x1014FC50 : 0000 0000 0000 0000 B804 0100 ............

2007-05-21-12.00.05.497842 +330 I6081669G1007 LEVEL: Error
PID : 26942 TID : 5507376 PROC : db2agent (DEV3DB)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : Hexdump, 136 bytes
0x00544CE4 : 5351 4C43 4120 2020 8800 0000 95FB FFFF SQLCA ........
0x00544CF4 : 1600 30FF 2AFF 2AFF 2AFF 2AFF FF73 6572 ..0.*.*.*.*..se r
0x00544D04 : 7665 7253 656E 64FF 2020 2020 2020 2020 verSend.
0x00544D14 : 2020 2020 2020 2020 2020 2020 2020 2020
0x00544D24 : 2020 2020 2020 2020 2020 2020 2020 2020
0x00544D34 : 2020 2020 2020 2020 5351 4C45 4A41 5220 SQLEJAR
0x00544D44 : 0000 3681 1C00 0000 0000 0000 0000 0000 ..6............ .
0x00544D54 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x00544D64 : 2020 2033 3835 3033 38503

2007-05-21-12.00.05.497988 +330 I6082677G427 LEVEL: Severe
PID : 3235 TID : 5507376 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashH andler, probe:15
MESSAGE : DiagData
DATA #1 : Hexdump, 24 bytes
0x08052D90 : 4120 6E6F 6E2D 4544 5520 6368 696C 6420 A non-EDU child
0x08052DA0 : 6372 6173 6865 642E crashed.

2007-05-21-12.00.05.498071 +330 I6083105G349 LEVEL: Severe
PID : 3235 TID : 5507376 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashH andler, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBF9C8C34 : 935D 0000 .]..

2007-05-21-12.00.05.498081 +330 I6083455G945 LEVEL: Error
PID : 23938 TID : 3064723136 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : Hexdump, 136 bytes
0x08177204 : 5351 4C43 4120 2020 8800 0000 95FB FFFF SQLCA ........
0x08177214 : 1600 30FF 2AFF 2AFF 2AFF 2AFF FF73 6572 ..0.*.*.*.*..se r
0x08177224 : 7665 7253 656E 64FF 2020 2020 2020 2020 verSend.
0x08177234 : 2020 2020 2020 2020 2020 2020 2020 2020
0x08177244 : 2020 2020 2020 2020 2020 2020 2020 2020
0x08177254 : 2020 2020 2020 2020 5351 4C45 4A41 5220 SQLEJAR
0x08177264 : 0000 3681 1C00 0000 0000 0000 0000 0000 ..6............ .
0x08177274 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x08177284 : 2020 2033 3835 3033 38503

2007-05-21-12.00.05.498123 +330 I6084401G349 LEVEL: Severe
PID : 3235 TID : 5507376 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashH andler, probe:17
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBF9C8C2C : 0101 0000 ....

2007-05-21-12.00.06.005794 +330 I6084751G349 LEVEL: Severe
PID : 3235 TID : 5507376 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashH andler, probe:18
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBF9C8C30 : FFFF FFFF ....

2007-05-21-12.00.10.527823 +330 I6085101G386 LEVEL: Info
PID : 26942 TID : 5507376 PROC : db2agent (idle)
INSTANCE: db2inst1 NODE : 000 DB : DEV3DB
APPHDL : 0-380 APPID: *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, data protection, sqlpterm, probe:3200
MESSAGE : Database shutdown with next LSN of 000000001964000 C.

2007-05-21-12.00.10.529755 +330 I6085488G386 LEVEL: Info
PID : 23938 TID : 3064723136 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0xBFFBE5AC : 4700 0000 G...

2007-05-21-12.00.10.529864 +330 I6085875G373 LEVEL: Info
PID : 23938 TID : 3064723136 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
RETCODE : ZRC=0x8136001C=-2127167460=SQLZ _RC_NO_CONNECTI ON, SQLT_SQLJC
"No connection"

2007-05-21-12.00.10.530477 +330 I6086249G547 LEVEL: Info
PID : 23938 TID : 3064723136 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1 .070521062955
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
DATA #1 : String, 243 bytes
CALL STACK:
[0] 0xB7621854 _Z12sqljcReceiv eP10sqljCmnMgr + 0x1FA
[1] 0xB768D041 _Z21sqljrDrdaAr DisconnectP7UCi ntfc + 0xB91
[2] 0xB719B218 sqleUCdisconnec t + 0x7A
[3] 0xB7198634 sqleUCtermAllCt x + 0xEE
[4] 0xB717F579 _Z8sqletermcP5s qlca + 0x59

May 21 '07 #1

Subscribe Reply

2561

Similar topics

7258

SQL1131N DARI (Stored Procedure)

by: N.V.Dev | last post by:

Hi, I am trying to use the db2load API using C. During run-time below is the error message thrown call utils.load_table('util.temp') SQL1131N DARI (Stored Procedure) process has been terminated abnormally. SQLSTATE=38503

DB2 Database

1323

DARI memory utilisation

by: Bruce Pullen | last post by:

DB27.2 on AIX 5.2. KEEPDARI = YES MAXDARI = 50 I'm investigating memory paging caused, I believe, by a specific memory-hungry stored procedure and have some questions! 1) Is there a memory pool/limit that is associated with the DARI processes? 2) Do the DARI processes continue to grab physical memory until the

DB2 Database

2440

SQL1131N with INSTALL_JAR on DB2 7.2 FP11

by: gaetan | last post by:

Hi everybody, I have several stored procedure developped in Java that ran fine when I was in DB2 7.2 FP6 (on Windows) but since I have passed the FP11, I'm not able to call any of my stored procedure or call an install_JAR, replace_jar or whatever. I always get the following error : SQL1131N DARI (Stored Procedure) process has been terminated abnormally. SQLSTATE=38503

DB2 Database

7944

SQL Question, Stored Procedure

by: Thomasb | last post by:

With a background in MS SQL Server programming I'm used to temporary tables. Have just started to work with DB2 ver 7 on z/OS and stumbled into the concept of GLOBAL TEMPORARY TABLE. I have created a temporary database with a tables space. Verified that DECLARE GLOBAL TEMPORARY TABLE TEMP (A INTEGER); INSERT INTO SESSION.TEMP VALUES(10); SELECT A FROM SESSION.TEMP; works from a query tool.

DB2 Database

2880

SQL1131N DARI (Stored Procedure) problem

by: dromuss via DBMonster.com | last post by:

I have a problem registering Stored Procedures. I tried diferent stored procedure and non of them work. Not even an empty stored procedure like the following: CREATE PROCEDURE DB2INST1.PRUEBA () LANGUAGE SQL BEGIN END

DB2 Database

1233

SQL1131N after installing a new shared library.

by: Michel Esber | last post by:

Hello, DB2 V7 FP 13 running on Linux. We have developed a C++ shared library that will be called by a db2 stored procedure. Every time my developers generate a new .so shared library, I copy it to /home/db2inst1/sqllib/functions/ and then run a test applications that calls the stored proc. I also run a "bind file.bnd blocking all grant public". The first execution of the procedure (after the .so has been replaced) always fails with...

DB2 Database

1417

Stored procedure failure

by: Michal Hlavac | last post by:

hello, I have interesting problem... I have stored procedure, which works good, but only if input is "correct". Correct input is, when $1 is id, which exists in table... If I put non exists id, database fall down and restart with this error: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed.

PostgreSQL Database

2067

SQL1131N DARI (Stored Procedure) process has been terminated abnormally.

by: taisho | last post by:

HP-UX, DB2v9, Java 1.4.2.13 I attempt to install a stored procedure via SQLJ.install and get the following: db2 "call SQLJ.install_jar('file:/opt/IBM/DB2TOOLS/grp_dir/grouper/server/sp/db2v8/EGFSPROC.jar', 'EGFSPROC.EGFSPROC')" SQL1131N DARI (Stored Procedure) process has been terminated abnormally. SQLSTATE=38503 I've read several posting some regarding memory overflow for too large result set or errant code behaviore in the SP. I...

DB2 Database

2401

v8.1(fp14) GET_DBSIZE_INFO SQL1131N

by: Anonymous Sender | last post by:

On Win32, db2 v8.1 FP14 , when I call SYSCAT.GET_DBSIZE_INFO(?,?,?,-1) then after some moments I get a SQL1131N. (A stored procedure terminated abormally). This is on a newly created database, automatic storage. Any suggestions?

DB2 Database

9592

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10004

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9870

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8886

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6678

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5313

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5450

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3972

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2817

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General