Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
Executng a Stored Procudure (SP) in a DPF environment might crash the instance. This will only occur if the SP is executed from a non-catalog partition. On the partition where the SP is executed the first DB2 Trap file generated with contain the following partial stack traceback: ossDumpStackTrace + 0x0080 OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa sqlo_trce + 0x033b sqloEDUCodeTrapHandler + 0x0074 address: 0x0000002A957D34F0 ; dladdress: 0x0000002A957C7000 ; offset in lib: 0x000000000000C4F0 ; sqlrl_userTempGetInfoP8sqlrr_cbiP19sqlrl_tbspace_parmsP12sqlrg_s eq_pdPtP14sqlrg_partkeyd + 0x029c sqlrl_declare_g_t_tableP8sqlrr_cbPhsP17sqlrl_table_parmsP8sqlrg_ pdP12sqlrg_seq_pdP18sqlrg_datapartinfo + 0x06be sqlnq_create_table_endP9sqlnq_qtbmiS0_RmP10sqlrl_fldsP25sqlnq_ba se_table_seq_info + 0x281c sqlnq_table_defn1PP8stknode_i10actiontypePhP3loc + 0x0b8f
Local fix
Execute the Stored Procedure from the catalog partition.
Problem summary
Users Affected: ALL Problem Description: Please refer to 'ERROR DESCRIPTION' Problem Summary: Please refer to 'ERROR DESCRIPTION'
Problem conclusion
Problem was first fixed in Version 9.1 FixPack 6
Temporary fix
see LOCAL FIX
Comments
APAR Information
APAR number
IZ20888
Reported component name
DB2 DPF
Reported component ID
5724N7400
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-04-23
Closed date
2009-01-08
Last modified date
2009-01-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
IZ21044
Fix information
Fixed component name
DB2 DPF
Fixed component ID
5724N7400
Applicable component levels
R910 PSN
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]
Document Information
Modified date:
03 October 2021