home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC91804 Status: Geschlossen

SET VARIABLE STATEMENT MAY CAUSE DB2 TO TERMINATE ABNORMALLY.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 3 or higher.            * 
****************************************************************
Local-Fix:
Assignment of DEFAULT should have been blocked.   Do not assign 
DEFAULT to the variable.
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Problem has been fixed in DB2 Version 10.1 Fix Pack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.04.2013
21.10.2013
21.10.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList