IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PM94719

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-07

  • Closed date

    2013-09-26

  • Last modified date

    2014-01-24

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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
24 January 2014