IBM Support

PQ90042: CPU TIME REDUCTION IN IPR UNLOAD UTILITY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • CPU TIME REDUCTION IN IPR UNLOAD UTILITY
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of IMS Parallel Reorganization     *
    *                 for z/OS Version 2 Release 1 (FMID=H25N210)  *
    *                 who are to run IPR Driver or IPR Unload      *
    *                 utility                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: CPU time reduction in IPR Driver and    *
    *                      IPR Unload utility                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR improves CPU time in IPR Driver and IPR Unload
    utility by the following modifications:
    
    1. IPR Driver is modified as to put the unloaded records
    to IPRPIPE by locate mode.
    
    2. IPR Unload utility is modified as to suppress the following
    statistics reports if STATREP=NO is specified in the HPSIN
    data set:
        - Segment Statistics Report
        - Distribution of Database Record Sizes Report
        - DB Statistics Report
        - Data Set Statistics Report
        - HDAM Root Addressable Area Statistics Report
        - HDAM RAP Chain I/O Summary Report
        - HISAM Statistics Report
    
    The default of the STATREP option is YES, and the default
    can be changed by Installation Default Option Table (HPSCOPTI).
    
    If you want to reduce CPU time of IPR Unload utility,
    IBM recommends specifying STATREP=NO in the HPSIN data set or
    in your Installation Default Option Table.
    

Problem conclusion

Temporary fix

Comments

  • ========================
    = DOCUMENTATION CHANGE =
    ========================
    IMS Parallel Reorganization for z/OS Version 2 Release 1
    User's Guide (SC27-1180-03) should be modified as follows.
    
    3.0    IPR Unload Utility
    3.8    Control Statements
    3.8.3  Control Statements for Unload Function
    
    Table 9. Control Statements for Unload Function
     In the table, a new row which contains the following
    information is added to the bottom.
    |------------------------------------------------------------
    | Keyword               STATREP
    | Acceptable Values     YES or NO
    | Default               YES
    | Description           Specifies so that certain statistics
    |                       reports are not printed.
    |                       See "STATREP control statement"
    |                       in topic 3.8.3.9."
    | -----------------------------------------------------------
    
     The following new chapter is added.
    |3.8.3.9  STATREP Control Statement
    |
    | The STATREP statement specifies so that certain statistics
    | reports are not printed.
    |   __________________________________________________________
    |  |                                                          |
    |  |                _YES_                                     |
    |  | >>__STATREP=__|_NO__|_________________________________>< |
    |  |                                                          |
    |  |__________________________________________________________|
    |
    | NO
    |   The following reports are not printed. CPU time is reduced
    |   by suppressing them.
    |    - Segment Statistics Report
    |    - Distribution of Database Record Sizes Report
    |    - Data Set Statistics Report
    |    - HDAM Root Addressable Area Statistics Report
    |    - HISAM Statistics Report
    |
    |   Even if DBSTATS=YES is specified, the following reports
    |   are also suppressed.
    |    - HDAM RAP Chain I/O Summary Report
    |    - DB Statistics Report
    |
    |   The format of the following report will be the same as
    |   that generated in IPR Driver:
    |    - Segment Count Summary Report
    |
    | YES
    |   The statistics reports listed above are printed depending
    |   on other control statements. The default is YES.
    
    3.8.4    Control Statements for HSSR Engine
    3.8.4.13 TRACE Control Statement
        __________________________________________________________
       |                                                          |
       |            <_,________________   _,1_                    |
       | >>__TRACE=____CALL____________|_|____|________________>< |
       |             |      |_,NPF_| |   |_,n_|                   |
       |             |_CB____________|                            |
       |             |_CBX___________|                            |
       |             |_BUF___________|                            |
       |             |_BUFCB_________|                            |
       |                                                          |
       |                                                          |
       |                                                          |
       |__________________________________________________________|
    
      The TRACE statement specifies HSSR Engine's tracing facility
      options.
      :
    
    Notes:
      1. All operands are optional, but you must specify at least on
         operand.
      2. The trace of the control blocks of HSSR Engine (which is
         called for by specifying the CB, CBX, BUF, or BUFCB
         option for the TRACE control statement) is not intended
         to be reviewed by users, but might be needed by the IBM
         Support Center to analyze a problem.
    | 3. If TRACE=CALL is specified and a HALDB is processed
    |    in IPR Driver, data in the I/O area is not printed
    |    in the Trace Output report.
    
    3.10     User Exits
    3.10.2   Type-B User Exit
    3.10.2.1 Attributes of the Routine
    
     Link-Editing the Routine
        It is recommended that the exit routine is linked as
        AMODE=31, but the exit routines of AMODE=24 are also
    |   supported. When you are reorganizing a database
    |   in IPR Driver, the exit routine must be link-edited
    |   in 31-bit addressing mode (AMODE 31).
    
     Loading the Routine
        The exit routine must be in a STEPLIB or a JOBLIB library
        available to the unload jobstep, because the IPR Unload
        utility dynamically loads it.
    
    6.0      Setting Installation Default Options
    6.2      Creating an Installation Default Option Table
             (HPSCOPTI)
     Defaults for the following options can be changed by creating
     an HPSCOPTI:
      - DECODEDBD option for IPR Driver
      - DECODESXD option for IPR Driver
      - DECODEDBD option for IPR Unload
      - PARTINFO option for IPR Unload
     |- STATREP option for IPR Unload
      - APISET option for the API function of IPR Unload
      - PCBLIST option for the API function of IPR Unload
      - DECODEDBD option for IPR Reload
      - PARTINFO option for IPR Reload
    
    6.4      How to Code HPSCOPT Macro Statements
     -------- Product-sensitive programming interface -------------
     The installation default options are specified by coding a set
     of HPSCOPT macro statements. These statements are assembler
     language macro instructions and therefore are subject
     to the rules contained in the High Level Assembler Programmer's
     Guide. The general syntax of the HPSCOPT macro statement is
     as follows:
    
      >>__HPSCOPT=___START______________________________________><
                   |_END__________________________________|
                   |_DRIVER_,_|A|_,_|B|___________________|
    |              |_UNLOAD_,_|C|_,_|D|_,_|E|_,_|F|_,_|G|_|
                   |_RELOAD_,_|C|_,_|D|___________________|
    
      A: |_DECODEDBD=_(___NO____,___NO____)_______________|
                        |_YES_|   |_YES_|
      :
    | G: |_STATREP=____NO_________________________________|
    |                |_YES__|
    
     The default values for the following control statements can
     be specified:
        - DECODEDBD for IPR Driver
                   :
        - PARTINFO for IPR Unload
    |   - STATREP for IPR Unload
        - APISET for the API function of IPR Unload
        - PCBLIST for the API function of IPR Unload
        - DECODEDBD for IPR Reload
        - PARTINFO for IPR Reload
      :
     |----- End of Product-sensitive programming interface -------|
    
    
    ======================== End of Doc-Change =====================
    

APAR Information

  • APAR number

    PQ90042

  • Reported component name

    IMS PARALLEL RE

  • Reported component ID

    5655F7400

  • Reported release

    210

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2004-06-11

  • Closed date

    2004-07-09

  • Last modified date

    2004-08-04

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

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

    UQ90545

Modules/Macros

  • HPSCOPT  HPSCOPTS
    

Publications Referenced
SC27118003    

Fix information

  • Fixed component name

    IMS PARALLEL RE

  • Fixed component ID

    5655F7400

Applicable component levels

  • R210 PSY UQ90545

       UP04/07/14 P F407

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSVL5Q","label":"IMS Database Reorganization Expert for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"210","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
06 January 2023