|
Problem IT39800
|
Status: Closed |
DB2 SERVER COULD TERMINATES ABNORMALLY OR GET -301 WHEN RUNNING A PROCEDURE.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Issuing a procedure with subroutines may cause the server to
terminate abnormally or get -301 error.
Below is an example of the trap stack from the trap file
Generated:
-------Frame------ ------Function + Offset------
0x0900000013650C18 sqlvint2chr + 0x118
0x0900000015B57420
sqlriConvertInt2Chars__FP8sqlrr_cbP10sqlz_valueT2b + 0x280
0x0900000019EB94E4
sqlriConvertZvaluePsm__FP8sqlrr_cbP10sqlz_valueP20sqlri_opparm_b
ni_argPlUlbT6T2T6 + 0x2C4
0x0900000019EB90D4 sqlribniCbFromZValuePsm__FP14db2UCinterface +
0x754
0x0900000019EB2EC4 sqlribni__FP8sqlrr_cb + 0x344
0x0900000016620948 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x628
0x090000001568A568 sqlrr_process_execute_request__FP8sqlrr_cbib
+ 0x37A8
0x0900000015624340 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x4A0
0x0900000017D5926C executeSection__10pvmPackageFP5sqlcaUib +
0x98C
0x0900000017D54228 executeQuery__3PVMFUib + 0x208
0x0900000017D60EE0 run__3PVMFv + 0xFE0
0x0900000017D6DCFC invokeSubroutine__3PVMFP10sqlri_ufobP5sqlca +
0x73C
0x0900000017D4CD90 pvm_entry + 0x690
0x0900000013555EEC sqloInvokeFnArgs + 0x5D6C
0x0900000016F1C3D8
IPRA.$sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorInt
fb + 0x2AF8
0x0900000016F12128 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x2008
0x0900000016F13030 sqlricall__FP8sqlrr_cb + 0x670
0x0900000016620948 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x628
0x090000001568A4A0 sqlrr_process_execute_request__FP8sqlrr_cbib
+ 0x36E0
0x0900000015624340 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x4A0
0x0900000017D5926C executeSection__10pvmPackageFP5sqlcaUib +
0x98C
0x0900000017D54228 executeQuery__3PVMFUib + 0x208
0x0900000017D60EE0 run__3PVMFv + 0xFE0
0x0900000017D6DCFC invokeSubroutine__3PVMFP10sqlri_ufobP5sqlca +
0x73C
0x0900000017D4CD90 pvm_entry + 0x690
0x0900000013555EEC sqloInvokeFnArgs + 0x5D6C
..snip.. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All user using SP *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade v11.5 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All user using SP *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade v11.5 *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.01.2022
28.03.2022
28.03.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
