PK51744: NO DDL CREATED FOR DSPHIST AND DSPSTATS TABLES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• During installation and configuration of the DB2 SMU product DDL
  should be generated to create tables to which extract statistics
  are written. The tables DSPHIST and DSPSTATS are not created.
  
  This is reflected by the following messages in the bind
  DSNX100I  -DB29 BIND SQL WARNING
             USING ZA00AB AUTHORITY
             PLAN=KTSPLNR
             DBRM=KTSDB2UP
             STATEMENT=375
             SMU.DSPSTATS IS NOT DEFINED
  DSNX100I  -DB29 BIND SQL WARNING
             USING ZA00AB AUTHORITY
             PLAN=KTSPLNR
             DBRM=KTSDB2UP
             STATEMENT=408
             SMU.DSPHIST IS NOT DEFINED
  

Local fix

• Disregard the messages at this time.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of SMU.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Introduction of Runstats; Creation of   *
  *                      stats & hist DDL.                       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• Apply the PTF.
  

APAR Information

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

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

Modules/Macros

• KTCICBLD
  

Fix information

• Fixed component name

  DB2 STORAGE MGM

• Fixed component ID

  5655SMU00

Applicable component levels

• R110 PSY UK41213

     UP08/11/01 P F810

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.