A fix is available
APAR status
Closed as program error.
Error description
The following issues are resolved with HALOAD: 1. ABEND S301 on a Loader job 2. ABEND S402 REASON CODE=0 on NAME=UNKNOWN Job output shows the following messages: HLOU4014E 075 03:33:04.48 An error occured on accelerator HLOU5700E 075 03:33:04.48 Error from call to HLOPIPE from HLOUMAIN Function=20 RC=10 HLOU5365E 075 03:33:04.48 Error parms: 00402000, 00000000, 00000000, 00000000. 3. ABEND S0C4 REASON CODE=00000011 on NAME=UNKNOWN 4. Both the above abend S402 or S0C4 may generate the following errors in the job output and loader started task. Job output shows the following messages: HLOU4024W 083 15:45:03.54 Disabling query acceleration for tables loaded on accelerator HLOU4016W 083 15:45:03.55 Warning processing table: HLOU5416W 083 15:45:03.55 ACCEL_SET_TABLES_ACCELERATION stored procedure failed. SQLCODE -311 in the loader started task: Messages from stored procedure ACCEL_SET_TABLES_ACCELERATION SQL Error occurred. Module:HLOSUSQA+00005908 DSNT408I SQLCODE = -311, ERROR: THE LENGTH OF INPUT HOST VARIABLE NUMBER 1 IS NEGATIVE OR GREATER THAN THE MAXIMUM DSNT418I SQLSTATE = 22501 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRIHB SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -185 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF47' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Users * **************************************************************** * PROBLEM DESCRIPTION: HALOAD job may fail with abend S301 * * or S402, -311 * **************************************************************** HALOAD job may fail with abend S301 or S402, -311
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH35978
Reported component name
IDAA LOADER ZOS
Reported component ID
5639OLA00
Reported release
210
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-04-02
Closed date
2021-05-06
Last modified date
2021-06-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
HLO#A001 HLO#ACIR HLO#ACIW HLO#ACON HLO#ACRD HLO#ACUP HLO#ADIS HLO#ADSC HLO#AEXT HLO#AFMT HLO#AFRR HLO#ALLO HLO#AMIN HLO#ASYS HLO#AUMX HLO#AUTO HLO#BIND HLO#CARD HLO#CHKR HLO#CL HLO#CL64 HLO#CL7 HLO#CL8 HLO#CLLS HLO#CMTS HLO#CNTL HLO#CPM HLO#CPNT HLO#CPOL HLO#DB2V HLO#DSAF HLO#DSPL HLO#DYNL HLO#ENCR HLO#ENQS HLO#ENVF HLO#EPRI HLO#ERSH HLO#ERSI HLO#FCPY HLO#ICAI HLO#ICAL HLO#ICCC HLO#ICCI HLO#IDCF HLO#IDSA HLO#IERR HLO#IHSA HLO#IKPL HLO#IKPN HLO#ILGP HLO#ILRA HLO#ILRS HLO#ILSA HLO#INIT HLO#IOPF HLO#IPIE HLO#IPPB HLO#IPPC HLO#IPPD HLO#IPPH HLO#IPPL HLO#IPPN HLO#IPPS HLO#IRPL HLO#ISNA HLO#JPRI HLO#LGAA HLO#LGAC HLO#LGAF HLO#LGAI HLO#LGAP HLO#LOGR HLO#LRD6 HLO#MAIN HLO#MDRV HLO#MLOG HLO#MMGR HLO#MPRI HLO#MREP HLO#MTIO HLO#OBRP HLO#OPCL HLO#OPRI HLO#OS HLO#PRF5 HLO#PRNG HLO#QSAM HLO#RANG HLO#RESM HLO#RH HLO#RH10 HLO#RM24 HLO#RPRP HLO#RUNT HLO#STAT HLO#SUBD HLO#SUBX HLO#SYSC HLO#TB HLO#TB7 HLO#TB8 HLO#TP HLO#TP10 HLO#TSS HLO#TSSA HLO#TUTL HLO#UPRI HLO#URDT HLO#UTLS HLO#UTOP HLO#VERS HLO#VSM HLO#WRIT HLO#XMLD HLO#XMLI HLO#XMLJ HLO#XMLS HLO#XMLU HLO$$PRM HLO$ACCS HLO$ACES HLO$BDSN HLO$BJBC HLO$BMSG HLO$BUTJ HLO$CALL HLO$CTCM HLO$DCVT HLO$DS HLO$DSN HLO$ETRG HLO$EXCP HLO$OPVS HLO$OPVV HLO$PRFD HLO$PRFR HLO$RCTL HLO$URDT HLO$ZPAR HLO3MEPI HLO3MEPL HLOALLZT HLOAPOST HLOBLNKT HLOBND10 HLOCAPST HLOCHART HLOCOMAT HLOCOMCL HLODOTT HLODSNXT HLODTDOP HLOEDIT HLOEQUAL HLOFTRT HLOHEXT HLOIENQS HLOLGRD HLOLVALT HLOMMGR HLOMSGEN HLONBLKT HLONNUMT HLOOPTS HLOPACEL HLOPAOBK HLOPARET HLOPCHCK HLOPCOPY HLOPDITB HLOPDOBJ HLOPERIT HLOPEXEC HLOPFSPC HLOPHALO HLOPINIX HLOPIPE HLOPIPEA HLOPLIST HLOPLOAD HLOPMSGI HLOPOPTS HLOPOSRV HLOPQUIS HLOPREBU HLOPRECO HLOPREOR HLOPRPG HLOPRUNS HLOPSTMT HLOPSTPR HLOPTMPL HLOPUNLD HLOPUTLM HLOPUTLU HLOPUTLX HLORBKU1 HLOREBD HLOREEXP HLORERD HLORPART HLORUSQA HLOS99 HLOSCSRV HLOSEST2 HLOSINIT HLOSPRMP HLOSPRMV HLOSTCJ HLOSTSES HLOSTSRV HLOSUSQA HLOUBKU1 HLOUBKUC HLOUCBAS HLOUCE15 HLOUDISC HLOUHAL1 HLOUHLTP HLOUHMON HLOUHTMG HLOUMAIN HLOUNTOK HLOUSB15 HLOUSE15 HLOUSE35 HLOUSORT HLOUSR15 HLOUTMGR HLOVS22I HLOXAS31 HLOXAS64 HLOXASMS HLOXASPR HLOXDDM HLOXEXPM HLOXPDS HLOXUTLS HLOZPEXT HLOZSCHD HLOZSRB3
Fix information
Fixed component name
IDAA LOADER ZOS
Fixed component ID
5639OLA00
Applicable component levels
R210 PSY UI75270
UP21/05/08 P F105 ¢
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:
03 June 2021