PM71744: NEW FUNCTION APAR: NEW COMMAND FOR EXTERNALIZING PENDING REAL-TIME STATISTICS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2 10 for z/OS offers no generic solution to trigger the
  externalization of pending real-time statistics into
  the catalog tables SYSIBM.SYSTABLESPACESTATS and
  SYSIBM.SYSINDEXSPACESTATS on demand.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 10 for z/OS offers no generic       *
  *                      solution to trigger the externalization *
  *                      of pending real-time statistics into    *
  *                      the catalog tables                      *
  *                      SYSIBM.SYSTABLESPACESTATS and           *
  *                      SYSIBM.SYSINDEXSPACESTATS on demand.    *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF.                                   *
  ****************************************************************
  For applications that rely on real-time statistics (RTS)
  the asynchronous externalization process of RTS might be too
  imprecise. For these kind of applications a callable interface
  that can trigger the externalization of pending RTS changes
  is needed.
  

Problem conclusion

Temporary fix

Comments

• This APAR adds a new MODE option to the ACCESS DATABASE
  command. The new option "STATS" can be used to externalize
  pending real-time statistics.
  
  New Syntax:
  
                         .-,-------------.
                         V               |
  >>-ACCESS--DATABASE(-+---database-name-+-----+-)--------------->
                       +-*---------------------+
                       +-dbname1:dbname2-------+
                       +-dbname*---------------+
                       +-*dbname---------------+
                       +-*dbname*--------------+
                       '-*dbstring1*dbstring2*-'
  
  
                    .-,----------.
                    V            |
  >--SPACENAM--(--+---space-name-+--------------+--)------------->
                  +-*---------------------------+
                  +-spacename1:spacename2-------+
                  +-spacename*------------------+
                  +-*spacename------------------+
                  +-*spacename*-----------------+
                  '-*spacestring1*spacestring2*-'
  
  >--+---------------------------------------+------------------->
     |          .-,---------------------.    |
     |          V                       |    |
     '-PART--(----+-integer-----------+-+--)-'
                  '-integer1:integer2-'
  
  >--MODE--(--+-OPEN----+--)------------------------------------><
              +-NGBPDEP-+
              '-STATS---'
  
  
  New option description:
  
  MODE( mode-value )
  
    STATS:
    Externalizes the in-memory real-time statistics to the
    appropriate catalog tables. In data sharing environments,
    the in-memory statistics are externalized for all members.
    This mode does not physically open the page sets or change
    the states of the page sets.
  

APAR Information

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

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

  UK92609

Modules/Macros

• DSNILSTS DSNTDDIS DSNTDSTP DSN9SCNA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK92609

     UP13/04/02 P F304

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.