IBM Support

PM83404: ABEND04E RC00E70005 IN DSNXRSBC P016 FOR A QUERY WITH GETHINT FUNCTION AND NO HINT IS SPECIFIED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00E70005 IN DSNXRSBC P016 FOR A QUERY WITH GETHINT
    FUNCTION AND NO HINT IS SPECIFIED
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users who use  *
    *                 the GETHINT built-in function to retrieve    *
    *                 the hint for the password with which the     *
    *                 data were encrypted.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E70005 in DSNXRSBC P016    *
    *                      may occur when the GETHINT built-in     *
    *                      function is used to retrieve the hint   *
    *                      for the password with which the data    *
    *                      of a NOT NULL column were encrypted     *
    *                      but there was no hint specified during  *
    *                      data encryption.                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    ABEND04E RC00E70005 in DSNXRSBC P016 may occur when the GETHINT
    built-in function is used to retrieve the hint for the password
    with which the data of a NOT NULL column were encrypted but
    there was no hint specified during data encryption.
    
     =========
      EXAMPLE
     =========
    
     CREATE TABLE PM83404 (C1 CHAR(250) NOT NULL);
    
     -- set encryption password without hint
     SET ENCRYPTION PASSWORD ='Ben123';
    
     INSERT INTO PM83404 VALUES('ABCDEFGH') ;
    
     -- abend occurs
     SELECT GETHINT(ENCRYPT_TDES(C1)) FROM PM83404;
    
    DB2 has incorrectly set the result nullability of GETHINT to
    NOT NULL when the argument is NOT NULL, which causes the abend
    and incorrect nullability information in DESCRIBE, DSNTIAUL
    sample program, and dynamic SQL processing programs such as
    SPUFI, DSNTEP2, and DSNTEP4. The result nullability of GETHINT
    should be 'nullable'.
    

Problem conclusion

  • DB2 code has been modified to handle the GETHINT built-in
    function correctly.
    
    Additional keywords: SQLDECRYPT SQLENCRYPT SQLNULL SQLGETHINT
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM83404

  • 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-02-21

  • Closed date

    2013-05-13

  • 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:

    UK94230 UK94231

Modules/Macros

  • DSNXOBFA
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK94230

       UP13/05/29 P F305

  • R910 PSY UK94231

       UP13/05/29 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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 June 2013