IBM Support

PM73630: PROVIDE SEGMENT LENGTH DISTRIBUTION REPORT AND DB RECORD LENGTH DISTRIBUTION REPORT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • This APAR will provide a Segment Length Distribution Report
    and a DB record Length Distribution Report via the Fast Path
    Advanced tool ( FPA ).
    We'll be providing the new reports and new command parameters
    to go with these current commands:
    FPA ANALYZE  RELOAD/CHANGE/REORG with PTRCHKLVL=FULL
    FPO One step OPC
    FPO OER with One step OPC
    
    The enhancement is being implemented as a result of FITS
    requirement MR0425125719.
    

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 provides Segment Length       *
    *                      Distribution Report and new keyword     *
    *                      SEGLDIST.                               *
    *                                                              *
    *                      New report is generated by              *
    *                       - FPA ANALYZE, CHANGE, RELOAD, REORG   *
    *                         with SEGLDIST=YES keyword.           *
    *                       - FPO ANALYZE and REORG with           *
    *                         SEGLDIST=YES keyword.                *
    ****************************************************************
    * RECOMMENDATION: Apply the maintenance for this APAR.         *
    ****************************************************************
    The APAR is made for Segment Length Distribution Report.
    
    New report is generated by
      - FPA ANALYZE with the REPORT subcommand and the
        PTRCHKLVL=FULL keyword.
      - FPA CHANGE with the REPORT subcommand and the
        PTRCHKLVL=FULL keyword.
      - FPA RELOAD with the REPORT subcommand and the
        PTRCHKLVL=FULL keyword.
      - FPA REORG with the REPORT subcommand and the
        PTRCHKLVL=FULL keyword.
      - FPO ANALYZE with the REPORT subcommand and the TYPRUN=RPT,
        FULLSTEP=YES keyword.
      - FPO REORG with the REPORT subcommand and the TYPRUN=RPT,
        FULLSTEP=YES, PTRCHK=YES, and CHKUOW=ALL keyword.
    
    The following enhancement is became effective with
    SEGLDIST=YES keyword.
    
    1. Print Segment Length Distribution Report which reports
       useful segment information for database tuning.
    
    2. Provide exclamation mark next to segments at DB RECORD
       PROFILE REPORT which are described on Segment Length
       Distribution Report.
    
    This enhancement is being implemented as a result of following
    FITS requirement:
    
     - MR0425125719
    

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   SEGLDIST
    
    SEGLDIST
      Use the SEGLDIST keyword to specify whether to generate
      the Segment Length Distribution Report.
    
      SEGLDIST is an optional keyword for the following command:
          REPORT
    
    Related keyword: NONE
    
     Format:
    
     +---------------------------------------------------------+
     |                                                         |
     |  >>---SEGLDIST=(YES|NO)---><                            |
     |                                                         |
     +---------------------------------------------------------+
    
     parameter
          parameter can be one of the following values:
    
          YES Print Segment Length Distribution Report.
              SEGLDIST=YES is effective only PTRCHKLVL=FULL is
              specified.
    
          NO  Do not print Segment Length Distribution Report.
    
     Default: SEGLDIST=NO
     Site default support: Yes
    
    2.12.14    DEDB AREA ANALYSIS REPORTS
    2.12.14.2  DB RECORD PROFILE ANALYSIS
    
    The following description is added:
    
     Provide exclamation mark next to SEGNAME when SEGLDIST=YES
     with following conditions:
    
      1. Segment is defined as variable length and its occurrence
         is NOT zero.
      2. Segment is compressed and its occurrence is NOT zero.
    
    2.12.xx    Segment Length Distribution Report
    
    The optional report for segment analysis provides detailed
    information about each segments.
    
    The Segment Length Distribution Report can be used to:
    
      - List detailed information about each segments
      - Identify which segment requires tuning
    
    This report is generated by the following commands:
    
     - FPA ANALYZE with the REPORT subcommand and the PTRCHKLVL=FULL
     - FPA CHANGE with the REPORT subcommand and the PTRCHKLVL=FULL
     - FPA RELOAD with the REPORT subcommand and the PTRCHKLVL=FULL
     - FPA REORG with the REPORT subcommand and the PTRCHKLVL=FULL
    
    For the sample of Segment Length Distribution Report, see
    http://www-01.ibm.com/support/docview.wss?uid=swg27023880.
    
    4.7.3      FPO keywords
    4.7.3.x    SEGLDIST
    
    SEGLDIST
      Use the SEGLDIST keyword to specify whether to generate
      the Segment Length Distribution Report.
    
      SEGLDIST is an optional keyword for the following command:
    
          REPORT
    
    Related keyword: NONE
    
     Format:
    
     +---------------------------------------------------------+
     |                                                         |
     |  >>---SEGLDIST=(YES|NO)---><                            |
     |                                                         |
     +---------------------------------------------------------+
    
      parameter
          parameter can be one of the following values:
    
        YES   Print Segment Length Distribution Report.
              You can specify just Y rather than YES.
    
              Y is effective only when TYPRUN=RPT and FULLSTEP=YES
              are specified.
              For OER, PTRCHK=YES and CHKUOW=ALL are also required.
    
    
        NO    Do not print Segment Length Distribution Report.
              You can specify just N rather than NO.
    
     Default: SEGLDIST=NO
     Site default support: Yes
    

APAR Information

  • APAR number

    PM73630

  • Reported component name

    IMS FP SOLUTION

  • Reported component ID

    5655W1400

  • Reported release

    120

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2012-09-25

  • Closed date

    2013-05-20

  • Last modified date

    2013-06-04

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

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

    UK94440

Modules/Macros

  • FPXATO00 FPXAURT0 FPXUCKE0 FPXUCPR0 FPXXRGE0
    HAHQ120J HFPA5EA0 HFPA5IN0 HFPA5PF0 HFPA5P30 HFPA5SR0 HFPA5SS0
    HFPA5T10 HFPA5W00 HFPA5000 HFPCCDT0 HFPCDEF0 HFPLRST0 HFPQA5I0
    HFPQA500 HFPUMVT0 HFPUROB0
    

Fix information

  • Fixed component name

    IMS FP SOLUTION

  • Fixed component ID

    5655W1400

Applicable component levels

  • R120 PSY UK94440

       UP13/05/23 P F305

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:
04 June 2013