Db2 for z/OS

Db2 for z/OS on IBM Z

Db2 for z/OS on IBM Z

Leading enterprise data server technology powering business critical transactions and analytics

 View Only
Back to discussions
Expand all | Collapse all

After restart of DB2 getting 00E7900C when trying to execute SYSPROC.DSNUTILU

  • 1.  After restart of DB2 getting 00E7900C when trying to execute SYSPROC.DSNUTILU

    Posted Thu June 02, 2022 05:11 AM
    After restart of DB2 getting 00E7900C when trying to execute SYSPROC.DSNUTILU
    run from Java:
    CALL SYSPROC.DSNUTILU('CHECKDATA','NO','TEMPLATE TEMPL1 DSN IBMUSER.SYSUT1 UNIT SYSDA TEMPLATE TEMPL2 DSN IBMUSER.SORTOUT UNIT SYSDA TEMPLATE TEMPL3 DSN IBMUSER.SYSERR3 UNIT SYSDA CHECK DATA TABLESPACE DSN02603.SSNRCC2 SCOPE PENDING WORKDDN(TEMPL1,TEMPL2) ERRDDN TEMPL3 SORTNUM 2',1);

    SQL Error [55023]: INVOCATION OF FUNCTION OR PROCEDURE SYSPROC.DSNUTILU FAILED DUE TO REASON 00E7900C. SQLCODE=-471, SQLSTATE=55023,
    DRIVER=4.26.14

    The command worked successfully before the restart

    According to the documentation the error 00E7900C can be caused by uavailable WLM, but "/d wlm" shows that it is active:
    RESPONSE=S0W1
    IWM025I│ 04.08.28 WLM DISPLAY 565
    ────ACTIVE─WORKLOAD─MANAGEMENT─SERVICE─POLICY─NAME:─ETPBASE
    ACTIVATED: 2017/03/07 AT: 12:25:49 BY: IBMUSER FROM: S0W1
    DESCRIPTION: ETP WLM Policy w/DB2 StoredProcs
    RELATED SERVICE DEFINITION NAME: ETPwlm
    INSTALLED: 2017/03/07 AT: 12:25:35 BY: IBMUSER FROM: S0W1
    WLM VERSION LEVEL: LEVEL035
    WLM FUNCTIONALITY LEVEL: LEVEL006
    WLM CDS FORMAT LEVEL: FORMAT 3
    STRUCTURE SYSZWLM_WORKUNIT STATUS: DISCONNECTED

    ------------------------------
    Michael Litner
    ------------------------------


Related Content