PM89230: ABEND04E RC00E70005 AT DSNXGRM1:M258

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E70005 AT DSNXGRM1:M258
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of Graphic,        *
    *                 Vargraphic, and Long Vargraphic host         *
    *                 variables.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 can occur at     *
    *                      location DSNXGRDS DSNXGRM1 M258 for an  *
    *                      SQL statement containing a vargraphic   *
    *                      or long vargraphic host variable which  *
    *                      can be deleted.                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND04E RC00E70005 can occur at location DSNXGRM1 offset
    M258 (OFFSETM258) for a query that contains Graphic data type
    host variables that can be deleted.  The reason for this problem
    is that DB2 doesn't handle a branch correctly for deleted
    Graphic type host variables.
    
    The following example helps to illustrate the problem.
    
    
    1. Create a Table.
    
      CREATE TABLE SYSADM.TABLE1( C1 INT, C2 VARCHAR(12), C3 INT);
    
    2. Prepare the following query in an application.
    
      SELECT * FROM TABLE1
       WHERE C1 = 1 AND NOT ( EXISTS
        ( SELECT CAST( ? AS VARGRAPHIC(40) CCSID UNICODE )
           FROM TABLE1 WHERE C3 = 4 ));
    
    3. Execute the prepared statement in the application.
    
    DB2 should bind the query correctly prior to execution.
    However, the above ABEND occurs because DB2 did not handle the
    vargraphic host variable correctly.
    

Problem conclusion

  • The code in DB2 which processes binding for deleted vargraphic
    host variables has been modified to correct the problem which
    leads to the abend at execution time.
    
    
    Additional Keywords: SQLGRAPHIC SQLHOSTVAR VARGRAPHIC
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM89230

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-17

  • Closed date

    2013-06-30

  • Last modified date

    2013-08-02

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

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

    UK95370

Modules/Macros

  • DSNXGRM1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK95370

       UP13/07/24 P F307

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

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM89230

Modified date:

2013-08-02

Translate my page

Machine Translation

Content navigation