IC67635: COMMAND "LIST <DB>" ON UNICODE DATABASE PRODUCES "PREPARE FAILEDIN CURRENT DATABASE" ERROR

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 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