Home SELCOPY CBLVCAT SELCOPY/i Trial/Prices CBL SiteMap
Home   CBLVCAT Home.
Overview   Overview of CBLVCAT functionality.
Interactive   CBLVCAT Interactive included in mainframe licence at no extra cost.
Examples   Sample CBLVCAT reports.
Documentation   User Manuals, New features documents & Installation Guide.
Operating Systems   Supported operating systems, upgrades & related maintenance.
Technical Support   Technical help desk & product maintenance information.
Downloads   Product & documentation.
FAQs   Frequently Asked Questions.
Users   Sample list of customers.
 
VSAM File Tuning, ICF/VSAM Catalog Reporting, VTOC Display and Modification

CBLVCAT Examples Menu

Regular monitoring of VSAM or ICF files is essential for the smooth running of your VSAM jobs.

Selecting only the files in critical need of tuning is easy with the subset SEV=3. 

  CBLVCAT REL 2.10 AT COMPUTE (Bridgend) Ltd - Wales                           (OS) VM/CMS=VM03      13.57 FRI 26 SEP 2003    PAGE   1
o --------------------------------------------------                                --------------------------------------    -------- o

     ** VMXVMON1 CTL M ***        L=002  2003/09/26 13:34:59      *id *
o      listcat  dd=CBL111                                                                                                              o
                sev=3
                linespace=4
o                                                                                                                                      o

  USERCAT CBL111 (3380)  TYPE      NRECS   PCNT  ---- ALLOC TRACKS ----   FRSP   LMAX  KL,RKP  CISIZE BUFSP EXCPS     TIMESTMP
o ---------------------  ----      -----   ----    TOTAL   PRIME  SEC     CI CA  ---- /BLK/IMB ------ /IXL  -----     --------         o


o                                                                                                                                      o

  FILE1.IN.NEED.OF.TUNING
o                        KSDS        611   32.4      C=7     C=7    C=2   15* 7  4112V 10,0     4608* 12800*  175K 2003/06/08 18.20.17 o
                                                 VOL1=CBL111
                                       CANDIDATE VOL2=CBL475
o                          IX          4   36.4        1       1      1          3577           3584  IXL=2   126K                     o
                                                 VOL1=CBL111
                                       CANDIDATE VOL2=CBL475
o                                                                                                                                      o
     *** SEV 3-03 ***  ACTUAL FRSP CI = 0 PC 
      ** SEV 2-04 **   BUFSP TOO SMALL FOR EFFICIENCY
o     ** SEV 2-25 **   INEFFICIENT DATA CISIZE                                                                                         o
      ** SEV 2-31 **   AVLRECL: DEFINED=272     ESTIMATED=1954
       * SEV 1-15 *    4 CYLS CAN BE RECOVERED WHEN TUNED
o                                                                                                                                      o


o                                                                                                                                      o
  FILE2.IN.NEED.OF.TUNING
                         KSDS(R)    4625   57.4      C=8     C=8    C=1   20 20  4096V 21,0     4608  11264* 3470  2003/06/08 18.15.58
o                                                VOL1=CBL111                                                                           o
                                       CANDIDATE VOL2=CBL475                                                        ** 001 CI SPLITS**
                           IX          8 **88.9**      1       1      1          2041 IMB+REP   2048  IXL=2  10.5K
o                                                VOL1=CBL111                                                                           o
                                       CANDIDATE VOL2=CBL475

o    *** SEV 3-12 ***  INDEX EXCPS DWARF DATA                                                                                          o
      ** SEV 2-04 **   BUFSP TOO SMALL FOR EFFICIENCY
      ** SEV 2-31 **   AVLRECL: DEFINED=1000    ESTIMATED=525
o      * SEV 1-07 *    CI SPLITS EXIST                                                                                                 o


o                                                    ---     ---     --                                                                o
                                                     227     227     47
                                                     ---     ---     --
o      *** WARN  001 *** 12 = RETURN CODE FROM CBLVCAT                                                                                 o


o          ** ** ** ** ** ** ** CBLVCAT IS LICENSED BY COMPUTE (BRIDGEND) LTD +44 (1656) 652222 & 656466 ** ** ** ** ** ** **          o
                                                    ** EXPIRY DATE -- 12 JUN 2004 **

Notes:

Severity Messages are reported at three SEV states which are controllable through the SEV parameter. They can be excluded from the report with the NOPSEV parameter.

  • SEV 3 messages are serious and require immediate attention.
  • SEV 2 messages indicate changes to be made when the file is next loaded.
  • SEV 1 messages are minor, but require investigation.

SEV 3-03 for FILE.1.IN.NEED.OF.TUNING indicates that the file has been defined with a non-zero FRSP CI value, but the control interval is not large enough to reserve any usable free space.

SEV 3-12 for FILE.2.IN.NEED.OF.TUNING indicates that the number of index EXCPS is at least twice the number of data EXCPS.

Fixing either of the above is easy using CBLVCAT's tuning recommendations. See the Tuning example which follows.

Top © 2005 Compute (Bridgend) Limited
http://www.cbl.com/cblvex06.html
yyyy/mm/dd HH:MM:SS