Fixes are available
APAR status
Closed as program error.
Error description
Assignment of DEFAULT to a variable may return SQL1224N. The error stack looks like the following: <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002AAAB2DF955D ossDumpStackTraceEx + 0x0301 0x00002AAAB2DF3BCE _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x0270 0x00002AAAAE6AE1B7 sqlo_trce + 0x0509 0x00002AAAAE7B4C1D sqloEDUCodeTrapHandler + 0x0467 0x00002AAAAABD5E00 address: 0x00002AAAAABD5E00 ; dladdress: 0x00002AAAAABC8000 ; offset in lib: 0x000000000000DE00 ; 0x00002AAAAC344A48 _ZNK17sqlnq_qunqncchild2ppEv + 0x0010 0x00002AAAAD9650D9 address: 0x00002AAAAD9650D9 ; dladdress: 0x00002AAAAACE1000 ; offset in lib: 0x0000000002C840D9 ; 0x00002AAAAD9661DE address: 0x00002AAAAD9661DE ; dladdress: 0x00002AAAAACE1000 ; offset in lib: 0x0000000002C851DE ; 0x00002AAAAD966DED _Z29sqlnq_sem_variable_set_clausePP8stknode_i10actiontypePhP3loc + 0x0b3b 0x00002AAAAD82F68E _Z12sqlnp_smactnP8sqlnp_cbi + 0x11a4 0x00002AAAAD81EEB1 _Z12sqlnp_parserP8sqlnp_cb + 0x159b 0x00002AAAAD82518E _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x0c5a 0x00002AAAAD46F2F5 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur + 0x5d09 0x00002AAAAD468F0A _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + 0x007c
Local fix
Assignment of DEFAULT should have been blocked. Do not assign DEFAULT to the variable.
Problem summary
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgarde to DB2 Version 9.7 Fix Pack 9 or later. * ****************************************************************
Problem conclusion
Problem has been fixed in DB2 Version 9.7 Fix Pack 9
Temporary fix
Comments
APAR Information
APAR number
JR46165
Reported component name
CONTROL CENTER
Reported component ID
5724N9704
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-03-27
Closed date
2013-12-17
Last modified date
2013-12-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
CONTROL CENTER
Fixed component ID
5724N9704
Applicable component levels
R970 PSN
UP
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
24 March 2022