IBM Support

PM65854: DEDB AREA ANALYSIS REPORT AND UOW REPORT ENHANCEMENTS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • This enhancement is being implemented as a result of FITS
    requirement MR0424124143, MR0424125642, MR0424126131, and
    MR0424126436.
     - Add DSNAME, DDNAME, DSTYPE, and IC TIMESTAMP(if any) at the
       Header of DEDB AREA ANALYSIS REPORTS and UOW REPORT.
     - Show SDEP information(if any) and Total occurrences at
       SEGMENT PLACEMENT ANALYSIS of DEDB AREA ANALYSIS REPORTS.
     - Show SDEP LB/LE information(if any) at FREE SPACE ANALYSIS
       of DEDB AREA ANALYSIS REPORTS.
     - Provide new format for DB RECORD PROFILE ANALYSIS of DEDB
       AREA ANALYSIS REPORTS which displays prefix length and data
       flags.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of HPFPU Fast Path Advanced Tools  *
    *                 and Fast Path Online Tools in Fast Path      *
    *                 Solution Pack Version 1 Release 2            *
    *                 (FMID: HAHQ120).                             *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR enhances the following        *
    *                      reports to provide valuable data:       *
    *                                                              *
    *                       - UOW reports                          *
    *                       - DEDB Area Analysis Reports           *
    *                                                              *
    *                      These reports are generated by          *
    *                                                              *
    *                       - FPA ANALYZE, CHANGE, and RELOAD with *
    *                         REPORT subcommand.                   *
    *                       - FPO ANALYZE and REORG with REPORT    *
    *                         with REPORT subcommand.              *
    ****************************************************************
    * RECOMMENDATION: Apply the maintenance for this APAR.         *
    ****************************************************************
    The APAR is made for the enhancements for UOW REPORT and DEDB
    AREA ANALYSIS REPORTS.
    
    These reports are generated by
     - FPA ANALYZE, CHANGE, and RELOAD with
       REPORT subcommand.
     - FPO ANALYZE and REORG with REPORT
       with REPORT subcommand.
    
    The following changes are made at default:
    
    1. Provides DSNAME, DDNAME, DSTYPE at UOW REPORT and DEDB AREA
       ANALYSIS REPORTS headers.
    2. Provides SDEP Segment information and occurrence totals at
       SEGMENT PLACEMENT ANALSIS on DEDB AREA ANALYSIS REPORTS.
    3. Provides SDEP LB/LE information at FREESPACE ANALYSIS on DEDB
       AREA ANALYSIS REPORTS.
    
    and the following change is became effective with
    SEGLSTAT=DETAILED keyword.
    
    1. Provides new formatted DB RECORD PROFILE ANALYSIS on DEDB
       AREA ANALYSIS REPORTS.
       New DB RECORD PROFILE ANALYSIS reports extra data, prefix
       length and data flag(s), which are useful information for DB
       tuning.
    
    This enhancement is being implemented as a result of following
    FITS requirements:
    
     - MR0424124143
     - MR0424125642
     - MR0424126131
     - MR0424126436
    

Problem conclusion

Temporary fix

Comments

  • ========================
    = DOCUMENTATION CHANGE =
    ========================
    The IMS Fast Path Solution Pack for z/OS Version 1 Release 2
    IMS High Performance Fast Path Utilities User's Guide
    (SC19-3287-00).
    
    2.11.3     FPA subcommands
    2.11.3.x   SEGLSTAT
    
    SEGLSTAT
      The keyword determines the format of DB RECORD PROFILE
      ANALYSIS on DEDB AREA ANALYSIS REPORTS.
    
      SEGLSTAT is an optional keyword for the following command:
    
       - REPORT
    
    Related keyword: NONE
     Format:
    
     +---------------------------------------------------------+
     |                                                         |
     |  >>---SEGLSTAT=(COMPACT|DETAILED)---><                  |
     |                                                         |
     +---------------------------------------------------------+
    
     parameter
        parameter can be one of the following values:
    
        COMPACT  Provide the same formatted report which is similar
                 to FPB DEDBPC REPORT.
    
        DETAILED Provides DB RECORD PROFILE ANALYSIS with prefix
                 length and data flag(s), which are useful
                 information for DB tuning.
    
     Default: COMPACT
     Site default support: Yes
    
    2.12.14    DEDB AREA ANALYSIS REPORTS
    2.12.14.1  FREESPACE ANALYSIS REPORT
    
    Description of %FREESPACE SDEP is modified as follows:
    
     Shows the total amount of usable, unused space, LB/LE
     information in the SDEP part at the time of run.  Data for
     this calculation is obtained from the DMAC.
    
    2.12.14.2  DB RECORD PROFILE ANALYSIS
    
    The following description is added:
    
     New formatted DB Record Profile Analysis report is generated
     with prefix length and data flag(s), which are useful
     information for DB tuning.
    
     Note: Prefix length is not included in Actual Data length
    
    
    The following description is added below the figure 154:
    
    DEFINED LENGTH
      Shows the prefix length, maximum and minimum segment lengths,
      and data flag that are defined in the DBD.
    
      Data flag of the segment as follows:
    
    - F is the fixed-length segment.
    - V is the variable-length segment.
    - C is the compressed segment.
    
    Note: ACBGEN ignores the minimum length that is specified in the
          DBD and substitutes key length plus key offset with a
          minimum value of four.
    
    2.12.14.4  SEGMENT PLACEMENT ANALYSIS REPORT
    
     Note is added as follows:
    
     NOTE: SDEP is displayed only if SDEP is defined.
           N/A is displayed when SDEPCHKLVL=NONE (FPA) or
           SDEP=NO (FPO)
    
    4.7.3      FPO keywords
    4.7.3.x    SEGLSTAT
    
    SEGLSTAT
      The keyword determines the format of DB RECORD PROFILE
      ANALYSIS on DEDB AREA ANALYSIS REPORTS.
    
      SEGLSTAT is an optional keyword for the following command:
    
       - REPORT
    
    Related keyword: NONE
     Format:
    
     +---------------------------------------------------------+
     |                                                         |
     |  >>---SEGLSTAT=(COMPACT|DETAILED)---><                  |
     |                                                         |
     +---------------------------------------------------------+
    
     parameter
        parameter can be one of the following values:
    
        COMPACT  Provide the same formatted report which is similar
                 to FPB DEDBPC REPORT.
    
        DETAILED Provides DB RECORD PROFILE ANALYSIS with prefix
                 length and data flag(s), which are useful
                 information for DB tuning.
    
     Default: COMPACT
     Site default support: Yes
    
    6.1.5.1  FPA Analyze JCL examples for monitoring and tuning
             DEDBs.
    
    Another examples at Example6 is added followed by the 1st
    example.
    
     The following figure shows example JCL for generating the
     reports that contain SDEP record information and prefix
     length, data flags to facilitate the diagnosis of the DB.
    
     In this example:
    
        * SDEPCHKLVL=FULL for ANALYZE command specifies that
          SEGMENT PLACEMENT ANALYSIS with SDEP information is
          generated.
        * SEGLSTAT=DETAILED keyword specifies that the DB RECORD
          PROFILE ANALYSIS with prefix length and data flags is
          generated.
    
      //HFP      EXEC PGM=HFPMAIN0
      //STEPLIB  DD DISP=SHR,DSN=HPFP.SHFPLMD0
      //         DD DISP=SHR,DSN=IMSVS.SDFSRESL
      //         DD DISP=SHR,DSN=IMSVS.PGMLIB
      //IMSACB   DD DISP=SHR,DSN=IMSVS.ACBLIB
      //IMSDALIB DD DISP=SHR,DSN=IMSVS.MDALIB
      GLOBAL
        DBRC=YES
      ANALYZE
        DBD=DEDBJN23,
        IAREA=ALL,
        SDEPCHKLVL=FULL,
        PTRCHKLVL=FULL
      REPORT
        SEGLSTAT=DETAILED
    

APAR Information

  • APAR number

    PM65854

  • Reported component name

    IMS FP SOLUTION

  • Reported component ID

    5655W1400

  • Reported release

    120

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-05-30

  • Closed date

    2012-07-08

  • Last modified date

    2012-08-08

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

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

    UK80131

Modules/Macros

  • FPXATA00 FPXATO00 FPXAURT0 FPXUCKE0 FPXUCPR0
    FPXXRGE0 HFPAMHS2 HFPASNF0 HFPA5AI0 HFPA5CC0 HFPA5DG0 HFPA5EA0
    HFPA5EJ0 HFPA5FB0 HFPA5FD0 HFPA5FI0 HFPA5GR0 HFPA5GU0 HFPA5HI0
    HFPA5H20 HFPA5IN0 HFPA5LR0 HFPA5PF0 HFPA5PR0 HFPA5P30 HFPA5RP0
    HFPA5SD0 HFPA5SI0 HFPA5SP0 HFPA5SY0 HFPA5TH0 HFPA5T10 HFPA5T20
    HFPA5T30 HFPA5UW0 HFPA5W00 HFPA5XT0 HFPA5000 HFPCCDT0 HFPCDEF0
    HFPFSNC0 HFPLRST0 HFPOA500 HFPQA1I0 HFPQA5E0 HFPQA5I0 HFPQA500
    HFPQFAN0 HFPQFSN0 HFPQMAI0 HFPUROB0 HFPUWLD0
    

Publications Referenced
SC19328700    

Fix information

  • Fixed component name

    IMS FP SOLUTION

  • Fixed component ID

    5655W1400

Applicable component levels

  • R120 PSY UK80131

       UP12/07/10 P F207

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.2.0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCV35A","label":"IMS Fast Path Solution Pack"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.2.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
08 August 2012