IBM Support

PH24321: INVALIDATECACHE FIELD FOR RUNSTATS SHOULD BE ALLOWED FOR DB2 V12FL 100 OR HIGHER

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After migration to Db2 v12 Automation Tool generated RUNSTATS
    ended with
    \********************************\* TOP OF DATA
    \**********************************************\*
    DSNU000I 085 21:01:24.36 DSNUGUTC - OUTPUT START FOR UTILITY,
    UTILID = X27JRUN2.RUNSLOB
    DSNU1044I 085 21:01:24.36 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
    DSNU005I 085 21:01:24.36 DSNUGPTC - LISTDEF RUNT1002
    DSNU005I 085 21:01:24.36 DSNUGPTC - INCLUDE TABLESPACE
    BPM85BDB.WLP1322
    DSNU005I 085 21:01:24.36 DSNUGPTC - INCLUDE TABLESPACE
    BPM85BDB.WLP2114
    DSNU005I 085 21:01:24.36 DSNUGPTC - INCLUDE TABLESPACE
    BPM85FDB.WLP1322
    DSNU005I 085 21:01:24.36 DSNUGPTC - INCLUDE TABLESPACE
    BPM85FDB.WLP2114
    DSNU005I 085 21:01:24.36 DSNUGPTC - INCLUDE TABLESPACE
    WPP8JCR.S003U000
    DSNU005I 085 21:01:24.36 DSNUGPTC - INCLUDE TABLESPACE
    WPP8JCR.S003Z000
    DSNU005I 085 21:01:24.36 DSNUGPTC - INCLUDE TABLESPACE
    WPP8JCR.S0040000
    DSNU005I 085 21:01:24.36 DSNUGPTC -
    DSNU005I 085 21:01:24.36 DSNUGPTC - RUNSTATS TABLESPACE
    LIST RUNT1002
    DSNU005I 085 21:01:24.36 DSNUGPTC - INVALIDATECACHE
    DSNU005I 085 21:01:24.36 DSNUGPTC - INDEX (ALL)
    DSNU049I 085 21:01:24.36 DSNUGPTC - INVALID OPERAND
    'INDEX' FOR KEYWORD 'INVALIDATECACHE'
    DSNU005I 085 21:01:24.36 DSNUGPTC - SHRLEVEL CHANGE
    DSNU005I 085 21:01:24.36 DSNUGPTC - REPORT NO
    DSNU005I 085 21:01:24.36 DSNUGPTC - UPDATE ALL
    DSNU005I 085 21:01:24.36 DSNUGPTC -
    DSNU012I 085 21:01:24.36 DSNUGBAC - UTILITY EXECUTION
    TERMINATED, HIGHEST RETURN CODE=8
    \*******************************\* BOTTOM OF DATA
    \********************************************\*
    regardless of the input value (Y/N) for invalidate cache
    on HAA$URST panel.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Users.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: InvalidateCache field for RUNSTATS      *
    *                      should be allowed for Db2 FL100 or      *
    *                      higher                                  *
    ****************************************************************
    .
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH24321

  • Reported component name

    DB2 AUTOMATION

  • Reported component ID

    5697G6300

  • Reported release

    430

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-04-10

  • Closed date

    2020-05-11

  • Last modified date

    2020-06-01

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

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

Modules/Macros

  • HAA#BND  HAA#BPRI HAA#HIST HAA#OBEX HAA#UPRI HAA#UTED HAA$BMSG
    HAA$BULD HAA$BUTR HAA$BUTX HAA$EXCP HAA$JBRK HAA$JOPT HAA$JPRU
    HAA$OPRU HAA$ORSD HAA$OUTL HAA$UOPT HAA$URST HAADISPT HAALISTC
    HAARUNSC HAASMPE  HAASMPJ  HAASMPO  HAASMPU
    

Fix information

  • Fixed component name

    DB2 AUTOMATION

  • Fixed component ID

    5697G6300

Applicable component levels

  • R430 PSY UI69419

       UP20/05/14 P F005

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 June 2020