PH11423: RUNSTATS PROFILE OPTIONS REPORT

Obtain the fix for this APAR.

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 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.