PM85976: ABEND0C4 RC38 AT DSNXEBR OFFSET 441C WHEN SET CURRENT OPTIMIZATION HINT = '' FROM JAVA APPLICATION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Abend0c4 rc38 at dsnxebr offset 441c could happen when
    specifying special register SET CURRENT OPTIMIZATION HINT = ''
    from java application.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users of the   *
    *                 CURRENT OPTIMIZATION HINT and CURRENT SQLID  *
    *                 special registers.                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND0C4 RC4 at DSNXEBR OFFSET441C   *
    *                      or an ABEND04E RC00E70005 at location   *
    *                      DSNXESX4 M999 can occur when executing  *
    *                      special register statements SET CURRENT *
    *                      OPTIMIZATION HINT = '' or SET CURRENT   *
    *                      SQLID = '' with a UNICODE encoding      *
    *                      scheme.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND0C4 RC4 at DSNXEBR OFFSET441C or an ABEND04E RC00E70005
    at location DSNXESX4 M999 can occur when executing the SET
    CURRENT OPTIMIZATION HINT = '' or the SET CURRENT SQLID = ''
    special register statements.  These failures can occur from
    dynamic or static SQL when a UNICODE encoding scheme is
    employed.
    
    The following example illustrates a failing case.
    
      SET CURRENT OPTIMIZATION HINT = '';
    
    If this statement is executed from a dynamic java application,
    the ABEND0C4 at DSNXEBR can occur.
    
    If this statement is executed from within a static package bound
    with the ENCODING(UNICODE) bind option, the ABEND04E at DSNXESX4
    can occur.
    
    The problem occurs because DB2 doesn't handle the length of the
    empty string correctly.
    

Problem conclusion

  • The code in DB2 is modified to process the length of an empty
    string properly when used in the CURRENT OPTIMIZATION HINT or
    the CURRENT SQLID special register statement.
    
    Additional Keywords:  N/A
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM85976

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-31

  • Closed date

    2013-05-09

  • Last modified date

    2013-06-04

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

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

    UK94179 UK94180

Modules/Macros

  • DSNXGRTM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK94179

       UP13/05/25 P F305 ½

  • R910 PSY UK94180

       UP13/05/25 P F305 ½

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM85976

Modified date:

2013-06-04

Translate my page

Machine Translation

Content navigation