APAR status
Closed as program error.
Error description
After a datablade is successfully registered in a unicode database, blademgr produces error while running "list <DB>" command. Following is the repro: 1. export GL_USEGLU=1 2. Restart instance 3. export DB_LOCALE=en_us.utf8 4. echo "create database test_bld_utf8 with buffered log;" | dbaccess - 5. echo "register Node.2.0 test_bld_utf8" | blademgr 6. echo "list test_bld_utf8" | blademgr At this point, blademgr will produce following error: blademgr: ERROR: Prepare failed in current database.
Local fix
set GL_USEGLU=1, unset DB_LOCALE and restart the instance.
Problem summary
**************************************************************** * USERS AFFECTED: * * All 11.50 users. * **************************************************************** * PROBLEM DESCRIPTION: * * A query may return wrong results under the following * * conditions: * * - session uses a locale that has multi-byte characters * * - query uses an index scan with nchar or nvarchar index * * keys * * - query uses MATCHES/LIKE predicate as index filters * * - the pattern used in MATCHES/LIKE predicate contains * * constant pattern followed by a wildcard (% or *) * * - the length of the constant pattern is the same as the * * (maximum) length of the column * * - in the locale used, the next collating character (before * * or after) the last character of the constant pattern is a * * multi-byte character * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC8. * ****************************************************************
Problem conclusion
Protect a structure from being modified while in use. Fix is in11.50.FC7W1.
Temporary fix
Comments
For download information, go to: http://www-933.ibm.com/support/fixcentral/ For documentation information, go to http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp
APAR Information
APAR number
IC67635
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-05
Closed date
2011-01-18
Last modified date
2011-01-21
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
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
21 January 2011