PI08979: DB SENSOR SUPPORTS DB_AVG_LEN_SYNONYM_CHAIN FOR HDAM AND PHDAM DATABASES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB Sensor is enhanced to collect and print a new sensor element
  DB_AVG_LEN_SYNONYM_CHAIN that is the average length of synonym
  chains.
  This APAR is for enabling the enhancement in the stand-alone
  DB Sensor and Integrated DB Sensor.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM IMS Database Reorganization Expert for   *
  *                 z/OS V4.1(FMID=H25N410) users who run        *
  *                 Smart Reorg utility.                         *
  *                 And, Full function Database Sensor           *
  *                 (DB Sensor) users who runs in the following  *
  *                 run modes:                                   *
  *                  -Stand-alone DB Sensor which is a component *
  *                   of IBM IMS Database Solution Pack for z/OS *
  *                   V1.2(FMID=HAHP120) or V2.1(FMID=HAHP210)   *
  *                  -DB Sensor integrated in HP Image Copy      *
  *                   which is a utility of IBM IMS High         *
  *                   Performance Image Copy for z/OS            *
  *                   V4.2(FMID=H1J0420)                         *
  *                  -DB Sensor integrated in HP Pointer Checker *
  *                   which is a utility of IBM IMS High         *
  *                   Performance Pointer Checker for z/OS V3.1  *
  *                   (FMID=HPC2310)                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB Sensor is enhanced to collect and    *
  *                      print a data element                    *
  *                      DB_AVG_LEN_SYNONYM_CHAIN that is the    *
  *                      average length of synonym chains.       *
  *                      This APAR is for enabling the           *
  *                      enhancement in the stand-alone DB       *
  *                      Sensor and Integrated DB Sensor.        *
  ****************************************************************
  * RECOMMENDATION: Apply the maintenance for this APAR.         *
  ****************************************************************
  This APAR enhances DB Sensor to support a data element
  DB_AVG_LEN_SYNONYM_CHAIN for HDAM and PHDAM databases.
  The function is available when DB Sensor runs in the following
  run modes:
  
   - Stand alone DB Sensor
   - Integrated DB Sensor runs in IMS Database
     Reorganization Expert, IMS High Performance Image Copy,
     or IMS High Performance Pointer Checker.
  
  When SENSOR_HOME is specified as yes in the control statement,
  DB_AVG_LEN_SYNONYM_CHAIN is stored in in the Sensor Data
  repository of IMS Tools Knowledge Base, and it printed in
  the Sensor Data Statistics report of DB Sensor or
  BBERPRT Diagnosis report of Smart Reorg.
  
  To use the new function in HP Pointer Checker or HP Image Copy
  with HDPC=Y option in the ICEIN data set, PI08977 is also
  required.
  

Problem conclusion

Temporary fix

Comments

• The following modules and macros have been modified.
  
  BBEARHRB,BBESAPI,BBESDIC,BBESDSN,BBEARHR0,BBEARH20,BBEARH30,
  BBEARH40,BBESCREB,BBESDBIM,BBESINT0,BBESMAIN,BBESPPRT,
  BBESSBLK,BBESSCAN,BBESSCOL,BBESSHDA,BBESSHIS,BBESSPIF,
  BBESTER0,BBESUCSI,BBESVEXT,BBESWREP,BBESWRTM,BBESWSTA
  
  ========================
  = DOCUMENTATION CHANGE =
  ========================
  Note: The Part and Chapter numbers are those of the PDF file.
  
  1.The documentation "IMS Solution Packs Database Sensor V1R2 and
  V2R1, User's Guide (SC19328300)is changed.
   The documentation is modified as follows:
   ==============================================================
   IMS Solution Packs Database Sensor V1R2 and V2R1,
   User's Guide (SC19328300)
   ==============================================================
   > Part 2. Using FF Stand-alone Database Sensor
   >> Chapter 6. FF Stand-alone DB Sensor JCL and control
      statements
   >>> GLOBAL command keywords for FF Stand-alone DB Sensor
   >>>> SENSOR_HOME=
   --------------------------------------------------------------
   This keyword specifies whether to collect the data elements
   that are related to root segment distribution. If you omit this
   keyword, SENSOR_HOME=YES is used as the default value.
   YES
   Collects the following data elements and stores them in the
   Sensor Data repository of IMS Tools KB:
    DB_NUM_ROOT_NOHOME
    DB_PCT_NUM_ROOT_NOHOME
  | DB_AVG_LEN_SYNONYM_CHAIN
  
  |Restriction:
  |If the key compression option of the Segment Edit/Compression
  |exit routine is specified for the root segment, these data
  |elements are not collected even when SENSOR_HOME=YES is
  |specified.
  
   Considerations for SENSOR_HOME and the policy evaluation
   process:
  |The data elements that are additionally collected when
  |SENSOR_HOME=YES are useful factors for determining the need
  |of database reorganization.
  
  
  |DB_NUM_ROOT_NOHOME and DB_PCT_NUM_ROOT_NOHOME show how many
   root segments are placed in the different block
   from the blocks in which their RAP (Root Anchor Points) are
   placed.
   If the number of DB_PCT_NUM_ROOT_NOHOME is large,
   extra I/O operations can occur for reading root segments.
   If the number of DB_PCT_NUM_ROOT_NOHOME is large and if you
   reorganize the database, the amount of I/O might be decreased
   because the root segments will be moved into the home blocks.
  
  |DB_AVG_LEN_SYNONYM_CHAIN shows how many root segments are
  |assigned to the same RAP by a randomizer.
  |If the number of DB_AVG_LEN_SYNONYM_CHAIN is large, extra I/O
  |operations can occur for reading root segments. To improve
  |this situation, change the randomizing parameters, such as
  |increasing RAA blocks or the number of RAPs, or changing
  |the randomizer, and then reconstruct the database.
  
   If you specify SENSOR_HOME=NO, Policy Services and
   Autonomics Director cannot evaluate these factors, and they
   might not provide adequate information about the state of the
   database and the actions that you must take. Consider
   specifying SENSOR_HOME=YES unless you have performance
   concerns.
  
  |When you specify SENSOR_HOME=YES, a randomizer is called to
  |collect data for these data elements.
  |Consequently, when SENSOR_HOME=YES is specified, the CPU time
  |and the elapsed time increase compared to when SENSOR_HOME=NO
  |is specified.
  
  
  2.The IBM IMS Database Reorganization Expert for z/OS User's
  Guide Version 4 Release 1 (SC19113703) should be changed
  as follows:
  
  
   The documentation is modified as follows:
   ==============================================================
   IBM IMS Database Reorganization Expert for z/OS User's
   Guide Version 4 Release 1 (SC19113703)
   ==============================================================
   > Part 2. Using FF Stand-alone Database Sensor
   >> Chapter 8. Smart Reorg JCL statements
   >>> Reorganization Support Service
   >>>> SENSOR_HOME control statement
   --------------------------------------------------------------
   Specifies whether DB Sensor collects data elements that are
   related to root segment distribution.
   This control statement is optional. If you do not specify this
   control statement, SENSOR_HOME=YES is used.
  
   YES
   DB Sensor collects the following data elements:
    DB_NUM_ROOT_NOHOME
    DB_PCT_NUM_ROOT_NOHOME
  | DB_AVG_LEN_SYNONYM_CHAIN
  
   Because DB Sensor calls a randomizer to collect data for these
   elements, the CPU time and the elapsed time increase compared
   to when SENSOR_HOME=NO is specified
  
   NO
   DB Sensor does not collect the data elements that are related
   to root segment distribution.
  
  |Restriction:
  |If the key compression option of the Segment Edit/Compression
  |exit routine is specified for the root segment, these data
  |elements are not collected even when SENSOR_HOME=YES is
  |specified.
  
  |The data elements that are additionally collected when
  |SENSOR_HOME=YES are useful factors for determining the need of
  |database reorganization.
  |For more information about these data elements, see the topic
  |"GLOBAL command keywords for FF Stand-alone DB Sensor" in
  |the Database Sensor User's Guide.
  
  
  3.The IBM IMS High Performance Image Copy for z/OS, V4R2,
  User's Guide Version 4 Release 2 (SC19275601) should be
  changed as follows:
  
   The documentation is modified as follows:
   ==============================================================
   IBM IMS High Performance Image Copy for z/OS, V4R2,
   User's Guide Version 4 Release 2 (SC19275601)
   ==============================================================
   > Part 3. Running IMS HP Image Copy
   >> Chapter 9. IMS HP Image Copy control statements and keywords
   >>> ICEIN control statement keywords
   >>>> SENSOR_HOME keyword
   --------------------------------------------------------------
   The SENSOR_HOME keyword specifies whether to collect the data
   elements that are related to root segment distribution and
   store them in the Sensor Data repository of IMS Tools KB.
   This keyword is effective only when processing full-function
   databases.
   The following data elements are collected when SENSOR_HOME=Y:
    DB_NUM_ROOT_NOHOME
    DB_PCT_NUM_ROOT_NOHOME
  | DB_AVG_LEN_SYNONYM_CHAIN
  
   This keyword is valid when SENSOR=Y is specified.
  
  |Restriction:
  |If the key compression option of the Segment Edit/Compression
  |exit routine is specified for the root segment, these data
  |elements are not collected even when SENSOR_HOME=YES is
  |specified.
  
  |The data elements that are additionally collected when
  |SENSOR_HOME=YES are useful factors for determining the need of
  |database reorganization.
  |For more information about these data elements, see the topic
  |"GLOBAL command keywords for FF Stand-alone DB Sensor" in
  |the Database Sensor User's Guide.
  

APAR Information

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

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

  UI14363

Modules/Macros

• BBEARHR0 BBEARH20 BBEARH30 BBEARH40 BBESCREB BBESDBIM BBESINT0
  BBESMAIN BBESPPRT BBESSBLK BBESSCAN BBESSCOL BBESSHDA BBESSHIS
  BBESSPIF BBESTER0 BBESUCSI BBESVEXT BBESWREP BBESWRTM BBESWSTA
  

Fix information

• Fixed component name

  IMS DB REORG EX

• Fixed component ID

  5655F7400

Applicable component levels

• R410 PSY UI14363

     UP14/01/28 P F401

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.