PM94719: DISABLE DDF_COMPATIBILITY IN DB2 11 WHEN USING APPLCOMPAT(V11R1).

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2DDF DM1743 DN1773
  Disable DDF_COMPATIBILITY in DB2 11 when using APPLCOMPAT(V11R1)
  
  
  Additional keywords and symptoms:
  *********************************
  DDFCOMPAT DSN6FAC DB2DDF
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 and DB2 11 for z/OS users of      *
  *                 DDF_COMPATIBILITY zparm                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR disables the system parameter *
  *                      DDF_COMPATIBILITY if application        *
  *                      compatibility level is equal to or      *
  *                      greater than V11R1.                     *
  *                      The IFCID 366 trace record will be      *
  *                      written with QW0366FN set to 8 if the   *
  *                      DDF_COMPATIBILITY zparm is set to       *
  *                      SP_PARMS_NJV to indicate output         *
  *                      parameters is returned from a stored    *
  *                      procedure using the corresponding       *
  *                      CALL statement arguments.               *
  *                      ("NJV" refers to "non-Java".)           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For DB2 11, this APAR disables the DDF_COMPATIBILITY
  system parameter when application compatibility is equal to or
  greater than V11R1.
  The DDF_COMPATIBILITY setting is recognized when the application
  compatibility level is equal to V10R1.  The setting is ignored
  when application compatibility level is equal to or greater
  than V11R1.
  
  This APAR also provides tracing in both DB2 10 and 11 to ensure
  customers know they are going through a path that depends
  on the setting of DDF_COMPATIBILITY.
  
  The IFCID 366 trace record will include a new value, as
  follows:
  
  A new value of 8 for QW0366FN is created for the IFCID 366 trace
  records.
  
  QW0366FN = 8
  A QW0366FN=8 record indicates that DB2 for z/OS server returned
  output data which matches the data types of the corresponding
  CALL statement arguments when DDF_COMPATIBILITY zparm is set to
  SP_PARMS_NJV.
  
  
  Please refer to ++HOLD DOC change for more information.
  
  Note: In order to let the customers get consistent
  application behavior cross DB2 releases, we have also added
  DB2 10 apar PM86374 changes to DB2 11 in this APAR.  Therefore,
  customers can get the trace IFCID 366 QW0366FN = 7 when they set
  system parameter DDF_COMPATIBILITY to DISABLE_IMPCAST_NJV.
  
  Please refer to ++HOLD ACTION for more information.
  

Problem conclusion

Temporary fix

Comments

• Additional Keywords: IFCID366
  

APAR Information

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

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

  UK97973 UK97974

Modules/Macros

• DSN@XAZP DSNDQWPZ DSNDQW05 DSNLXRSS DSNLZD00 DSNTINST DSNTXAZP
  DSNWZIFB DSNXERT2 DSNXRIHD DSNXRIHS DSNXROHE DSN6FAC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK97973

     UP13/10/16 P F310

• RB10 PSY UK97974

     UP13/10/16 P F310

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.