A fix is available
APAR status
Closed as new function.
Error description
New Function for RUNSTATS PROFILE options report
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS RUNSTATS TABLESPACE * * and inline STATISTICS with LOAD or * * REORG TABLESPACE utility statistics * * PROFILE users. * **************************************************************** * PROBLEM DESCRIPTION: * * New function added in this APAR * * To display the USE PROFILE options * * used during the utility execution * * in the job output. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** When RUNSTATS TABLESPACE TABLE USE PROFILE is executed, the options used in the execution are not displayed. The same is true during load or REORG TABLESPACE with inline STATISTICS and USE PROFILE. To view the keywords specified in the profile, the user will have to execute OPTIONS PREVIEW to look at the options involved. When OPTION PREVIEW is executed, the options are shown in the utility output but the utility is not executed for statistics collection.
Problem conclusion
Temporary fix
Comments
The code was modified to display the USE PROFILE options in the utility job output and collect the statistics for the keywords specified in the profile. MSGDSNU1376I will be used to output the profile options in the job output. The user response of DSNU1376I was changed for this APAR. The text of the message DSNU1376I is as follows : DSNU1376I PROFILE_TEXT IN SYSTABLES_PROFILES ROW FOR TABLE creator.table IS profile-value Explanation This informational message lists the statistics profile that the utility is to use for the specified table. creator.table The qualified name of the table to which the profile applies. profile-value The profile that the utility retrieved from the PROFILE_TEXT column of the SYSTABLES_PROFILES catalog table. System action Processing continues. User response If you ran the OPTIONS utility with the PREVIEW option, examine the job output to determine if you need to change the profile. To correct a profile: 1. Execute RUNSTATS with DELETE PROFILE to delete the profile 2. Execute RUNSTATS with SET PROFILE and specify the corrected options to set the profile. |f you did not run the OPTIONS utility, no action is |necessary. Severity 0 (informational) The explanation of MSGDSNU1382I was modified for this APAR. The changed text for DSNU1382I is as follows. DSNU1382I THE STATS PROFILE FOR TABLE table-name DOES NOT EXIST. DEFAULT PROFILE STATS COLLECTED. Explanation |The utility was run with the USE PROFILE option, but no |profile exists for the indicated table. The utility is to |use the default statistics profile: COLUMN ALL INDEX ALL. table-name The name of the table. System action Processing continues. User response If no additional statistics are required, no action is necessary. If more statistics are needed, create a statistics profile for the table that is indicated by table-name, and run utility with the USE PROFILE option again. Severity 4 (warning)
APAR Information
APAR number
PH11423
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-04-24
Closed date
2019-06-26
Last modified date
2019-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI63894
Modules/Macros
DSNUGPRA DSNUGPRF
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI63894
UP19/07/12 P F907
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:
01 August 2019