IBM Support

PH45836: RETRY LOGIC FOR STOPABN STATUS IN DSNUTILU AND ACCEL_LOAD_TABLES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • On a HALOAD or IDAA_DUAL or IDAA_ONLY load types, restart the
    stored procedure when DSNUTILU or ACCEL_LOAD_TABLES is in
    STOPABN status.
    With this change, we can now set the following keywords on on
    the loader started task options file:
    ON_DSNUTILU_STOPABN="NONE"
    ON_ACCEL_LOAD_TABLES_STOPABN="NONE"
    With this change, we can now set the following keywords on a
    HALOAD or IDAA_DUAL or IDAA_ONLY loader job:
    ON_DSNUTILU_STOPABN NONE
    ON_ACCEL_LOAD_TABLES_STOPABN NONE
    The keyword coded in the loader job takes precedence over global
    option in the started task.
    Valid values for these options from a loader job or on the
    loader started task option file are FAIL, RESTART or NONE. The
    default value is NONE.
    RESTART - will cause accelerator loader to restart the stored
    procedure that is in a STOPABN status and then continue with the
    load.
    Accelerator Loader will try to restart the stored procedure only
    once. If the restart was not successful then the load will fail
    with an error.
    FAIL - will cause the accelerator loader not to load the table
    and end the job with an error.
    NONE - Accelerator loader will not do a stored procedure status
    check
    TCz generated Loader STC and components (Template: HLOSTCJ)
    includes the new options.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Users                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Restart the stored procedure when       *
    *                      DSNUTILU or ACCEL_LOAD_TABLES is in     *
    *                      STOPABN status                          *
    ****************************************************************
    Restart the stored procedure when
    DSNUTILU or ACCEL_LOAD_TABLES is in
    STOPABN status
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH45836

  • Reported component name

    IDAA LOADER ZOS

  • Reported component ID

    5639OLA00

  • Reported release

    210

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-04-21

  • Closed date

    2022-12-05

  • Last modified date

    2023-01-03

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

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

    UI83586

Modules/Macros

  • HLO$$PRM HLOBCOMX HLOBND10 HLODDL   HLODTDOP HLOMSGEN HLOOPTS
    HLOPACEL HLOPAOBK HLOPCHCK HLOPCOPY HLOPDITB HLOPDOBJ HLOPEXEC
    HLOPEXPR HLOPFILE HLOPFSPC HLOPHALO HLOPINIX HLOPLINE HLOPLIST
    HLOPLOAD HLOPMSG  HLOPMSGI HLOPOPTS HLOPOSGS HLOPPFLE HLOPPRSE
    HLOPPSTR HLOPQUIS HLOPREBU HLOPRECO HLOPREOR HLOPRUNS HLOPSCNV
    HLOPSTMT HLOPSTRG HLOPTMPL HLOPUNLD HLOPUTLM HLOPUTLU HLOPUTLX
    HLORBIND HLORBKU1 HLORDB2S HLORUSQA HLORUSQL HLOSDB2I HLOSDB2S
    HLOSINIT HLOSPLCY HLOSPRMP HLOSPRMV HLOSTCJ  HLOSTDB2 HLOSTSRV
    HLOSUSQA HLOSUSQL HLOUBKU1 HLOUBKUC HLOUCE15 HLOUCOPY HLOUDISC
    HLOUHAL1 HLOUMAIN HLOUSB15 HLOUSE15 HLOUSE35 HLOUSORT HLOUSR15
    HLOUTMGR
    

Fix information

  • Fixed component name

    IDAA LOADER ZOS

  • Fixed component ID

    5639OLA00

Applicable component levels

  • R210 PSY UI83586

       UP22/12/13 P F212

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":"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 January 2023