We have one Sync SP running in our staging Env that throws following Error
While same procedure runs on PRODUCTION smoothly.
Code:
11:00:05,785 INFO [DefaultQuartzScheduler_Worker-9] (AccountSynchronizationDao) - SP executed, result map: {sqlMessage=
SQL30020N Execution failed because of a Distributed Protocol Error that will affect the successful execution of subsequ
ent commands and SQL statements: Reason Code "0x1245"("0117")"". SQLSTATE=58009 , sqlCode=-30020, sqlState=58009}
I could not find the Reason code 0117 from documentation.
This seems to be communication error.
Following are some Diaglog entries that I do not understand
Code:
2009-03-02-22.52.26.140000 Instance:DB2 Node:000
PID:2980(DB2PGIXT.EXE) TID:2728 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0012EB6C : 0x00000002 ....
PID:2980 TID:2728 Node:000 Title: Path/Filename
C:\SQLLIB\DB2\db2nodes.cfg
and
Code:
2009-03-03-01.52.07.031000 Instance:DB2 Node:000
PID:3104(db2syscs.exe) TID:1332 Appid:none
common communication sqlcctcpconnmgr_child Probe:108
DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SORCVBUF" = "65536" is "accepted".
and
Code:
2009-03-03-02.42.09.265001 Instance:DB2 Node:000
PID:3104(db2syscs.exe) TID:3068 Appid:GA460446.C00E.090303074208
runtime interpreter sqlri_tbl_in_mem_alloc Probe:190 Database:ECX
sqlri_tbl_in_mem_alloc(): Active=Y, Reason=0, Mem=2414, #InSubq=182, TIMMax#=182, %FitInTIM=100.00
Following is Server description
Code:
C:\Documents and Settings\db2admin>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08015" with
level identifier "02060106".
Informational tokens are "DB2 v8.1.5.449", "s040212", "WR21334", and FixPak
"5".
Product is installed at "C:\SQLLIB".
C:\Documents and Settings\db2admin>
I have set Diaglevel to 4
Please help me understand above diaglog entries.
Thanks
DBFinder
dBforums
>
Stored Procedure Throws Exception
03-03-09, 09:27
Linear Mode
