| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC95225 | Status: Closed |
SET VARIABLE STATEMENT MAY CAUSE DB2 TO TERMINATE ABNORMALLY. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem 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 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 3 * **************************************************************** | |
| Local Fix: | |
Assignment of DEFAULT should have been blocked. Do not assign DEFAULT to the variable. | |
| available fix packs: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
| Solution | |
Problem has been fixed in DB2 Version 10.5 Fix Pack 3 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.08.2013 08.05.2014 08.05.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.3 |
|
| 10.5.0.3 |
|
| 10.5.0.4 |
|