A fix is available
APAR status
Closed as new function.
Error description
Infrastructure and architectural enhancements to provide parallel processing for IBM DB2 Analytics Accelerator Loader. This APAR also addresses the following issues: 1. The parser will now issue message HLOP9948E and terminate the utility if a NULLIF clause is detected in the field specification. 2. Jobs may hang after an ABEND or after being cancelled. Once in this state a FORCE is needed to terminate the job. 3. Issue error message HLOP9953E and fail the utility if the DISCARDDN keyword or SYSDISC DD are detected in an external load. 4. Issue an error message and fail the utility when field specifications are not coded on the LOAD statement. 5. Records were mistakenly discarded when loading a range partitioned table with multiple into clauses in non-ascending order. 6. Records where incorrectly discarded if a when clause with only a starting position was used. 7. HLO470E on panel HLOLLDXP on Sort work unit device even when a valid device type is used. 8. Abend 0C4 in the Accelerated Loader started task. Message HLOS0909S Started task subtask ESTAE entered System RC=0C4.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM DB2 Analytics Accelerator Loader for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Infrastructure and architectural * * enhancements to provide parallel * * processing for IBM DB2 Analytics * * Accelerator Loader. This APAR also * * addresses the following issues: * * 1. The parser will now issue message * * HLOP9948E and terminate the utility if * * a NULLIF clause is detected in the * * field specification. * * 2. Jobs may hang after an ABEND or * * after being cancelled. Once in this * * state a FORCE is needed to terminate * * the job. * * 3. Issue error message HLOP9953E and * * fail the utility if the DISCARDDN * * keyword or SYSDISC DD are detected in * * an external load. * * 4. Issue an error message and fail * * the utility when field specifications * * are not coded on the LOAD statement. * * 5. Records were mistakenly discarded * * when loading a range partitioned table * * with multiple into clauses in * * non-ascending order. * * 6. Records where incorrectly discarded * * if a when clause with only a starting * * position was used. * * 7. HLO470E on panel HLOLLDXP on Sort * * work unit device even when a valid * * device type is used. * * 8. Abend 0C4 in the Accelerated Loader * * started task. Message HLOS0909S * * Started task subtask ESTAE entered * * System RC=0C4. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PI11753
Reported component name
IDAA LOADER ZOS
Reported component ID
5639OLA00
Reported release
110
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-02-13
Closed date
2014-04-07
Last modified date
2014-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
HHLO110J HLO$$PRM HLO$ADMS HLO$BMSD HLO$BUTX HLO$DLOG HLO$DSET HLO$EDTI HLO$EDTT HLO$EQRY HLO$EXPD HLO$FCOL HLO$IMPD HLO$JOBD HLO$JPRD HLO$JPRJ HLO$OPRD HLO$OPRE HLO$OPRI HLO$OPRT HLO$OPRU HLO$OPVL HLO$OXLT HLO$PITS HLO$RCFS HLO$TSKO HLO$TSKS HLO$TSSD HLO$URCF HLO$VIEW HLO$VIE2 HLO#AMIN HLO#ASYS HLO#BPRI HLO#CARD HLO#CHKR HLO#CNTL HLO#CPNT HLO#CPOL HLO#DSPL HLO#ENQS HLO#FCPY HLO#ICAL HLO#LDEP HLO#LGAA HLO#LGAC HLO#LGAF HLO#LGAI HLO#LGAP HLO#LOGR HLO#LRDR HLO#LRD6 HLO#MAIN HLO#MLOG HLO#OBEX HLO#OBRP HLO#PRNG HLO#RANG HLO#RPRP HLO#RUNT HLO#SCPY HLO#SUBD HLO#SUBX HLO#SYSC HLO#UTOB HLO#WRIT HLO#XMLS HLO@POBJ HLOBLNKT HLOCOMCL HLODTDOP HLOEDIT HLOGDYNA HLOGIPCV HLOHECLO HLOHEXLO HLOHVCLO HLOH617E HLOH618E HLOH619E HLOH620E HLOLECLO HLOLEXLO HLOLFIX HLOLHID HLOLORD HLOLSIZ HLOLSRT HLOLVCLO HLOLVXLO HLOMSGEN HLONBLKT HLOPBALC HLOPCHCK HLOPCOPY HLOPDITB HLOPDOBJ HLOPEXEC HLOPFSPC HLOPINIX HLOPIPE HLOPLIST HLOPLOAD HLOPMSGI HLOPOPTS HLOPOSRV HLOPQUIS HLOPREBU HLOPRECO HLOPREOR HLOPRPG HLOPRUNS HLOPSTMT HLOPTMPL HLOPUNLD HLOPUTLM HLOPUTLU HLOPUTLX HLOPXMLU HLOREBD HLOREEXP HLORERD HLORUSQA HLORUSQL HLOSINIT HLOSPRMP HLOSPRMV HLOSTCJ HLOSTDB2 HLOSTSRV HLOSUSQA HLOSUSQL HLOUFSPC HLOUGDSN HLOULDEF HLOUMAIN HLOUMEPL HLOUSE15 HLOUSE35 HLOUSORT HLOUSR15 HLOUSTUB HLOUTMGR HLOVS19I HLOVS22I HLOXDB2C HLOZSCHD HLOZSRB3 HLO01 HLO2ADMF HLO2BASE HLO2BLDJ HLO2BTAB HLO2CARD HLO2DB2 HLO2DSSP HLO2ECLO HLO2ELDT HLO2ETCL HLO2ETDD HLO2EXCP HLO2EXLO HLO2GLOB HLO2GVAR HLO2MAIN HLO2NPRO HLO2ORDS HLO2PRDM HLO2PRFD HLO2PRFL HLO2PRFR HLO2PRFX HLO2PRIM HLO2PROF HLO2RESL HLO2SIDS HLO2SKL HLO2SPRF HLO2STTC HLO2SUBS HLO2TABL HLO2TBLS HLO2TEMP HLO2TIME HLO2UDSN HLO4ASYS HLO4RDLL HLO4VPRF HLO4VRPT HLO61 HLO62
Fix information
Fixed component name
IDAA LOADER ZOS
Fixed component ID
5639OLA00
Applicable component levels
R110 PSY UI16792
UP14/04/15 P F404
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":"1.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021