PI50138: INTRODUCES EXIT DECENUBL TO BE USED IN UDFS FOR ENCRYPTION/DECRYPTION OF LOB COLUMN TYPES.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR introduces exit DECENUBL to be used in UDFs for
  encryption/decryption of LOB column types.  DECENUBL is
  functionally equivalent to existing exit DECENUI0 with the
  exception that DECENUBL is modified to support the larger
  (4-byte) length field that precedes the column data, which is
  unique to LOB datatypes.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IBM InfoSphere Guardium Data Encryption  *
  *                 for DB2 and IMS Databases Version 1 Release  *
  *                 2 users.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 exit to support LOB column          *
  *                      encryption in UDFs (PI50138)            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR introduces exit DECENUBL to be used in UDFs for
  encryption/decryption of LOB column types.  DECENUBL is
  functionally equivalent to existing exit DECENUI0 with the
  exception that DECENUBL is modified to support the larger
  (4-byte) length field that precedes the column data, which
  is unique to LOB datatypes.
  

Problem conclusion

Temporary fix

Comments

• 1. After successful SMP/E apply, the Module DECENUBL is
   introduced. This is a DB2 exit to support LOB column
   encryption in UDFs.
  2. After successful SMP/E apply, the samplib member DECDB2UD
   is updated.  It now allows link for DECENUBL, as well as
   DECENU00, DECENUI0, DECENUP0, and DECENURN.
  3. If Customer wishes to use the new DECENUBL UDF, then
   proceed to step 4., else stop here.
  4. Post SMP/E apply, If Customer wishes to use the new DECENUBL
   UDF, Customer should execute the updated samplib member,
   DECDB2UD, to link the new Module DECENUBL.
  5. After successful linking of the DEC V1.2 DECENUBL Module,
   for this APAR, Customer should do either of the following
   actions:
   a. Determine if the .SDSNEXIT library, for the DB2 Subsystem
      where DEC V1.2 is used, is in the System Linklist
      concatenation.
      If so, issue the LLA Refresh command on that System LPAR.
      This will allow Customer to use the updated code, without
      need to Cycle the DB2 Subsystem.
   b. If the .SDSNEXIT library, for the DB2 Subsystem where
      DEC V1.2 is used, is not in the System Linklist
      concatenation,
      Customer will need to Cycle the DB2 Subsystem, in order
      to use the updated code.
  6. Customer should note that changes have been made to the ISPF
   dialog s SDECPLIB, SDECSLIB and SDECCEXE libraries, to
   accommodate using DECENUBL, via the ISPF panel DECPU0.
  

APAR Information

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

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

  UI32569

Modules/Macros

• DECDB2UD DECENC07 DECENUBL DECF00U5 DECHU0
  DECPU0   H29F120J
  

Fix information

• Fixed component name

  DATA ENCRYPTION

• Fixed component ID

  5655P0300

Applicable component levels

• R120 PSY UI32569

     UP15/11/05 P F511

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.