IBM Support

PH07220: NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • New function
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS RUNSTATS TABLESPACE                      *
    * utility users.                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * New Function added in this APAR                              *
    * 1. Allow TABLESAMPLE SYSTEM AUTO                             *
    * to be set as default via a new Db2                           *
    * subsystem parameter STATPGSAMP.                              *
    * 2. Add a new option keyword NONE to                          *
    * TABLESAMPLE SYSTEM.                                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    When user executes RUNSTATS TABLESPACE, page sampling
    is not done by default. Users have to provide the
    TABLESAMPLE SYSTEM keywords to collect statistics using
    the page sampling method. This will require the
    users to manually make changes in the utility job
    control statements, to add the TABLESAMPLE SYSTEM AUTO
    keywords.
    
    This new subsystem parameter, STATPGSAMP, will allow
    users to set TABLESAMPLE SYSTEM AUTO as the default,
    avoiding making changes in the utility job control
    statement.
    

Problem conclusion

  • Code has been added to introduce a new Db2 subsystem
    parameter STATPGSAMP for user to provide a default for
    page sampling in the RUNSTATS TABLESPACE utility.
    
    The page sampling collection can be controlled by a new
    subsystem parameter STATPGSAMP setting introduced in
    this APAR.
    
    When the new subsystem parameter STATPGSAMP is activated,
    the default TABLESAMPLE SYSTEM AUTO will be applied to
    UTS table spaces only and when the TABLE keyword is
    specified.
    
    If the SAMPLE keyword is specified in the utility job
    statement, the default TABLESAMPLE SYSTEM AUTO will override
    the SAMPLE keyword for UTS table spaces. The SAMPLE keyword
    is ignored.
    If the user has specified the TABLESAMPLE SYSTEM keyword in
    the utility job statement, then the TABLESAMPLE SYSTEM
    specification will override the default STATPGSAMP
    specification.
    
    The PTF for APAR PH07220 adds a new subsystem parameter
    to Db2 in DSN6SPRM:
     STATPGSAMP
    
       STATPGSAMP applies to only universal table spaces.
       STATPGSAMP has no effect on other types of table
       spaces
    
       YES
             RUNSTATS will execute TABLESAMPLE SYSTEM AUTO as
             default option if the user has not specified the
             TABLESAMPLE SYSTEM keywords:
             + If the SAMPLE (row level sampling) keyword is
               specified in the utility control statement, it is
               ignored and statistics are collected using the
               page sampling technique.
             + If the TABLESAMPLE SYSTEM (data page
               sample sampling) keyword is specified in the
               utility control statement, it is honored and
               statistics are collected using the setting
               provided.
    
       NO
              RUNSTATS will not execute TABLESAMPLE SYSTEM AUTO
              as default.
    
       SYSTEM
           Db2 determines the default sampling method.
           Currently, SYSTEM has the same meaning as NO.
           In a future function level, SYSTEM might
           change to mean YES (use TABLESAMPLE SYSTEM AUTO
           by default). Any such change will be included in
           the documentation for that function level.
           ===> This is the default setting
    
    
    The PTF for APAR PH07220 has added a new option NONE to the
    keyword TABLESAMPLE SYSTEM.
    
    
                               ,--AUTO-------------,
       >>--TABLESAMPLE SYSTEM--|--numeric-literal--|->
                               '--NONE-------------'
    
    NONE
    Specifies that RUNSTATS is not to use TABLESAMPLE SYSTEM.
    
    Users can specify this new keyword to avoid collecting
    statistics via page sampling for the few exception/individual
    JCL jobs without modifying the global subsystem parameter.
    
    If you specify TABLESAMPLE SYSTEM NONE to override STATPGSAMP,
    you can specify the SAMPLE option. Otherwise, SAMPLE is not
    allowed to be specified with TABLESAMPLE.
    
    Information about the new option in sample-spec has been added
    to documentation and will be included in IBM Knowledge Center
    (http://www.ibm.com/support/knowledgecenter/SSEPEK)
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH07220

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-01-11

  • Closed date

    2019-03-21

  • Last modified date

    2019-05-02

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

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

    UI62050

Modules/Macros

  • DSNTXAZP DSNTIVIE DSNWZIFC DSNDQWPZ DSNTIVIA DSNUGBPL DSNTIWMD
    DSNUGUTC DSNDSPRM DSNTIVMD DSNTIP6  DSNTIWIA DSNUGPPP DSNTIWIE
    DSNTIWAF DSNUSITS DSNTINST DSNTIDXA DSNTIJUZ DSNTIWIN DSNTIDXB
    DSNUGPRS DSNTIVAF DSNUGDDP DSNTINMF DSNXFNLV DSNTIVMN DSN6SPRM
    DSNTIWMN DSNUGUCA DSN@XAZP DSNTIVIN DSNTIWMS DSNTIVMS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI62050

       UP19/04/05 P F904

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.



Document information

More support for: DB2 for z/OS

Software version: 12.0

Reference #: PH07220

Modified date: 02 May 2019