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

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

     UP

• R910 PSY

     UP