A fix is available
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