CBL - CBLVCAT Example 14 - Multiple Displays, Subset & Sort

Home

CBL

SiteMap

Compute (Bridgend) Ltd

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

Often, different information is required from the same VTOC or catalog. Rather than generate one report containing everything you want, creating two separate reports in the single run is much easier to read.

The example below is for a VTOC, but it should be noted that these subset parameters can also be used for ICF and VSAM catalogs.

  CBLVCAT REL 2.10 AT COMPUTE (Bridgend) Ltd - Wales                           (OS) VM/CMS=VM03      09.50 FRI 01 AUG 2003    PAGE   1
o --------------------------------------------------                                --------------------------------------    -------- o

     ** VMXTMDSS CTL M ***        L=001   2003/08/01 09:50:15      *id *
o      listvtoc vol=CBLT01                                                                                                             o
              sort=size                    * Sort largest first.
              loblk=620000    hiblk=670000 * Block delimiters.
o                                                                                                                                      o

  VTOC OF CBLT01                  CISIZE   START  ALLOC   USED  TYPE   EXPIRES BLKSIZE LRECL  RECFM    CREATED   INFO
o --------------                  ------   -----  -----   ----  ----   ------- ------- -----  -----    -------   ----                  o

  DBASE.WORK.DATA                    512  634758  12725                 *EXPD*                       2003/03/10  NOT LAST VOL
o V.TSTDATA                         4096  669704   4672               PERMANENT                      2003/03/21                        o
  ACCOUNTS-DATA                     2560  664104   4000               PERMANENT                      2003/03/21
  ADDRESS MAST SORTED               3584  657640   4000                 *EXPD*                       2003/03/21
o WORK MASTER                       8192  661800   2304               PERMANENT                      2003/01/15                        o
  DOC ASM                           4608  668104   1600               PERMANENT                      2003/03/03
  EDIT.WORK.DATA                    6144  647488    688                 *EXPD*                       2003/03/24
o TEST2.WORK.DATA                    512  657384    255                 *EXPD*                       2003/03/12  NOT LAST VOL          o
  MASTER SORT TABLE                 4608  661640    160               PERMANENT                      2002/11/27

o                                                 -----                                                                                o
                                                  30404
                                                  -----
o                                                                                                                                      o
  ------------------------------------------------------------------------------------------------------------------------------------

o      listvtoc vol=CBLT01                                                                                                             o
              sort=dsn                     * Sort by Data Set Name.
                ign=/test                  * Ignore DSNs containing 'TEST'.
o               ign=/tst                   * Ignore DSNs containing 'TST'.                                                             o
             lodate=2003/01                * Minimum create date 2003/01/01.

o                                                                                                                                      o
  VTOC OF CBLT01                  CISIZE   START  ALLOC   USED  TYPE   EXPIRES BLKSIZE LRECL  RECFM    CREATED   INFO
  --------------                  ------   -----  -----   ----  ----   ------- ------- -----  -----    -------   ----
o                                                                                                                                      o
  ACCOUNTS-DATA                     2560  664104   4000               PERMANENT                      2003/03/21
  ADDRESS MAST SORTED               3584  657640   4000                 *EXPD*                       2003/03/21
o DBASE.WORK.DATA                    512  634758  12725                 *EXPD*                       2003/03/10  NOT LAST VOL          o
  DISTRIBUTION LIST                 8192  683336    512               PERMANENT                      2003/02/20
  DOC ASM                           4608  668104   1600               PERMANENT                      2003/03/03
o EDIT.WORK.DATA                    6144  647488    688                 *EXPD*                       2003/03/24                        o
  MEANS.CATALOG                        0  558000   4000              2028/03/20                      2003/02/16
  RRR.SORTS                         2560  680136   3200               PERMANENT                      2003/03/04
o WORK MASTER                       8192  661800   2304               PERMANENT                      2003/01/15                        o
  Z9999992.VSAMDSPC.T9A1BDD9.T8014540
                                     512  332568 224688         VSAM  PERMANENT
o Z9999994.VSAMDSPC.T9A1BDD6.T8976140                                                                                                  o
                                     512  331824    744         VSAM  PERMANENT

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

Notes:

An example showing multiple standard VTOC listing in one run, using different sets of criteria for selection and sorting.

Report 1:	The LOBLK/HIBLK parameters allow selection based on the FBA address, but it should be noted that similar parameters exist for CKD disks. The SORT=SIZE parameter causes a sort in ascending allocation order.
Report 2:	The LODATE=2003/01 parameter selects files created on or after 2003/01. Other date subsets also exist. The IGN=/TEST and IGN=/TST causes all DSN's containing TEST or TST to be ignored. The SORT=DSN parameter causes a sort in alphabetical DSN order.

The same file (e.g. ACCOUNTS-DATA) may appear of course in both reports.

Producing two reports in one run is more efficient as the VTOC is only read once.

Top

http://www.cbl.com/cblvex14.html

2006-09-13 14:50