IBM Support

PM95791: ENHANCE FM/DB2 COPY AND IMPORT UTILITIES TO USE DB2 SPECIFIED DEFAULT VALUES FOR UNMAPPED COLUMNS WHEN INSERTING ROWS.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Enhance FM/DB2 Copy and Import utilities to use any
    DB2 specified default values (constants) for unmapped columns
    when inserting rows into the target table.
    

Local fix

  • Use attributes on the unmapped column in the target column to
    specify default (constant) values.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of File Manager DB2 component.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: File Manager DB2 component copy and     *
    *                      import functions are not using          *
    *                      DB2-specified default values when       *
    *                      inserting rows into the target DB2      *
    *                      object.                                 *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    Enhancement APAR.  The File Manager DB2 editor initializes
    columns with DB2-specified default values to the default value
    when inserting rows.  For Copy and Import, unmapped columns
    are initialized to spaces or zero, depending on data type,
    rather than the DB2-specified default value.
    

Problem conclusion

Temporary fix

Comments

  • File Manager DB2 component has been enhanced as follows:
    For the File Manager DB2 copy and import utilities, any rows
    inserted into the target DB2 object will have unmapped columns
    initialized to the DB2-specified default value for that column.
    This APAR also changes the way data for BINARY and VARBINARY
    columns is displayed in the FM/DB2 editor.  Data for these
    columns is now shown in long hex format.
    

APAR Information

  • APAR number

    PM95791

  • Reported component name

    FILE MANAGER Z/

  • Reported component ID

    5655W6800

  • Reported release

    C12

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-08-26

  • Closed date

    2013-12-24

  • Last modified date

    2014-02-11

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

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

    UI13825 UI13826 UI13827 UI13828 PI11462

Modules/Macros

  • FMNCADEF FMNCADS  FMNDVTLC FMNEDIT1 FMNED0DY FMNEGXML FMNRDCCO
    FMNRDFFD FMNRDFNM FMNRDFSG FMNRDFTB FMNRDMSC FMNRDR   FMNRDRAR
    FMNRDRCV FMNRDR2  FMNRDUFD FMNRDUHX FMNRDUSG FMNRDUTB FMNRDUZD
    FMNRDU2V FMNRDXML FMNRD2IN FMNSCREX FMNSQLTF FMN0LVL  FMN2BCTQ
    FMN2BUCL FMN2CATQ FMN2CTMP FMN2CTQ2 FMN2DBC  FMN2DBI  FMN2DENP
    FMN2DENU FMN2DIUS FMN2DJPN FMN2DKOR FMN2D2E  FMN2D2EI FMN2D2L
    FMN2D2LI FMN2EDSP FMN2EDT1 FMN2ETRC FMN2GV20 FMN2GV29 FMN2LVL
    FMN2LVLJ FMN2LVLK FMN2SEDX FMN2SENX FMN2SQSU
    

Fix information

  • Fixed component name

    FILE MANAGER Z/

  • Fixed component ID

    5655W6800

Applicable component levels

  • RC1B PSY UI13827

       UP14/01/31 P F401

  • RC10 PSY UI13825

       UP14/01/31 P F401

  • RC12 PSY UI13826

       UP14/01/31 P F401

  • RC13 PSY UI13828

       UP14/01/31 P F401

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:
11 February 2014