Home SELCOPY CBLVCAT CBLi Trial/Prices CBL SiteMap
 
VSAM File Tuning, ICF/VSAM Catalog Reporting, VTOC Display and Modification

CBLVCAT Examples Menu

Continuing from the previous example, when problem files have been identified, acting quickly to redefine them will maximise performance.

CBLVCAT will produce all the necessary advice for redefining problem files. See the later example if you also wish to have the IDCAMS DEFINE deck generated at the same time.

The output, for the purpose of this example, is deliberately restricted to 1 file only via the KEY=FILE.1.IN.NEED.OF.TUNING parameter.

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

     ** VMXVTUN1 CTL M ***        L=002   2003/09/26 14:14:30      *id *
o      listcat  dd=CBL111                                                                                                              o
              key=FILE1.IN.NEED.OF.TUNING
              tune
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 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
                                                 VOL1=CBL111
o                                      CANDIDATE VOL2=CBL475                                                                           o
                           IX          4   36.4        1       1      1          3577           3584  IXL=2   126K
                                                 VOL1=CBL111
o                                      CANDIDATE VOL2=CBL475                                                                           o

     *** SEV 3-03 ***  ACTUAL FRSP CI = 0 PC
o     ** SEV 2-04 **   BUFSP TOO SMALL FOR EFFICIENCY                                                                                  o
      ** SEV 2-25 **   INEFFICIENT DATA CISIZE
      ** SEV 2-31 **   AVLRECL: DEFINED=272     ESTIMATED=1954
o      * SEV 1-15 *    4 CYLS CAN BE RECOVERED WHEN TUNED                                                                              o

       *** WARN  015 *** LARGE AVLRECL CHANGE
o                                                                                                                                      o
       *** WARN  016 *** LARGE ALLOC CHANGE

o                                                                                                                                      o
       CBL TUNED                                                                                                
       ---------                                                                                                
o      DATA  (                           -                                                                                             o
           CISZ         (14336)          - * NEW PHYREC SIZE=14336, CURRENT=4608                                
           CYLINDERS    (3,1)            - * OPTIMISED FOR DEVICE GEOMETRY                                      
o          RECORDSIZE   (1954,4112)      - * DEFINED AVLRECL=272                                                                       o
           FREESPACE    (18,6)           - * GIVES FREE REC=1/7, FREE CI=3/45                                   
           BUFFERSPACE  (32768)          ) * 32K MINIMUM FOR DIRECT PROCESSING                                  
o      INDEX (                           -                                                                                             o
           CISZ         (1024)           ) *                                                                    
                                                                                                                
o                                          * USING AVLRECL=1954   --- FILE CAPACITIES (NRECS) ---                                      o
                                           *             ------ TUNED ------           --- ORIG (ESTD) ---      
                                           *             PCNT   PRIME    SEC           PCNT   PRIME    SEC      
o                                          *             ----   -----    ---           ----   -----    ---                             o
                                           *  INIT LOAD   73      756    252            36      875    250      
                                           *       FREE   18      189     63            42     1015    290      
o                                          *              --      ---    ---            --     ----    ---                             o
                                           *              91      945    315            78     1890    540      
                                           *              --      ---    ---            --     ----    ---      
o                                                                                                                                      o
                              OPTIONAL JCL OVERRIDE FOR SEQ I/O                                                 
                              ---------------------------------                                                 
o                             BUFND=5      * (70K)  FAST                                                                               o
                              BUFND=8      * (112K) URGENT                                                      
                              BUFND=25     * (350K) **TURBO**  (BUT WILL IMPACT OTHER WORK)                     
o                                                                                                                                      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 **                                                   o

Notes:

The TUNING RECOMMENDATIONS shown indicate the following:-

  • Data Control Interval Size: Increase from 4.5K to 14K bytes.
  • Space Allocation: Modify (7 2) to (3 1) cylinders.
  • Average Record Size: Increase from 272 to 1954 bytes.
  • Freespace: Increase from (15 7) to (18 6) CI & CA percentages.
  • Buffer Space: Changes from 12K to 32K bytes.
  • Index Control Interval Size: Reduce from 3.5K to 1K bytes.

The FILE CAPACITY details illustrate the benefits that will be realised by redefining the file with the CBL TUNED recommendations. These can be excluded from the report with the NOPCAP parameter.

The JCL OVERRIDES are shown for improved sequential processing. These can be excluded from the report with the NOPJCL parameter.

A tuned IDCAMS DEFINE deck could also be produced. See Modelling For Migration example later in brochure.

Top © 2005 Compute (Bridgend) Limited
http://www.cbl.com/cblvex07.html
2006-09-13 14:50