A fix is available
APAR status
Closed as program error.
Error description
The following issues are resolved with this APAR: 1. IDAA_DUAL or IDAA_ONLY job ends with a RC=0 instead of a RC=8 when the job fails with AQT20121E and <SQLCODE>-20569</SQLCODE> 2. 'BACKUP_ACCELERATOR TABLE' job fails with a SQLCODE -206 when column name is greater than 30 characters. HLOU4080E 063 12:04:23.65 DSNT408I SQLCODE = -206, ERROR: <column name> IS HLOU4080E 063 12:04:23.65 NOT VALID IN THE CONTEXT WHERE IT IS USED HLOU4080E 063 12:04:23.65 DSNT418I SQLSTATE = 42703 SQLSTATE RETURN CODE 3. HLOU5806W message does not show the column name when column name is greater than 30 characters HLOU5806W 070 11:05:28.18 Column ############################## data is too long. Record=1
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Users * **************************************************************** * PROBLEM DESCRIPTION: 1. IDAA_DUAL or IDAA_ONLY job ends * * with a RC=0 instead of a RC=8 when * * the job fails with AQT20121E and * * <SQLCODE>-20569</SQLCODE> * * * * 2. 'BACKUP_ACCELERATOR TABLE' job * * fails with a SQLCODE -206 when column * * name is greater than 30 characters. * * * * 3. HLOU5806W message does not show the * * column name when column name is * * greater than 30 characters * * * **************************************************************** 1. IDAA_DUAL or IDAA_ONLY job ends with a RC=0 instead of a RC=8 when the job fails with AQT20121E and SQLCODE -20569 2. 'BACKUP_ACCELERATOR TABLE' job fails with a SQLCODE -206 when column name is greater than 30 characters. 3. HLOU5806W message does not show the column name when column name is greater than 30 characters
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH44931
Reported component name
IDAA LOADER ZOS
Reported component ID
5639OLA00
Reported release
210
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-03-16
Closed date
2022-03-25
Last modified date
2022-04-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI79894
Modules/Macros
HLO$$SEQ HLOADDTB HLODDL HLOIFDDL HLOMSGEN HLOPACEL HLOPAOBK HLOPCHCK HLOPCOPY HLOPDITB HLOPDOBJ HLOPEXEC HLOPEXPR HLOPFILE HLOPFSPC HLOPHALO HLOPLINE HLOPLIST HLOPLOAD HLOPMSG HLOPMSGI HLOPOPTS HLOPOSGS HLOPPFLE HLOPPRSE HLOPPSTR HLOPQUIS HLOPREBU HLOPRECO HLOPREOR HLOPRUNS HLOPSCNV HLOPSTMT HLOPSTPR HLOPSTRG HLOPTMPL HLOPUNLD HLOPUTLM HLOPUTLU HLOPUTLX HLORBKU1 HLORBTHD HLORUSQA HLORUSQL HLOSBTHD HLOSDB2I HLOSINIT HLOSTSRV HLOSUSQA HLOSUSQL HLOUBKU1 HLOUBKUC HLOUCBAS HLOUCE15 HLOUCLBK HLOUCOBJ HLOUCOPY HLOUDISC HLOUDVSI HLOUFSPC HLOUGDSN HLOUHAL1 HLOUHLTP HLOUHMON HLOUHTMG HLOULDEF HLOUMAIN HLOURCES HLOUSE15 HLOUSE35 HLOUSORT HLOUTMGR HLOUUCIN HLOUUCNV
Fix information
Fixed component name
IDAA LOADER ZOS
Fixed component ID
5639OLA00
Applicable component levels
R210 PSY UI79894
UP22/03/29 P F203
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":"2.1.0"}]
Document Information
Modified date:
02 April 2022