A fix is available
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 May 2019