IBM Support

IC67662: DB2 SERVER MAY HANG ON CALL SYSPROC.WLM_SET_CLIENT_INFO WHEN APPLICATION AND SERVER CODEPAGES ARE DIFFERENT.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If a clp script is used to call stored procedure
    SYSPROC.WLM_SET_CLIENT_INFO and SYSPROC.WLM_SET_CLIENT_INFO
    stored procedure is used to set only the accounting string
    leaving rest of the parameter of the stored procedure call as
    NULL.  For example:
    
    CALL SYSPROC.WLM_SET_CLIENT_INFO(NULL, NULL, NULL, 'Accounting
    department', NULL)
    
    DB2 Server may hang when client and server codepages are
    different.
    
    For example if Application codepage is IBM-943(943) and Database
    codepage is JA_JP.UTF-8(1208), the above statment executed using
    clp script can cause hang on the server. The stack trace of
    hanging agent will look like:
    
    0x0900000035728D7C sqlnls_getmap@glue3E8 + 0x54
    0x0900000035CA0C94 sqlrrGetLiteral__FiPcN22UlPUlPPc + 0x13C
    0x0900000035728C64 sqlrrGetLiteral__FiPcN22UlPUlPPc@glueB04 +
    0x74
    0x0900000035CA04A4 sqlrr_shortcut_excsqlset__FP8sqlrr_cbPcUiPb +
    0x43C
    0x0900000035358EBC sqlrr_excsqlset__FP14db2UCinterface + 0x110
    

Local fix

  • 1. Call stored procdure  SYSPROC.WLM_SET_CLIENT_INFO to set both
    application name accounting string.
    For example:
    CALL SYSPROC.WLM_SET_CLIENT_INFO(NULL, NULL, 'auditor',
    'Accounting department', NULL)
    2. Call SYSPROC.WLM_SET_CLIENT_INFO stored procedure when no
    code page conversion is required
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If a clp script is used to call stored procedure             *
    *                                                              *
    * SYSPROC.WLM_SET_CLIENT_INFO and SYSPROC.WLM_SET_CLIENT_INFO  *
    *                                                              *
    * stored procedure is used to set only the accounting string   *
    *                                                              *
    * leaving rest of the parameter of the stored procedure call   *
    * as                                                           *
    * NULL.  For example:                                          *
    *                                                              *
    *                                                              *
    *                                                              *
    * CALL SYSPROC.WLM_SET_CLIENT_INFO(NULL, NULL, NULL,           *
    * 'Accounting                                                  *
    * department', NULL)                                           *
    *                                                              *
    *                                                              *
    *                                                              *
    * DB2 Server may hang when client and server codepages are     *
    *                                                              *
    * different.                                                   *
    *                                                              *
    *                                                              *
    *                                                              *
    * For example if Application codepage is IBM-943(943) and      *
    * Database                                                     *
    * codepage is JA_JP.UTF-8(1208), the above statment executed   *
    * using                                                        *
    * clp script can cause hang on the server. The stack trace of  *
    *                                                              *
    * hanging agent will look like:                                *
    *                                                              *
    *                                                              *
    *                                                              *
    * 0x0900000035728D7C sqlnls_getmap@glue3E8 + 0x54              *
    *                                                              *
    * 0x0900000035CA0C94 sqlrrGetLiteral__FiPcN22UlPUlPPc + 0x13C  *
    *                                                              *
    * 0x0900000035728C64 sqlrrGetLiteral__FiPcN22UlPUlPPc@glueB04  *
    * +                                                            *
    * 0x74                                                         *
    *                                                              *
    * 0x0900000035CA04A4                                           *
    * sqlrr_shortcut_excsqlset__FP8sqlrr_cbPcUiPb +                *
    * 0x43C                                                        *
    *                                                              *
    * 0x0900000035358EBC sqlrr_excsqlset__FP14db2UCinterface +     *
    * 0x110                                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB version 9.7 fix pack 3.                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC67662

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-04-06

  • Closed date

    2010-09-23

  • Last modified date

    2010-09-23

  • APAR is sysrouted FROM one or more of the following:

    IC67325

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC67662

Modified date: 23 September 2010