home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC69138 Status: Closed

SQL1034C MAY BE RETURNED WHEN A UNICODE STRING CONSTANT IS REFERENCED
IN A NON-UNICODE DATABASE

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Referencing a Unicode string constant in a non-unicode database 
 
may result in SQL1034C. 
 
<StackTrace> 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------ 
..... 
0x0000002A9A3D00AD 
_Z11sqlzeMapZrcP8sqeAgentjmjP5sqlcaiPK12sqlzeContextb + 0x0e47 
 
(/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1) 
0x0000002A97E4990E _Z10sqlnn_erdmiiiiPK12sqlzeContext + 0x0166 
 
(/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1) 
0x0000002A9850F5E5 
_ZN9sqlnq_qur25find_qnc_constant_literalEPP9sqlnq_qncPhii + 
0x1ca3 
 
(/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1) 
0x0000002A9856229A _Z9sqlnq_semPP8stknode_i10actiontypePhP3loc + 
0x78ca 
 
(/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1) 
0x0000002A9816B71B _Z12sqlnp_smactnP8sqlnp_cbi + 0x09ab 
 
(/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1) 
0x0000002A98165459 _Z12sqlnp_parserP8sqlnp_cb + 0x1579 
 
(/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1) 
0x0000002A9815D642 _Z10sqlnp_mainP12sqlnq_stringsPP9sqlnq_qur + 
0x0b92 
......
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Referencing a Unicode literal string in a non-unicode        * 
* database                                                     * 
* may result in SQL1034C.                                      * 
*                                                              * 
*                                                              * 
*                                                              * 
* <StackTrace>                                                 * 
*                                                              * 
* -----FUNC-ADDR---- ------FUNCTION + OFFSET------             * 
*                                                              * 
* .....                                                        * 
*                                                              * 
* 0x0000002A9A3D00AD                                           * 
*                                                              * 
* _Z11sqlzeMapZrcP8sqeAgentjmjP5sqlcaiPK12sqlzeContextb +      * 
* 0x0e47                                                       * 
*                                                              * 
*                                                              * 
* (/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1 
* 0x0000002A97E4990E _Z10sqlnn_erdmiiiiPK12sqlzeContext +      * 
* 0x0166                                                       * 
*                                                              * 
*                                                              * 
* (/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1 
* 0x0000002A9850F5E5                                           * 
*                                                              * 
* _ZN9sqlnq_qur25find_qnc_constant_literalEPP9sqlnq_qncPhii +  * 
*                                                              * 
* 0x1ca3                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1 
* 0x0000002A9856229A                                           * 
* _Z9sqlnq_semPP8stknode_i10actiontypePhP3loc +                * 
* 0x78ca                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1 
* 0x0000002A9816B71B _Z12sqlnp_smactnP8sqlnp_cbi + 0x09ab      * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1 
* 0x0000002A98165459 _Z12sqlnp_parserP8sqlnp_cb + 0x1579       * 
*                                                              * 
*                                                              * 
*                                                              * 
* (/view/db2_v95fp6_linuxamd64_n100602/vbs/INST/lib/libdb2e.so.1 
* 0x0000002A9815D642                                           * 
* _Z10sqlnp_mainP12sqlnq_stringsPP9sqlnq_qur +                 * 
* 0x0b92                                                       * 
*                                                              * 
* ......                                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 6 or higher.             * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
The problem is first fixed in DB2 Version 9.5 Fix Pack 6.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC69144 IC69145 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.06.2010
30.06.2010
30.06.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)