A fix is available
APAR status
Closed as program error.
Error description
Accelerator Loader changes to address the following issues: 1. Changes to mitigate various hang scenarios when ACCEL_LOAD_TABLES fails 2. External Load job on a IDAA 5.1 with Stored procedure level 21 fails with HLOU5720I AQT10301I HLOU5720I AQT10301I An error occurred in the SYSPROC.DSNUTILU service of your database management system (DBMS). HLOU5720I The return code is 8. The reason code is . Additional diagnostic information: ' HLOG8008I 342 16:41:46.92 HLOU5720I System=RS25 ,Job=VB1ATCB1,Job Id=S0744110,Step=VB1ATCB1,Program=DSNX9WLM,User=DB2USER HLOG8010I 3. When there is a long list of tables to be loaded on a HALOAD job the Started task may report the following error HLOS0306E 260 10:25:24.72 TCB: 008C5968 SQL Error occurred. Module:HLOSUSQA+00006FAA HLOS0202E 260 10:25:24.72 TCB: 008C5968 DSNT408I SQLCODE = -433, ERROR: VALUE <Lob-Value> IS TOO LONG HLOS0202E 260 10:25:24.72 TCB: 008C5968 DSNT418I SQLSTATE = 22001 SQLSTATE RETURN CODE HLOS0202E 260 10:25:24.72 TCB: 008C5968 DSNT415I SQLERRP = DSNOTCAS SQL PROCEDURE DETECTING ERROR HLOS0202E 260 10:25:24.72 TCB: 008C5968 DSNT416I SQLERRD = 10 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION 4. When HLOU4012E, HLOU5022E messages are written to the batch job output a corresponding HLOU4119E, HLOU5065E messages are generated and written to SYSLOG. Sample HLOU4119E, HLOU5065E messages written to SYSLOG, FFFF000 RS28 2021056 12:37:03.93 J0400371 00000090 HLOU4119E Job: HLOHALP1 Task: 03, HLPPIPE API error. Entry=4 S Function=02 RC=0A N FFFF000 RS28 2021056 12:40:00.55 J0400371 00000090 HLOU5065E Job HLOHALP1 terminated unexpectedly. SYS=0000, USR=000C 5. When HALOAD is run under DSNUTILU and any table names are greater than 35 chars the job may fail with SQLCODE is -430, SQLSTATE is 38503 DB2 error from procedure call: DSNT408I SQLCODE = -430, ERROR: PROCEDURE SYSPROC.DSNUTILU (SPECIFIC NAME DB2ADMN.HLOUTILU) HAS ABNORMALLY TERMINATED DSNT418I SQLSTATE = 38503 SQLSTATE RETURN CODE
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Users * **************************************************************** * PROBLEM DESCRIPTION: 1. Changes to mitigate various hang * * scenarios when ACCEL_LOAD_TABLES fails * * 2. External Load job on a IDAA 5.1 * * accelerator with Stored procedure * * level 21 fails with HLOU5720I * * AQT10301I * * 3. HALOAD job with a long list of * * tables can issue error in the Started * * task and report SQLCODE=-433 * **************************************************************** 1. Changes to mitigate various hang scenarios when ACCEL_LOAD_TABLES fails 2. External Load job on a IDAA 5.1 accelerator with Stored procedure level 21 fails with HLOU5720I AQT10301I 3. When there is a long list of tables to be loaded on a HALOAD job the Started task may report SQLCODE=-433
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH33276
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-01-12
Closed date
2021-03-02
Last modified date
2021-04-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI73783
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$ACCS HLO$ACES HLO$ADM2 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 HLODSNVT HLODSNXT HLOEDIT HLOEQUAL HLOFTRT HLOHEXT HLOIENQS HLOLGRD HLOLVALT HLOMMGR HLOMSGEN HLONAMET HLONBLKT HLONNUMT HLOPARET HLOPERIT HLOPIPE HLOPIPEA HLOPOSRV HLOPRPG HLORBIND HLOREBD HLOREEXP HLORERD HLORPART HLORUSQA HLOS99 HLOSINIT HLOSUSQA HLOUCBAS HLOUCE15 HLOUCLBK HLOUHAL1 HLOUHLTP HLOUMAIN HLOUNTOK 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 UI73783
UP21/03/05 P F103 ¢
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 2021