PK61657: ABEND0C4 RC0000003B DSNXGSFN+29FE BAD INTERNAL POINTER INVOLVINGDECRYPTION CHAR. AND WITH MRF MULTI ROW FETCH AN U4087 OCCURS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC0000003B DSNXGSFN+29FE BAD INTERNAL POINTER INVOLVING
  DECRYPTION CHAR.  In addition, if run with MRF multi row fetch
  (under Dsntep4), an U4087 occurs.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS users *
  *                 of the DECRYPT_CHAR function.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND0C4 RC3B can occur at location  *
  *                      DSNXGSFN +29FE for an SQL statement     *
  *                      that contains the DECRYPT_CHAR scalar   *
  *                      function.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the DECRYPT_CHAR scalar function in an SQL statement,
  an ABEND0C4 rc3B can occur at location DSNXGSFN +29FE.
  
  The failure occurs because DB2 processed the DECRYPT_CHAR
  function's second parameter (which is a password-string-
  expression) incorrectly.
  
  The following example helps illustrate the problem.
  
  Step 1. Create a table with a FOR BIT DATA column.
  
    CREATE TABLE ENCRYPTSTUFF
      (TEXT_ENCR  VARCHAR(60) FOR BIT DATA  NOT NULL WITH DEFAULT,
       KEY  CHAR(6)   NOT NULL WITH DEFAULT);
  
  Step 2. Insert into the table.
  
    INSERT INTO ENCRYPTSTUFF (TEXT_ENCR, KEY)
      VALUES (ENCRYPT_TDES('David','123456'), '123456');
  
  Step 3. Select from the table.
  
    SELECT DECRYPT_CHAR(text_encr,Key) FROM ENCRYPTSTUFF;
  
  
  The ABEND may also occur for an SQL statement that contains
  other DECRYPT scalar functions, i.e. DECRYPT_BINARY,
  DECRYPT_BIT, or DECRYPT_DB.
  
  Please note that an incorrect result can also occur for the case
  where the second parameter of the DECRYPT_CHAR function is
  specified as the character string 'DEFAULT'.  For example,
  
    SELECT TEXT, DECRYPT_CHAR(TEXT_ENCR,'DEFAULT')
      FROM ENCRYPTSTUFF;
  
  The incorrect output is caused by DB2 not processing the
  DECRYPT_CHAR function properly for an SQL statement that
  contains encoding for multiple CCSIDs.
  

Problem conclusion

• The code in DB2 is modified to process the DECRYPT_CHAR function
  properly.
  
  Additional Keywords: DECRYPTBIT DECRYPTCHAR DECRYPTBINARY
                       DECRYPTDB SQLDECRYPTBIT SQLDECRYPTCHAR
                       SQLDECRYPTBINARY SQLDECRYPTDB SQLCCSID
  

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:

  UK36580 UK36581

Modules/Macros

• DSNXGSFN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK36580

     UP08/06/04 P F806

• R910 PSY UK36581

     UP08/06/04 P F806

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.