IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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

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