RC/Query : REORG Line Command and primary quantity space default

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

When using the REORG line command(IBM Utility setting) on a tablespace or index, space calculations seem to default to (4,20).

 

Environment

Release: R20
Component: RCQ

Resolution

The space calculation used in the hlq.CDBAMDL member MJUTLRO is based on the RUNSTATS value in NACTIVEF for tablespaces and NLEAF for indexes. If this value is -1 in SYSIBM.SYSTABLESPACE or SYSIBM.SYSINDEXES in either of the above mentioned columns for those objects, then RC/Query for DB2 for Z/OS takes a PRIQTY default value of 4, this indicates that no runstats have been run.

The datasets that this applies to are in red below:

//job card
//*
//* RO       hlq.CDBAMDL(MJUTLRO*) authid1
//UTIL0001  EXEC PGM=DSNUTILB,REGION=4096K,PARM='ssid'
//STEPLIB  DD DISP=SHR,DSN=ssid.PRIVATE.SDSNEXIT
//         DD DISP=SHR,DSN=DB2.hlq.SDSNLOAD
//SYSPRINT DD SYSOUT=*
//UTPRINT  DD SYSOUT=*
//SYSUT1   DD UNIT=SYSDA,DISP=(,DELETE),
//            SPACE=(CYL,(4,20))
//SORTOUT  DD UNIT=SYSDA,DISP=(,DELETE),
//            SPACE=(CYL,(4,20))
//SYSDISC  DD DISP=SHR,DSN=NULLFILE
//SYSPUNCH DD DISP=SHR,DSN=NULLFILE
//SYSIN    DD *

Note: the RC/Query profile parameter UTILITIES ==> N (Y/N) is set to N. This is a IBM REORG not a Rapid Reorg for Db2 for Z/OS.  These two utilities utilize different hlq.MODEL JCL.

         ----------------- RC/QUERY Profile Variables ----------------
COMMAND ===>


PRINT PARAMETERS:     (For Printing Query Report being viewed)
  PRINT SQL PAGE      ==> N   (Y/N; SQL Page N/A if Printline Size < 41)

PROCESSING OPTIONS:   (For Query Reports)
  VIEW LEVELS         ==> ALL          - For Object Dependency Report.
  QUALIFIERS          ==> Y    (Y/N)   - For Obj. Dep. and some Ver. 2.1 cols.
  MAX LINES           ==> ALL          - For List and Detail reports.
  FULL DETAIL         ==> Y    (Y/N)   - For reports based on multiple tables.
  OMIT ORDER BY       ==> N    (Y/N)   - For List and Detail reports.
  UTILITIES           ==> N    (Y/N)   - To use our Utilities.
  SAVED REPORTS       ==> Y    (Y/N)   - To use customized reports.
  MATCHCASE           ==> ON   (ON,    - Enables matchcase.
                                OFF,   - Disables matchcase. ( SQL Intensive )
                                CAPS)  - Force object names to upper case.
  CAPNATS             ==> N    (Y/N)   - Capitalize National Characters.
  ALL LOCATIONS       ==> Y    (Y/N)   - For searches in Plan/Package Report.
  UNDERSCORE WILDCARD ==> ON   (ON/OFF)- To process underscore as wildcard.
  OPTIONS NOTIFY      ==> ON   (ON/OFF)- For options and notify pop-ups.
  PREFILL COMMAND     ==> Y    (Y/N)   - Prefill command line for utility.
  ISOLATION LEVEL     ==> UR   (Blank  - Global Level ISOLATION value.
                                CS,    - Cursor Stability.
                                UR,    - Uncommitted Read)
  UTILITY OBJECT      ==> 1            - Number of objects per step in
  COUNT IN 1 STEP                        utility processing JCL.