PH24054: VARIOUS FIXES

APAR status

• Closed as program error.

Error description

• The following issues are resolved with this APAR:
  1. Loader job with a RESUME NO may be parsed incorrect by loader
  and
  the job would fail with the following message,
  DSNU005I 086 15:42:40.84 DSNUGPRS - LOAD DATA INDDN HLOREC LOG
  YES NO
  SHRLEVEL NONE INTO TABLE
  NUMRECS 7 FORMAT INTERNAL
  DSNU049I 086 15:42:40.84 DSNUGPRS - INVALID OPERAND 'NO' FOR
  KEYWORD
  'LOAD'
  
  2. Updates to comment section on SHLOSAMP(HLOMAINT)
  3. Updates to SHLOSAMP members HLOV21, HLOV21C
  4. Add '//SYSUDUMP DD SYSOUT=*' to the TCz generated common
  storage
  clean up job that runs 'PGM=HLOCOMCL'.
  5. External Load job ABEND with S0C9 REASON CODE=00000009 on
  NAME=UNKNOWN when run with DISCARD DD and SYSREC DD DUMMY
  
  6. Loader job ends with S222 when DB2SORT is used and when
  loader sets
  SORT FIELDS = COPY. The loader job fails with the following
  message,
  HLOU5018I 043 09:25:45.86 SORT execution completed. SYS=0000,
  USR=0010
  HLOU5019E 043 09:25:45.86 SORT ended abnormally. DSNUTILB will
  be
  canceled with an S222 abend.
  
  DB2 SORT FOR Z/OS V2.1.0.0N PRODUCT ID: 5655-AA9 z/OS 2.4.0
  DATE=2020/043 TIME=09.25.41
  COPYRIGHT IBM CORP. 2010, 2014 ALL RIGHTS RESERVED COPYRIGHT
  SYNCSORT
  INCORPORATED 2001, 2014 ALL RIGHTS RESERVED
  PARMLIST :
  SORT FIELDS=COPY
  RECORD TYPE=V,LENGTH=32756
  OPTION MSGDDN=HLOSORT,SORTDD=HLOS
  CNK555I OPTMODE=BALANCE
  CNK164I 6,276K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX
  REQUESTED,
  CNK164I 0 BYTES RESERVE REQUESTED, 128K BYTES USED
  CNK526E DB2 SORT FOR Z/OS INTERNAL ABEND - 27
  
  To resolve this issue, HLO APAR PH24054 and Db2 SORT APAR
  PH23857 will
  have to be applied.
  
  7. When a dump is taken with the modify command on the HLO
  Started
  Task, the dump TILE was not showing the correct product tile.
  This is
  now updated to shows TITLE=DB2 ANALYTICS ACCELERATOR LOADER
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Loader Job with RESUME NO may fail   *
  *                      with DSNU049I message                   *
  *                      2. Updates to SAMPLIB Members           *
  *                      HLOMAINT, HLOV21, HLOV21C               *
  *                      3. External Load job ABEND with S0C9    *
  *                      RC=9 on NAME=UNKNOWN when run with      *
  *                      DISCARD DD and SYSREC DD DUMMY          *
  *                      4. Loader job ends with S222 when       *
  *                      DB2SORT is used and when loader sets    *
  *                      SORT FIELDS = COPY. HLO APAR PH24054    *
  *                      and Db2 SORT APAR PH23857 fixes this    *
  *                      issue                                   *
  *                      5. When a dump is taken with the        *
  *                      modify command on the HLO Started       *
  *                      Task, the dump TILE updated to show     *
  *                      TITLE=DB2 ANALYTICS ACCELERATOR LOADER  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  1. Loader Job with RESUME NO may fail
  with DSNU049I message
  2. Updates to SAMPLIB Members
  HLOMAINT, HLOV21, HLOV21C
  3. External Load job ABEND with S0C9
  RC=9 on NAME=UNKNOWN when run with
  DISCARD DD and SYSREC DD DUMMY
  4. Loader job ends with S222 when
  DB2SORT is used and when loader sets
  SORT FIELDS = COPY. HLO APAR PH24054
  and Db2 SORT APAR PH23857 fixes this
  issue
  5. When a dump is taken with the
  modify command on the HLO Started
  Task, the dump TILE updated to show
  TITLE=DB2 ANALYTICS ACCELERATOR LOADER
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI70112

Modules/Macros

• HLO2DB2  HLOENPT  HLOMAINT 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 HLOPSTRG HLOPTMPL HLOPUNLD
  HLOPUTLM HLOPUTLU HLOPUTLX HLOSINIT HLOSMPJ  HLOSTCMD HLOUHAL1
  HLOUMAIN HLOV21   HLOV21C
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels