A fix is available
APAR status
Closed as program error.
Error description
Bypassing DEFAULTIF is an advanced option that can be set by manually editing the JCL of a LOAD job. A problem occurs when loading information from a detail report of any table with a non-NULL column that has a DEFAULT value. When this situation occurs, some of the data in the LOADFILE for the column after the non-NULL and DEFAULT column will be incorrectly overwritten.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: User of DB2 Log Analysis Tool. * **************************************************************** * PROBLEM DESCRIPTION: Bypassing DEFAULTIF is an advanced * * option that can be set by manually * * editing the JCL of a LOAD job. A * * problem occurs when loading * * information from a detail report of * * any table with a non-NULL column that * * has a DEFAULT value. When this * * situation occurs, some of the data in * * the LOADFILE for the column after * * the non-NULL and DEFAULT column will * * be incorrectly overwritten. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PK63772
Reported component name
DB2 LOG ANALYSI
Reported component ID
5655E6601
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2008-04-02
Closed date
2008-04-11
Last modified date
2008-05-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK35507 UK35508 UK35509
Modules/Macros
ALAA36 ALAFR1V ALAGLOAD ALALF1 ALAREC ALASQL8C ALASUBG H237310J
Fix information
Fixed component name
DB2 LOG ANALYSI
Fixed component ID
5655E6601
Applicable component levels
R220 PSY UK35507
UP08/04/23 P F804
R230 PSY UK35508
UP08/04/23 P F804
R310 PSY UK35509
UP08/04/23 P F804
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310"}]
Document Information
Modified date:
17 March 2021