A fix is available
APAR status
Closed as program error.
Error description
The following changes are included in this APAR: # Support accelerator group names on Consistent Load and Image Copy load jobs. ISPF also modified to generate Consistent Load and Image Copy load jobs with group names. # TCz changes to specify Microsoft SQL Server as a source during configuration of the HLV server and generate IN00 including SQL Server. # Support usage of DB2 SSID or Group attach name for data sharing in ISPF. # HA LOAD jobs may fail with SQLCODE = -804, when many tables specified. This changes are to handle this by increasing the Variable length so that HALOAD can handle more characters in the list of tables. # ISPF panels updated to follow guidelines on abbreviations.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Analytics Accelerator Loader * * for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: -Support accelerator group names on * * Consistent Load and Image Copy load * * jobs. ISPF also modified to generate * * Consistent Load and Image Copy load * * jobs with group names. * * -TCz changes to specify Microsoft * * SQL Server as a source during * * configuration of the HLV server and * * generate IN00 including SQL Server. * * -Support usage of DB2 SSID or Group * * attach name for data sharing in ISPF. * * -HA LOAD jobs may fail with * * SQLCODE = -804, when many tables * * specified. This changes are to handle * * this by increasing the Variable length * * so that HALOAD can handle more * * characters in the list of tables. * * -ISPF panels updated to follow * * guidelines on abbreviations. * **************************************************************** * RECOMMENDATION: Apply the PTF. * **************************************************************** -Support accelerator group names on Consistent Load and Image Copy load jobs. ISPF also modified to generate Consistent Load and Image Copy load jobs with group names. -TCz changes to specify Microsoft SQL Server as a source during configuration of the HLV server and generate IN00 including SQL Server. -Support usage of DB2 SSID or Group attach name for data sharing in ISPF. -HA LOAD jobs may fail with SQLCODE = -804, when many tables specified. This changes are to handle this by increasing the Variable length so that HALOAD can handle more characters in the list of tables. -ISPF panels updated to follow guidelines on abbreviations.
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PH09817
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
2019-03-15
Closed date
2019-05-16
Last modified date
2019-06-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI63085
Modules/Macros
HLO#AMIN HLO#ASYS HLO#CARD HLO#CHKR HLO#CNTL HLO#CPNT HLO#CPOL HLO#DSPL HLO#ENQS HLO#FCPY HLO#ICAL HLO#JPRI HLO#LGAA HLO#LGAC HLO#LGAF HLO#LGAI HLO#LGAP HLO#LOGR HLO#LRD6 HLO#LRDR HLO#MAIN HLO#MLOG HLO#PRNG HLO#RANG HLO#RPRP HLO#RUNT HLO#SUBD HLO#SUBX HLO#SYSC HLO#UTED HLO#WRIT HLO#XMLI HLO#XMLJ HLO#XMLS HLO$$PRM HLO$ACCS HLO$ACES HLO$ADM2 HLO$ADMN HLO$BJBC HLO$BUTA HLO$BUTC HLO$BUTR HLO$BUTT HLO$BUTZ HLO$CALL HLO$EXPB HLO$IMPD HLO$JPRU HLO1CLST HLO20 HLO26 HLO2CLST HLO30 HLO47 HLO48 HLO49 HLO61 HLO64 HLO70 HLO71 HLO@BULD HLO@CFUP HLO@DISC HLO@POBJ HLO@RDCL HLOADDTB HLOCOMCL HLOGMSGF HLOH200E HLOH202E HLOH203E HLOH207I HLOH242E HLOH260E HLOH261E HLOH262E HLOH263E HLOH300E HLOH301E HLOH302E HLOH303E HLOH305E HLOH306E HLOH307I HLOH308E HLOH309E HLOH475E HLOH476E HLOH477E HLOH478E HLOH479E HLOH480E HLOH481E HLOH482E HLOH483E HLOH484E HLOH485E HLOH486E HLOH487E HLOH488E HLOH496E HLOH586E HLOH611E HLOH632E HLOH647E HLOH649E HLOH650E HLOH651E HLOH652E HLOH664E HLOH665E HLOH700E HLOH701E HLOH703S HLOH704E HLOH705E HLOH706E HLOH707E HLOH708E HLOH713E HLOH714E HLOH715S HLOH716E HLOH717E HLOHBAKE HLOHBAKM HLOHBLDJ HLOHCONE HLOHCRDS HLOHDBSS HLOHDDBS HLOHDPRF HLOHDUAE HLOHEDDS HLOHELDT HLOHEXTE HLOHEXTV HLOHHALE HLOHHATL HLOHIMCE HLOHLDXP HLOHPRFC HLOHPRFD HLOHPRFR HLOHPRIM HLOHRECE HLOHRETE HLOHSACC HLOHSAVE HLOHSJCI HLOHTBLM HLOHTBLS HLOHUSRS HLOHWARN HLOIN00 HLOLBAKE HLOLBLDJ HLOLCONE HLOLCRDS HLOLDBSS HLOLDPRF HLOLDUAE HLOLEDDS HLOLEXTE HLOLEXTV HLOLHALE HLOLIMCE HLOLLDXP HLOLPRFC HLOLPRFR HLOLPRIM HLOLRECE HLOLSAVE HLOLUSRS HLOMAINT HLOMSGEN HLOPIPE HLOPIPEA HLOPOSRV HLOPPARS HLOPPRNT HLOPRPG HLOPSTPR HLORBKU1 HLORDELD HLORERD HLORUSQA HLOSDB2I HLOSINIT HLOSKPRD HLOSTDB2 HLOSTMGR HLOSTSES HLOSTSRV HLOSUSQA HLOUBKU1 HLOUBKUC HLOUCBAS HLOUCE15 HLOUCOBJ HLOUCOPY HLOUDELD HLOUDISC HLOUDVSI HLOUFSPC HLOUGACG HLOUGDSN HLOUGSKM HLOUHAL1 HLOUHLTP HLOUHTMG HLOULDEF HLOUMAIN HLOUSB15 HLOUSE15 HLOUSE35 HLOUSORT HLOUSPBR HLOUSPRT HLOUSR15 HLOUSTUB HLOUTMGR HLOUUCIN HLOUUCNV HLOVS19I HLOVS22I HLOZSRB3
Fix information
Fixed component name
IDAA LOADER ZOS
Fixed component ID
5639OLA00
Applicable component levels
R210 PSY UI63085
UP19/05/24 P F905
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSKRKK","label":"IBM Db2 Analytics Accelerator Loader for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 June 2019