IBM Support

JR29208: DB2 MAY TRAP WHEN UCA400_NO COLLATING SEQUENCE IS USED - THIS OCCURS ON WINDOWS ONLY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 server may trap in ICU (International Components for
    Unicode) library code. Function sqlnlsICUopen_UCA400 will be
    displayed in the stack as the top DB2 function.
    
    This problem has been observed only under high user load and is
    very rarely seen. It also happens only on Windows OS and does
    not occur with DB2 V9.5.
    
    You also need to have your database created using UCA400_NO
    collating sequence.
    
    Below is a condensed stack trace you may see after you formated
    the trap file:
    
    ...
    <_sqlnlsICUopen_UCA400.> <sqlnlsCollationOper.C:219>
    <_sqlnlsICUstrcollUTF8_UCA400> <sqlnlsCollationOper.C:565>
    <__PGOSF5_?keypart_dts ... <sqlilkey.C:7353>
    <?sqliCompare ... <sqlilkey.C:5169>
    <?sqlilkey ... <sqlilkey.C:1188>
    <?sqlischf@@YAHPAUSQLI_CB@@GI@Z> <sqlischf.C:6661>
    ...
    

Local fix

Problem summary

  • Users Affected: ALL
    
    Problem Description:
    
    DB2 server may trap in ICU (International Components for
    Unicode) library code. Function sqlnlsICUopen_UCA400 will be
    displayed in the stack as the top DB2 function.
    
    This problem has been observed only under high user load and is
    very rarely seen. It also happens only on Windows OS and does
    not occur with DB2 V9.5.
    
    You also need to have your database created using UCA400_NO
    collating sequence.
    
    Below is a condensed stack trace you may see after you formated
    the trap file:
    
    ...
    <_sqlnlsICUopen_UCA400.> <sqlnlsCollationOper.C:219>
    <_sqlnlsICUstrcollUTF8_UCA400> <sqlnlsCollationOper.C:565>
    <__PGOSF5_?keypart_dts ... <sqlilkey.C:7353>
    <?sqliCompare ... <sqlilkey.C:5169>
    <?sqlilkey ... <sqlilkey.C:1188>
    <?sqlischf@@YAHPAUSQLI_CB@@GI@Z> <sqlischf.C:6661>
    ...
    
    
    Problem Summary:  See Problem Description.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 6 (build s081007)
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR29208

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-05-06

  • Closed date

    2008-11-03

  • Last modified date

    2008-11-03

  • 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

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021