IBM Support

PM87081: PROBLEMS WITH DB2 LOAD UTILITY CONTROL STATEMENTS GENERATED BY FILE MANAGER DB2 UTILITIES FUNCTION.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 LOAD utility control statements generated by File Manager
    DB2 Utilities function do not reflect the LOAD utility option's
    settings.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of File Manager DB2 component.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. The DB2 LOAD utility control         *
    *                      statements generated by the File        *
    *                      Manager DB2 component DB2 Utilities     *
    *                      function do not always reflect the      *
    *                      current option's settings.              *
    *                      2. SQLCODE-302 attempting to insert     *
    *                      data into a unicode-encoded DB2 object  *
    *                      using the File Manager DB2 component    *
    *                      Data Create function.                   *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    1. An internal processing error is corrupting various option
    settings.
    2. The SQLDA for the INSERT statement is not adjusted for
    unicode data.
    

Problem conclusion

  • File Manager DB2 component has been updated to correct the
    problem.  This APAR also resolves internally reported problems
    PFM04872, PFM05967, PFM05968, PFM05969, PFM05993, PFM06001.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM87081

  • Reported component name

    FILE MANAGER Z/

  • Reported component ID

    5655W6800

  • Reported release

    C12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-04-16

  • Closed date

    2013-08-23

  • Last modified date

    2013-09-03

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

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

    UK96965 UK96966 UK96967 UK96968 UK96969 UK96970

Modules/Macros

  • FMNASMX  FMNCBLX  FMNCSEL  FMNDB00  FMNDB37  FMNDB48  FMNDSM
    FMNDYNTP FMNEDCRS FMNEDIT  FMNEDIT4 FMNEDIT6 FMNED0DY FMNED1EX
    FMNEGXML FMNFCH   FMNOPTP2 FMNPDSMZ FMNPLIX  FMNPPCLA FMNPPGTK
    FMNPPMN  FMNPPNAV FMNRDFFD FMNRDFNM FMNRDFSG FMNRDFTB FMNRDR2
    FMNRDUFD FMNRDU2V FMNRD2IN FMNRMDAT FMNTPDFD FMN0LVL  FMN0LVLJ
    FMN0LVLK FMN2AUDI FMN2A2IO FMN2CGM2 FMN2CTMP FMN2CTM1 FMN2CTQ2
    FMN2DBC  FMN2DBI  FMN2DBP  FMN2DBX  FMN2DBY  FMN2DIUS FMN2D2E
    FMN2D2EC FMN2D2EG FMN2D2EI FMN2D2EL FMN2D2ES FMN2D2G  FMN2D2SP
    FMN2EDSP FMN2EDT1 FMN2FAF3 FMN2FAO3 FMN2FAS1 FMN2FI45 FMN2FLD6
    FMN2ISQG FMN2ISQI FMN2LOCL FMN2LVL  FMN2LVLJ FMN2LVLK FMN2MENU
    FMN2MJPN FMN2MKOR FMN2MXXX FMN2POTI FMN2RD64 FMN2RET1 FMN2RET2
    FMN2RMDT FMN2RMR  FMN2RMR2 FMN2RMUT FMN2RPTO FMN2RX61 FMN2SBPR
    FMN2SEDX FMN2SELS FMN2SENX FMN2SQSU FMN2SQS2 FMN2SSSU FMN2ST00
    

Fix information

  • Fixed component name

    FILE MANAGER Z/

  • Fixed component ID

    5655W6800

Applicable component levels

  • RC1A PSY UK96966

       UP13/08/28 P F308

  • RC1B PSY UK96967

       UP13/08/28 P F308

  • RC10 PSY UK96965

       UP13/08/28 P F308

  • RC11 PSY UK96968

       UP13/08/28 P F308

  • RC12 PSY UK96969

       UP13/08/28 P F308

  • RC13 PSY UK96970

       UP13/08/28 P F308

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C12","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
03 September 2013