IBM Support

PH22761: VARIOUS CHANGES TO DB2 ANALYTICS ACCELERATOR LOADER 20/07/10 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The following changes are included in this APAR:
    1. Support ACCEL_LOCKMODE on IDAA_DUAL and IDAA_ONLY LOAD jobs,
    so that loader job will now utilize IDAA implementation of
    LOCKMODE behavior
    2. When loading to a target accelerator that is on IDAA 5.1
    PTF-8, the Accelerator Loader is modified to directly interface
    with ACCEL_LOAD_TABLES. Accelerator Loader LOADLIB is not
    required to be on DSNUTILU workload manager (WLM) address space,
    instead accelerator loader LOADLIB should now be included into
    the WLM that runs the SYSPROC.ACCEL_LOAD_TABLES stored
    procedure.
    3. The above change in architecture to Accelerator Loader would
    also resolve the following issues on IDAA 5.1 or 7.1
    accelerator.
    If ACCEL_LOAD_TABLES stored procedure terminates prior to the
    end of the load job, accelerator loader job may hang and
    generate a SQLCODE = -430, ERROR: PROCEDURE
    SYSPROC.ACCEL_LOAD_TABLES. With this fix the loader job will not
    hang.
    If ACCEL_LOAD_TABLES stored procedure terminates prior to the
    end of the load job, accelerator loader job on a ACCELERATOR
    ONLY TABLE may end with a RC=0 and generate SQLCODE = -430,
    ERROR: PROCEDURE SYSPROC.ACCEL_LOAD_TABLES. With this fix loader
    job would now end with a RC=8.
    When the input SYSREC data set is on a TAPE and when loader job
    tries to read this input data set and gets a 'IEC145I 413-18',
    the loader job may hang. With this fix the loader job will not
    hang, instead would end with a RC=8
    Consistent Load job may fail with,
    HLOA116I A Exiting HLOZSCHD with RC=08
    HLOA001E A Error occurred during attempt to offload to zIIP
    HLO3802E A The Loader row convertion program ended unexpectedly.
    HLO3801E A The Accelerator Loader conversion program returned an
    error.
    HLO3601E Log apply task returned an error, RC=X'00000C'
    HLO2802E 0004 The writer service returned an error, RC=X'00000C'
    4. When Accelerator Loader BASE SMPE and ALL maintenance is
    applied at the same time the APPLY may fail with GIM67301W. This
    APAR would resolve this issue
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Users                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. Support ACCEL_LOCKMODE on IDAA_DUAL  *
    *                      and IDAA_ONLY LOAD jobs                 *
    *                      2. When loading to a accelerator        *
    *                      that is on IDAA 5.1 PTF-8, the          *
    *                      Accelerator Loader is modified to       *
    *                      directly interface with                 *
    *                      ACCEL_LOAD_TABLES                       *
    *                      3. Above change in architecture         *
    *                      resolves, hang issues when              *
    *                      ACCEL_LOAD_TABLES terminate prior to    *
    *                      the end of the job                      *
    *                      4. Resolves APPLY issues when an        *
    *                      ACCEPT was not done on the BASE CODE    *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF                                *
    ****************************************************************
    1. Support ACCEL_LOCKMODE on IDAA_DUALand IDAA_ONLY LOAD jobs
    2. When loading to a accelerator that is on IDAA 5.1 PTF-8, the
    Accelerator Loader is modified to directly interface with
    ACCEL_LOAD_TABLES
    3. Above change in architecture resolves, hang issues when
    ACCEL_LOAD_TABLES terminate prior to the end of the job
    4. Resolves APPLY issues when an ACCEPT was not done on
    the BASE CODE
    

Problem conclusion

Temporary fix

Comments

  • ×**** PE20/06/26 FIX IN ERROR. SEE APAR PH26915  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PH22761

  • Reported component name

    IDAA LOADER ZOS

  • Reported component ID

    5639OLA00

  • Reported release

    210

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-27

  • Closed date

    2020-05-29

  • Last modified date

    2020-10-30

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

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

    UI69766

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#CMTU HLO#CNTL HLO#CONT
    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#MEPL HLO#MLOG HLO#MMGR HLO#MPRI HLO#MREP HLO#MTIO
    HLO#OBRP HLO#OPCL HLO#OPRI HLO#OS   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#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$ETRG HLO$EXCP HLO$OPVS
    HLO$OPVV HLO$PRFD HLO$PRFR HLO$RCTL HLO$ZPAR HLO3MEPI HLO3MEPL
    HLOALL99 HLOALLZT HLOAPOST HLOBLNKT HLOCAPST HLOCHART HLOCOMAT
    HLOCOMCL HLOCUTL  HLODB2CN HLODB2PR HLODB2SQ HLODECIM HLODLL
    HLODOTT  HLODSNVT HLODSNXT HLODTST  HLOEDIT  HLOEQUAL HLOFTRT
    HLOHEXT  HLOIALI  HLOICAPS HLOIDB2C HLOIDCAM HLOIDTPS HLOIENQS
    HLOIEXCP HLOIGIDX HLOIGRS  HLOIHFP  HLOIHLI2 HLOIICW2 HLOIIDPH
    HLOIIKS  HLOIIKSA HLOILOCK HLOIMAIN HLOIMSGS HLOIMUTX HLOINCRD
    HLOIPAGE HLOIPROT HLOIPSRW HLOIRBLT HLOIROWK HLOISMPR HLOISOR1
    HLOISOR2 HLOISOR3 HLOISOR5 HLOISORT HLOISTDB HLOISYSP HLOITHRD
    HLOIUCB  HLOIUTLB HLOIVSAD HLOIVSAM HLOIVSAS HLOIXCON HLOIXDEC
    HLOIXIND HLOIXMAT HLOIXMLR HLOIXNOD HLOIXREC HLOLGAPS HLOLGPR
    HLOLGRD  HLOLVALT HLOMMGR  HLOMSGEN HLOMSGPC HLONAMET HLONBLKT
    HLONNUMT HLOOBJST HLOPACEL HLOPAOBK HLOPARET HLOPCHCK HLOPCOPY
    HLOPDITB HLOPDOBJ HLOPERIT HLOPEXEC HLOPEXPR HLOPFILE HLOPFSPC
    HLOPGPR  HLOPHALO HLOPIPE  HLOPIPEA HLOPIPEG HLOPLINE HLOPLIST
    HLOPLOAD HLOPMSG  HLOPMSGI HLOPOPTS HLOPOSGS HLOPOSRV HLOPPARS
    

Fix information

  • Fixed component name

    IDAA LOADER ZOS

  • Fixed component ID

    5639OLA00

Applicable component levels

  • R210 PSY UI69766

       UP20/06/04 P F006

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0"}]

Document Information

Modified date:
12 February 2021