** VMAN.TXT *** CBLVCAT Rel 9.7 L=001 --- 97/04/08 14:08:26 (P21) Sourced from: * f:\vman\vm970\VMAN.DOC L=137 --- 96/05/03 14:24:04 (P22) ____________________________________________ | | | C B L V C A T | | | | | | Release 9.7 | | | | | | U S E R M A N U A L | |____________________________________________| _______________________________ | | | ICF & VSAM FILE TUNING | | | | ICF & VSAM CATALOG DISPLAY | | | | VTOC DISPLAY and MODIFICATION | |_______________________________| * -- ** COPYRIGHT ** -- * Copyright in the whole and every part of this document and of the CBLVCAT system and programs is owned by Compute (Bridgend) Ltd, whose registered office is located at 22 Merthyr Mawr Road, Bridgend, Wales, UK, CF31 3NR, and who reserve the right to alter at their convenience the whole or any part of this document, or the CBLVCAT system and programs. No reproduction of the whole or any part of the CBLVCAT system and programs, or of this document, is to be made without prior written authority from Compute (Bridgend) Ltd. Disclaimer At the time of publication, this document is believed to be correct. Where the program product differs from that stated herein, Compute (Bridgend) Ltd reserve the right to revise either the program or its documentation at their discretion. CBL do not warrant that upward compatibility will be maintained for any use made of this program product to perform any operation in a manner not documented within the user manual. *** _______________________________________________________ | | | | | Contents | | | |_______________________________________________________| Line Number ------ 365 **CBL Overseas and AGENTS 389 **Product Changes 415 **Intro - Introduction 422 Manual Structure 494 General 553 The CBLVCAT Approach 595 The New User 694 MVS Execution 767 TSO Execution 853 VSE Execution 941 CMS Execution 1026 Control Card Syntax Rules 1093 Glossary of Terms 1247 **List - Guide to List Output 1305 Standard Reports 1917 Customised Reports 2552 IDCAMS DEFINE and Reorg 3012 **Tune - Guide to VSAM Tuning 3063 Tuning Considerations 3259 Tuning Output 4277 VSAM Monitoring 4363 VSAM Modelling 4555 **Sum - Summary of Syntax 4590 Quick Reference 4659 REPORT Summary 4711 OPTIONS Summary 4746 LISTVCAT Summary 4793 LISTVTOC Summary 4833 LISTLABL Summary 4844 VTOC Modification Summary 4865 Other Commands 4882 LISTVCAT Fields 5027 LISTVTOC Fields 5092 Abbreviations and Synonyms 5118 **A-Z Reference 5128 ACCESSED (nn) 5142 ALIAS 5194 ALLFILES=YES 5212 ALLOC (nn) 5227 ALLOCP (nn) 5251 ALLOCS (nn) 5324 ALLOCT (nn) 5395 ALLOCU (nn) 5422 ALLOC3 (nn) 5478 ALLOC4 (nn) 5497 ASSOC 5520 ASSOC (nn) 5534 AVLRECL=nnn/KEEP 5586 AVRL 5608 AVRL (nn) 5625 BLKSIZE (nn) 5641 BLKSIZE (nn) 5655 BUFSP (nn) 5683 BUFSP/IXL (nn) 5739 CATALOG (nn) 5758 CBLCLINE=nn (Pagedepth) 5782 CBLVCALE=nn (Alloc Err) 5805 CBLVCALW=nn (Alloc Warn) 5826 CBLVCEXT=nn (Extents) 5878 CBLVCFN=xxx (Cat Name) 5895 CBLVCONL=X'xx' (Online Tune) 5926 CBLVCONS=xxxx (Online Tune) 5943 CBLVCONT=nnnn (Online Tune) 5959 CBLVCPCF=nn (% Full File) 5973 CBLVCPCT=nn (% Full Tracks) 6013 CBLVCPCV=nn (% Full Vol) 6027 CBLVCRCM=nn (Min RC) 6052 CBLVCSCA=nn (Splits CA) 6071 CBLVCSCI=nn (Splits CI) 6090 CBLVCSPA=n (Line Spacing) 6108 CBLVCSW1=X'xx' (Print) 6134 CBLVCSW2=X'xx' (Print) 6158 CBLVCSW3=X'xx' (General) 6183 CBLVCSW4=X'xx' (General) 6206 CBLVCSW5=X'xx' (LV SORT) 6227 CBLVCSW6=X'xx' (General) 6259 CBLVCSW7=X'xx' (DEFINE) 6282 CBLVCSW8=X'xx' (DEFINE) 6304 CI/CA 6324 CI/CA (nn) 6347 CIMAX=nnnn 6375 CIMIN=nnnn 6398 CISIZE (nn) 6427 CISIZE (nn) 6449 CISIZE=KEEP 6475 CISIZE=n1,n2 6495 CLASS=n 6508 COMPONENT (nn) 6558 CREATED (nn) 6572 CYL/HD (nn) 6587 CYLMAX=nnn 6601 DDNAME=fname 6629 DDNAME=fname 6654 DEFINE 6681 DEFINED (nn) 6700 DEFINED 6729 DEL 6751 DEV=ALL 6791 DEV=unitname 6804 DEV=cuu 6852 DEV=nnnn 6868 DSN=xxx.xxx.xx.etc 6896 DSN (nn) 6921 DSN (nn) 6972 EJECT 6993 ENTRY (nn) 7014 EXCPS 7033 EXCPS (nn) 7057 EXP=PERM 7078 EXP=TEMP 7099 EXPD 7185 EXPIRES (nn) 7225 EXTNO=nn 7238 FAIL=xxx 7262 FREE 7307 FREEBYTES (nn) 7321 FREETAB 7414 FRSP (nn) 7472 FRSPCA=nn 7497 FRSPCI=nn 7515 GDGDSN 7574 GDGRPT (GDG repeat) 7595 GGEN (nn) (GDG gen nos) 7608 GMAX (nn) (GDG max level) 7621 GROWTH=nn 7656 GVER (nn) (GDG vers no) 7669 HEAD='string' 7703 HIALLRBA (nn) 7718 HIBLK=nnnn 7787 HICISZ=nnnn 7801 HICYL=nnn 7815 HIDATE=date 7847 HIEXP=date 7875 HITRK=nnnn 7891 HIUSERBA (nn) 7905 IGN=string 7909 IGN=/string 7947 IMB (nn) 7978 INDEX 7994 INFO (nn) 8078 IXL (nn) 8094 KEY=string 8098 KEY=/string 8136 KL (nn) 8154 KL/BLK/IMB (nn) 8205 LINESPACE=n 8228 LIST=YES 8247 LISTLABL 8273 LISTVCAT 8308 LISTVTOC 8340 LMAX 8361 LMAX (nn) 8397 LOBLK=nnnn 8412 LOCISZ=nnnn 8426 LOCYL=nnn 8441 LODATE=date 8457 LOEXP=date 8473 LOTRK=nnnn 8489 LRECL (nn) 8504 MAXLRECL=nnnn 8524 MERGE 8575 MOD 8599 MOUNT 8616 NEWDSN=xxx.xx 8641 NEWOWN=xxxxxx 8667 NEWVOL=xxxxxx 8690 NOALIAS 8707 NOASSOC 8725 NODEFINE 8741 NOEXPD 8759 NOFREE 8775 NOGDGDSN 8792 NOGDGRPT 8809 NOINDEX 8830 NOMOUNT 8851 NOOVLAY 8870 NOPCAP 8888 NOPERM 8908 NOPJCL 8926 NOPSEV 8944 NOVOL 8964 NRECS (nn) 9001 NRECS=nnnn 9014 NSEC (nn) 9039 OPTIONS 9076 OVLAY 9094 OWN=xxx 9118 PAGEDEPTH=nn 9140 PAGEWIDTH 9181 PASS=passwd 9195 PCNT 9214 PCNT (nn) 9252 PERM 9268 PHYREC (nn) 9291 PRTCAP 9309 PRTJCL 9327 PRTSEV 9345 QUERY 9365 RECDEL (nn) 9384 RECFM (nn) 9411 RECINP (nn) 9430 RECINS (nn) 9450 RECORDS=nnn 9471 RECSTATS (nn) 9493 RECUPD (nn) 9513 REF=xxx.xx 9533 REF=ALL 9562 REPORT 9629 RKP (nn) 9644 S/C 9665 S/C (nn) 9683 SECALLOC=nn 9704 SEV=n 9725 SEVL (nn) 9744 SHR 9768 SHR (nn) 9785 SMS (nn) 9800 SMSD (nn) 9814 SMSM (nn) 9829 SMSS (nn) 9844 SORT=xxx 9888 SORT 9916 SORTD 9929 SPANNED 9940 SPLIT=nn 9961 SPLITCA (nn) 9978 SPLITCI (nn) 9995 SPLITS (nn) 10024 START (nn) 10039 STOPAFT=nnn 10072 SUBSET 10099 SUMMARY 10236 SUMMARY 10260 SYS=ALL 10279 SYS=nnn 10322 TIMESTMP 10363 TIMESTMP (nn) 10401 TOTALLOC=nnn 10426 TOTALS 10476 TUNE (sys) 10507 TYPE (nn) 10553 TYPE (nn) 10646 TYPE=xxx 10689 TYPE=xxx 10714 UNALLOC=nnn 10737 UNUSED 10762 USED (nn) 10785 VCAT (nn) 10807 VOL=volser 10826 VOL=volser 10848 VOL=volser/vol* 10895 VOLINFO 10947 VOL1 (nn) 10988 VOL2 (nn) 11035 VOL3 (nn) 11078 VOL4 (nn) 11126 VOL5 (nn) 11170 VOLUME (nn) 11190 VTOC (nn) 11211 VVDS=volser 11287 **CBLNAME 11314 Introduction 11371 Detailed Field Descriptions 12032 QUERY CBLNAME 12083 **MESSAGES 12109 SEV Messages (Severity) 12626 Warning Messages 12753 Error Messages 13026 Console Messages 13073 Miscellaneous Messages 13120 Return Codes 13180 **Technical Information 13230 Installation 13321 Tuning Principles 13589 Additional VSAM Information 14373 ** *** _______________________________________________________ | | | | | CBL Overseas and AGENTS | | | |_______________________________________________________| UK and Other Countries: COMPUTE (Bridgend) LTD Tel: +44 (165) 665 2222 (Head Office) 8 Merthyr Mawr Road Fax: +44 (165) 665 2227 BRIDGEND Wales CF31 3NH North America: COMPUTE (Bridgend) LTD Tel: +1 (416) 746 4447 38 Guided Court Fax: +1 (416) 746 5870 REXDALE Ontario M9V 4K6 Canada Germany: PLUS-DATA GmbH Tel: +49 (2685) 98 9013 (Agency) Lindenstrasse 11-13 Fax: +49 (2685) 98 9017 D-57630 FLAMMERSFELD Germany *** _______________________________________________________ | | | | | Product Changes | | | |_______________________________________________________| The previous CBLVCAT manual was Rel 9.6 which was last updated in February 1995. Changes and new features since then, which are now incorporated into the body of this manual, are summarised below. Note that these changes and new features may be subject to minor change, at the discretion of CBL, according to advice and feed-back from users. Please feel free to let us have your suggestions and requirements. Introduced in Rel 9.7 (Mar 96) Dynamic I/O configuration support. (MVS) LISTVTOC dynamic device assignments. (VSE) LISTVCAT using dynamic DLBL. (VSE) *** _______________________________________________________ | | | | | Intro - Introduction | | | |_______________________________________________________| Manual Structure *-***-* For the New User: Intro Introduction. - Manual Structure. - General. - The CBLVCAT Approach. - The New User. - MVS Execution. - TSO Execution. - VSE Execution. - CMS Execution. - Control Card Syntax Rules. - Glossary of Terms. List Guide to List Output. - Standard Reports. - Customised Reports. - IDCAMS DEFINE and Reorg. Tune Guide to VSAM Tuning. - Tuning Considerations. - Tuning Output. - VSAM Monitoring. - VSAM Modelling. For the Experienced User: Sum Summary of Syntax. - Quick Reference. - REPORT Summary. - OPTIONS Summary. - LISTVCAT Summary. - LISTVTOC Summary. - LISTLABL Summary. - VTOC Modification Summary. - Other Commands. - LISTVCAT Fields. - LISTVTOC Fields. - Abbreviations and Synonyms. A-B } C-E } Alphabetically ordered descriptions of all F-L } Commands and Parameters. M-R } S-Z } CBLNAME Tailoring Information for the module CBLNAME. - Introduction. - Detailed Field Description. - Query CBLNAME. Messg Descriptions of all Messages Produced. - SEV Messages (Severity). - Warning Messages. - Error Messages. - Console Messages. - Miscellaneous Messages. - Return Codes. Tech Detailed Technical Information. - Installation. - Tuning Principles. - Additional VSAM Information. General *-***-* CBLVCAT is an indispensible utility for all VSAM users. Its Catalog and VTOC reports are clear, concise and legible. These reports highlight problem files and optionally contain tuning recommendations. This insulates you from the volumes of IDCAMS LISTCAT reports and hours of research and calculations which would otherwise be required to accomplish these tasks. In other words, CBLVCAT is your VSAM expert, or your VSAM experts servant. Here is what CBLVCAT will do for you: Report ------ 1. ICF and VSAM Catalogs. You can display whole Catalogs, or just the files of interest. If the standard output does not suit, customise the report to display the required information. It is possible to report on multiple Catalogs in the same run and even produce a variety of reports of the same Catalog. Customised reports can be combined, even with VTOC reports, into a single listing and/or sorted. It is also possible, for ICF Catalogs, to report directly from a VVDS. 2. VTOCs. Display your VTOCs in a very legible report. You can choose the sequence and/or a number of other options which let you control the report contents, including report merging. 3. Label Information Area. VSE users can display their Partition, Class and Standard Labels in a concise readable report. Tune ---- CBLVCAT optionally gives tuning recommendations for problem files. Optimally tuned files result in large savings in processing power, elapsed run time, response time and disk space. It can also tune files based on different operating systems or DASD. This makes it ideal for planning and facilitating a migration. Monitor ------- Your periodic reports may be restricted to files that need attention. These reports will save your time, because you won't be dealing with mounds of paper and/or masses of irrelevant information. IDCAMS DEFINE Parameters ------------------------ You can optionally punch card images of a DELETE/DEFINE deck, with or without tuning recommendations. VTOC Modification ----------------- If you run VSE you can modify file expiry dates and rename, or delete, files. The CBLVCAT Approach *-***-* The philosophy behind the CBLVCAT approach is simplicity: Installs Easily --------------- If you are a first time user, just follow the Installation Guide for your type of system and you will be operational very quickly. Later, you can tailor the CBLNAME module to suit your environment and select default preferences for reporting. If you are already a user, or if you use another CBL product, installation is even faster. No Hooks into Your System ------------------------- CBLVCAT is risk free. It will not require you to make any system software changes and won't hinder any future software upgrades. Easy to Use ----------- The control records, used to direct CBLVCAT, are free-format. You can be as general, or specific, as you like, when selecting the files to appear on your reports. A standard report format is provided, which contains the most frequently used information. If you prefer, you can create your own report format, choosing both the fields and the order in which they are displayed. You Still Control Your Own System --------------------------------- Tuning recommendations and warning indicators are given, but no changes are made behind the scenes. Speed of Execution ------------------ CBLVCAT is written in Assembler Language and reads Catalogs directly. Its speed is astonishing, allowing reports to be produced in prime-time. Portable -------- CBLVCAT is not operating system dependent. If you decide to change, simply re-install it on the new system. The New User *-***-* Job Control Language -------------------- You do, of course, have to supply Job Control Language (JCL) statements, to both invoke CBLVCAT and to link the files, mentioned in the CBLVCAT control statements, with real physical data stored on a computer readable medium. This JCL is operating system dependent and is described later. However, the CBLVCAT control statements used in this section are all operating system independent. Reports ------- A standard report of the default Catalog can be produced by simply using the following CBLVCAT command: LISTVCAT A report of a specific Catalog is produced with the following: LISTVCAT DDNAME=mycat For a standard VTOC report of the volume with VOLID abcvol, use: LISTVTOC VOL=abcvol In both types of report any file attributes needing attention are highlighted (either with asterisks or plus signs). For VSE users, a standard report of the Label Information Area is produced as follows: LISTLABL Abbreviations ------------- Most CBLVCAT commands can be abbreviated to save time and space (See the section commencing tab SUM for a full list). e.g. LC DD=mycat * Abbreviation for LISTVCAT. LV VOL=abcvol * Abbreviation for LISTVTOC. Selective Reporting ------------------- So far, the reports produced would have contained all the files within a particular Catalog/Volume. Most of the time you will probably only be interested in a particular file, or set of files. The SUBSET parameter, together with its associated sub-parameters, designates which files appear in the report (See tab SUM for sub-parameter details). e.g. LC DD=mycat SUBSET TYPE=K * KSDS entries only. Multiple SUBSET sub-parameters are allowed. They are processed as a logical AND i.e. cumulative (KEY and IGN are exceptions, being processed as a logical OR - See their appropriate entries in the alphabetical section). The SUBSET parameter is only effective for the operation on which it is coded and the word SUBSET is optional. Tuning ------ If the TUNE parameter is specified, CBLVCAT will add its tuning recommendations to the Catalog report. CBLVCAT doesn't make the changes, it lists the IDCAMS DEFINE parameters requiring modification and comments on the changes required. e.g. LC DD=mycat TYPE=K TUNE * KSDS only with tuning recommendations. The TUNE parameter is only effective for the LISTVCAT command on which it is coded. Report Customisation -------------------- If the standard report layout and/or contents don't suit your requirements, you can customise the output. This is accomplished using the OPTIONS or REPORT commands, together with their associated parameters. Multiple parameters are allowed (See the tab SUM for parameter details). The selected OPTIONS/REPORT parameters remain in force for the rest of the run, or until reset by another OPTIONS/REPORT parameter. OPTIONS alters the content of the standard report. e.g. OPTIONS LMAX * Display LMAX instead of AVRL. LC DD=mycat This would create a report with maximum record length (LMAX) displayed in place of the average record length (AVRL). OPTIONS can also be supplied as a parameter to a LISTVCAT/LISTVTOC command (see OPTIONS in the alphabetical section). REPORT creates a totally customised report. Each parameter specifies a column to appear in the report. e.g. REPORT VCAT DSN TYPE NRECS * Define the report layout. LC DD=mycat This would produce a customised Catalog report containing entries for the parameters shown, in the order specified, i.e. Data Set Name (DSN), File TYPE (e.g. KSDS) and the number of records in that file (NRECS). The MERGE and SORT parameters may be used, in conjunction with the REPORT command, to combine multiple listing into one report and to sort the output (See tab LIST for examples of report customisation). MVS Execution *-***-* Catalog Reports --------------- Under MVS batch, CBLVCAT has two methods for producing a Catalog report (See over for TSO execution). These are as follows: 1. Reference the required Catalog using a DDNAME. e.g. //STEP1 EXEC PGM=CBLV //UCAT DD DSN=vsam.user.cat,DISP=SHR //SYSPRINT DD SYSOUT=* //SYSIN DD * LC DD=UCAT TYPE=K TUNE 2. Reference the required Catalog using the REF parameter (REFerence). The argument of this parameter can be the Catalog itself (using the self-defining entry), its alias, or any DSN in the Catalog. If REF=ALL (ICF with DFP 3.1 or higher) is used, a report is produced for all Catalogs. e.g. //STEP1 EXEC PGM=CBLV //SYSPRINT DD SYSOUT=* //SYSIN DD * LC REF=any.file.in.cat TYPE=K TUNE DEV=3390 Caution ------- Pre DFP 3.1 users should supply a STEPCAT/JOBCAT to process ICF Catalogs. Contact CBL should this prove to be inconvenient. For processing non-ICF VSAM Catalogs a STEPCAT/JOBCAT must be supplied. In addition, before running CBLVCAT for the first time on these Catalogs, it is advisable to run IDCAMS VERIFY first, otherwise, CBLVCAT may not be able to report on all files. VTOC Reports ------------ Under MVS batch, CBLVCAT has three methods for producing a VTOC report. These are as follows: 1. Reference the required Volume using a DDNAME. e.g. //STEP1 EXEC PGM=CBLV //VOL1 DD VOL=SER=volser,UNIT=3390,DISP=SHR //SYSPRINT DD SYSOUT=* //SYSIN DD * LV DD=VOL1 2. Reference the required Volume using the VOL parameter with the required Volume Serial number as the argument. The argument can also be a generic subset (For instance, VOL=ABC* will produce VTOC information for all volumes starting with ABC). e.g. //STEP1 EXEC PGM=CBLV //SYSPRINT DD SYSOUT=* //SYSIN DD * LV VOL=volser 3. Reference the required Volume using DEV=unitname, where unitname is a user-defined esoteric group of units (generic subset). If DEV=ALL is used, a report is produced for all disk devices identified within SYSALLDA. e.g. //STEP1 EXEC PGM=CBLV //SYSPRINT DD SYSOUT=* //SYSIN DD * LV DEV=3380DASD Input via the PARM Field ------------------------ For both Catalog and VTOC reports, CBLVCAT can take its input via the PARM field of the EXEC statement. e.g. VTOC report with input via the PARM field. //STEP1 EXEC PGM=CBLV,PARM='LV VOL=volser' //SYSPRINT DD SYSOUT=* TSO Execution *-***-* To simplify the production of Catalog/VTOC reports, the V TSO REXX exec is provided. It is supplied on the distribution tape and will have been made available to you as part of the installation procedure (see separate CBLVCAT installation guide). The control statements for producing Catalog and VTOC reports are described under their relevant headings and the various methods of supplying these statements to V TSO are described below under the heading "Invoking V TSO". Catalog Reports --------------- Authorisation to read a Catalog, needs to be set via an AUTHCMD entry within module IKJTSO00. Under TSO, CBLVCAT has two methods for producing a Catalog report as follows: 1. Reference the required Catalog using the DDNAME parameter (This method requires an ALLOC statement to have been issued for the required Catalog). The CBLVCAT control statement uses the ALLOC name as the argument of the DDNAME parameter. e.g. LC DD=UCAT TYPE=K TUNE 2. Reference the required Catalog using the REF parameter. The argument of this parameter can be the DSN of the Catalog itself (using the self-defining entry), its alias, or any DSN in the Catalog. If REF=ALL (ICF with DFP 3.1 or higher) is used, a report is produced for all Catalogs. e.g. LC REF=any.file.in.catalog VTOC Reports ------------ Under TSO, CBLVCAT has three methods for producing a VTOC report. These are as follows: 1. Reference the required Volume using the DDNAME parameter (This method requires an ALLOC statement to have been issued for the required Volume). The CBLVCAT control statement uses the ALLOC name as the argument of the DDNAME parameter. e.g. LV DD=VOL1 2. Reference the required Volume using the VOL parameter with the required Volume Serial number as the argument. The argument can also be a generic subset (for instance, VOL=ABC* will produce VTOC information for all volumes starting with ABC). e.g. LV VOL=volser 3. Reference the required Volume using DEV=unitname, where unitname is a user-defined esoteric group of units (generic subset). If DEV=ALL is used, a report is produced for all disk devices identified within SYSALLDA. e.g. LV DEV=3380DASD Invoking V TSO -------------- Before invoking V TSO, it is necessary to tailor it to include the name of the PDS to which you require output to be directed (The line to tailor is indicated within the exec). The methods of invoking V TSO are as follows: 1. V If the exec is invoked with no parameters, CBLVCAT takes its control records from the terminal and directs its output to the PDS member 'VLST' (The PDS name should have already been tailored in the exec). 2. V inarg The first parameter supplied to V TSO is the input location. This can either be 'TERM' (default), where control records are input from the terminal, or a PDS member which contains control records (The PDS name should have already been tailored in the exec). 3. V inarg outarg The second parameter supplied to V TSO is the output location (the input parameter must also have been supplied, or '.' entered to use the default). This can either be 'TERM', where output is directed to the terminal, or the PDS member name of your required output file (The PDS name should have already been tailored in the exec). If this parameter is omitted, output defaults to the PDS member 'VLST'. 4. V (inarg) DEST=xyz SYSOUT=x The DEST= and/or SYSOUT= parameters can be used to control the output location. They are not positional and 'DEST=' and 'SYSOUT=' must be coded with their arguments following. They cannot be used if the output argument has been specified. VSE Execution *-***-* Catalog Reports --------------- As with all VSAM processing, if a label definition (DLBL) for IJSYSCT does not exist in the System Standard Label Area, one must be supplied as a User-label. Under VSE/SP 2.1 or higher, all that is required is to point CBLVCAT to any existing Standard or User DLBL which refers to the required catalog. e.g. // EXEC CBLV LC DD=UCATWK1 * Standard label assumed. /* or // DLBL MYCAT,'any.user.catalog',,VSAM // EXEC CBLV LC DD=MYCAT /* Under earlier releases of VSE, the DLBL must contain a CAT operand with the arguement equal to the DLBL fname. e.g. // DLBL CBLCAT,'my.user.cat',,VSAM,CAT=CBLCAT // EXEC CBLV LC DD=CBLCAT /* VTOC Reports ------------ Under VSE, CBLVCAT has three methods for producing a VTOC report. These are as follows: 1. Reference the required Volume indirectly using the SYS parameter with a temporary or permanently assigned programmer logical unit number as the argument. If SYS=ALL is used, a report is produced for all currently assigned disk devices. 2. Reference the required Volume indirectly using the DEV parameter with the required device number as the argument. If DEV=ALL is used, a report is produced for all active disk devices (see description under DEV=ALL tab C-E). 3. Reference the required Volume directly using the VOL parameter with the required Volume Serial Number as the argument. The argument of the VOL parameter can also be a generic subset. For instance, VOL=ABC* will produce VTOC information for all volumes starting with ABC. e.g. // EXEC CBLV LV SYS=3 * Assignment to SYS003 required. LV DEV=141 * Volume on device 141. LV VOL=DOSRES * Volume DOSRES. /* Standard Label Reports ---------------------- Partition (temporary and permanent), Class and System labels are listed with one command. e.g. LISTLABL * No parameters needed Input via the PARM Field ------------------------ For both Catalog and VTOC reports, CBLVCAT can take its input via the parm field of the EXEC statement. e.g. Catalog report with input via the PARM field (Std label for IJSYSCT exists.) // EXEC CBLV,PARM='LC DD=IJSYSCT' Operator Console Execution -------------------------- One approach is to gain access to a partition, by releasing a PAUSE job (e.g. R RDR,PAUSEBG) into the relevant partition. A DLBL/ASSGN for the required Catalog/Volume should then be supplied and CBLVCAT invoked as follows: // EXEC CBLV CBLVCAT recognises that it has been initiated from the console and prompts you to enter control records. At this point, you reply with the required operation. e.g. LC DD=IJSYSUC When there are no more control records to enter, reply by entering a "/*", or a null reply ("end-of-block" or ENTER). PLEASE_NOTE If you are running VTOC reports from the console and the operation fails, the default CANCEL action of the FAIL parameter is changed to IGNORE (See FAIL parameter description for more information). CMS Execution *-***-* To simplify the production of Catalog/VTOC reports for your attached VSE mini-disks, the V EXEC is provided. It is supplied on the distribution tape and will have been made available to you as part of the installation procedure (see separate CBLVCAT installation guide). As with all VSAM processing, if a label definition (DLBL) for the Master Catalog (IJSYSCT) doesn't exist, one must be supplied and the disk on which it resides must be accessed. It is then necessary to supply similar information for all required disks and Catalogs. e.g. Assuming the Master Catalog is on Volume 140 and the required Catalog and VTOC are on Volume 141. CP LINK userid 140 140 RR ACC 140 M ASSGN SYSCAT M DLBL IJSYSCT M DSN vsam.master.catalog ( SYSCAT CP LINK userid 141 141 RR ACC 141 N ASSGN SYS001 N DLBL CBLCAT N DSN my.user.cat ( SYS001 DLBL CBLCAT N DSN my.user.cat ( SYS001 CAT CBLCAT As can be seen above, when the CAT operand is specified, it is mandatory that the DLBL which is referenced by the argument of that CAT operand should have been previously defined. The argument of the CAT operand must be the same as the DLBL fname. There are only two exceptions to this rule: 1. If IJSYSUC (Job Catalog) is used as the DLBL fname, the CAT operand can be omitted as its default is IJSYSUC. 2. If IJSYSCT (Master Catalog) is used as the DLBL fname and no Job Catalog exists, the CAT operand may be omitted as, in this case, its default becomes IJSYSCT. PLEASE NOTE ----------- If IJSYSCT is used as the DLBL fname and a Job Catalog (IJSYSUC) already exists, the CAT operand must be specified with the argument IJSYSCT. The control statements for producing Catalog and VTOC reports are described under their relevant headings and the various methods of supplying these statements to V EXEC are described below under the heading "Invoking V EXEC". Catalog Reports --------------- Under CMS, a CBLVCAT control record references a Catalog using the DDNAME parameter. The argument of the DDNAME parameter is the fname specified in the DLBL. e.g. Referencing the Catalog defined on the DLBL with fname CBLCAT (as defined above). LC DD=CBLCAT VTOC Reports ------------ Under CMS, CBLVCAT produces a VTOC report using the SYS parameter. The argument of the SYS parameter is the SYS number specified on the ASSGN statement. e.g. Referencing the Volume defined on the ASSGN statement as SYS001 (as defined above). LV SYS=001 Invoking V EXEC --------------- The V EXEC always runs with DOS ON, with 3 different methods of invoking it: 1. EXEC V If the user simply invokes the EXEC with no parameters, CBLVCAT control records are entered on the control line after 'VM READ' is displayed. Output is to 'V LISTING A'. Thus: EXEC V #LC DD=IJSYSCT #LV SYS=001# executes the parameters supplied between the line end characters ("#"). 2. EXEC V fn The parameters are executed from the user control file 'fn CTL *'. Output is to 'fn LISTING A'. 3. EXEC V fn ft fm The parameters are executed from the user control file 'fn ft fm'. Output is to 'fn LISTING A'. Control Card Syntax Rules *-***-* 1. If input is via the PARM field of the EXEC statament, then SYSIN/SYSIPT is ignored. 2. If input is via SYSIN/SYSIPT, columns 1 to 71 are used by CBLVCAT and may contain data or comment, column 72 must be left blank and columns 73 to 80 may contain sequence numbers, or any other data the user wishes. CBLVCAT's commands and/or parameters may contain any number of intervening blanks. 3. If input is via in-stream SYSIN/SYSIPT, users of VSE, CMS/DOS, TSO, and CMS (VM/ESA 1.2.1 or later) must code a "/* " control statement to signify end of control card statements. Users of CMS (VM/ESA 1.2 or earlier) may use a "/* " or a null line, whereas native MVS users may omit this statement altogether. If not already processed by the operating system, a "/*" in positions 1 and 2, followed by a blank, is taken as EOF by CBLVCAT, regardless of the rest of the record and regardless of the operating system. CBLVCAT's control card input file, SYSIN for OS and CMS, SYSIPT for DOS, is then closed, without attempting to read any further control cards. 4. It is sometimes irritating to have to use a whole record for a single control statement. To overcome this, a separator character may be used to split a control record into logical control records (A separator character immediately followed by "/* " indicates End of File). The default separator character is the "Exclamation Mark" (X'5A'), but this default may be modified by an entry in the CBLNAME module (See that chapter for more details). 5. A CBLVCAT operation consists of a command followed by any number of associated parameters and sub-parameters (See tab SUM for a list). LC and LV are examples of commands. DDNAME and REF are examples of parameters. LMAX and TYPE are examples of sub-parameters. A command must start on a new logical record. The parameters and sub-parameters which follow, belong to the operation started by that command. An operation is completed as soon as the next command, or end of file on SYSIN/SYSIPT, is detected. There can be more than one command per execution. Commands and parameters may be supplied in mixed case characters. CBLVCAT converts all input to upper case. 6. There is no continuation character. Commands and parameters may be specified on more than one record (The two exceptions are the LISTLABL and QUERY commands, which must be complete on one logical record), but commands, parameters and strings cannot be broken in the middle. 7. Comments are allowed. An asterisk, which is not part of a quoted literal string, signals the start of a comment. All data following the asterisk is treated as comment. An entire record may be used as a comment line by coding an asterisk as the first non-blank character, or the entire control record may be left blank. 8. Some parameters are in KEYWORD=string format. CBLVCAT treats the equal-sign as a blank, which allows the substitution of one or more blanks in its place. 9. If a string contains blanks, commas or asterisks, it must be enclosed in single quotes. If it includes a quote, the quote must be represented as two quotes. e.g. MOD DSN='FILE ID' NEWDSN='THIS IS ''A'' FILE' Glossary of Terms *-***-* ACB Application Control Block. AIX Alternate IndeX (see Additional VSAM Information). ALIAS An alternate name for a Catalog or NONVSAM file (OS systems). AMS Access Method Services. ASSOC File ASSOCiation (AIX, PATH etc). BCS Basic Catalog Structure (part of ICF Catalog). BLKSIZE The physical size of records. CA Control Area. A number of Control Intervals are grouped together to make up a Control Area. (see Additional VSAM Information). CAP Block CBLVCAT tuning capacity block. CATALOG the VSAM directory. CI Control Interval. A VSAM storage unit to contain records, similar to to a block in other access methods. It also contains control information which VSAM uses and which you do not see. (see Additional VSAM Information). CI/CA number of Control Intervals in a Control Area. CICS an IBM software program. CISIZE Control Interval SIZE. CKD Count Key Data (a type of disk architecture). CLUSTER VSAM maintains files in structures called CLUSTERS. A CLUSTER is maintained on disk in one of two ways:- For non-ICF environments the CLUSTER lives in an area of disk reserved for VSAM called a VSAM DATA SPACE. The clusters within the SPACE are under control of a USER CATALOG and a MASTER CATALOG. For ICF environments the CLUSTERS are under the control of an ICF Catalog which is composed of two parts, the BCS and the VVDS. The VVDS contains the information such as file characteristics. There is no concept of VSAM SPACE in this environment. See the relevant IBM documentation for more information. CMS Conversational Monitoring System (a component of VM). CMS/VSAM an IBM software program. CRA Catalog Recovery Area. DA Direct Access. DASD Direct Access Storage Device (a disk). DBD DataBase Descriptor. DF/EF Data Facility Extended Function (used with ICF Catalogs). DDNAME 'file label' in MVS systems. DLBL 'disk label information ' in VSE systems. DL/I Data Language/1 for VSE (c/f IMS for MVS). DOS Disk Operating System. DOS/VS Disk Operating System/Virtual Storage. DOS/VSE Disk Operating System/Virtual Storage Extended. EOF End of File. ESA Enterprise System Architecture. ESDS Entry Sequence DataSet. A VSAM FILE STRUCTURE analogous to sequential files. ESDS files can be processed sequentially from start to end, or records can be accessed directly by supplying the Relative Byte Address (RBA) of the record. EXEC a CMS filetype used to store a set of statements. EXCPS EXecute Channel Programs (I/O). FBA Fixed Block Architecture (a family of disks). FCT File Control Table (a component of CICS). FILEDEF CMS terminology for 'file label'. GDG Generation Data Group. ICF Integrated Catalog Facility (a Catalog consists of a BCS and one or more VVDS). ICFCAT VSAM Catalog on ICF. IDCAMS the IBM utility program for VSAM Catalogs. IJSYSCT the VSE DLBL for the VSAM Master Catalog. IJSYSUC the VSE DLBL for the VSAM Job Catalog. IMS Information Management System for MVS (c/f DL/I for VSE). INDEX the index extent of a VSAM/ISAM file. ISAM Index Sequential Access Method. IX IndeX component of AIX or KSDS file. IXL IndeX Levels (see Additional VSAM Information). JCL Job Control Language. JCL Block CBLVCAT tuning JCL block. JOBCAT MVS Job Catalog. KSDS Key Sequence DataSet. A VSAM file structure made up of 2 components, an INDEX component and a DATA component. Each component is a separate file. LDS Linear DataSets - consisting of a long stream of bytes and not considered to have records. MASTCAT VSAM master Catalog. MAX-CA MAXimum Control Area size (see Addn VSAM Information). MIN-CA MINimum Control Area size (see Addn VSAM Information). MVS Multiple Virtual Storage (operating system). MVS systems Generic term for OS, OS/VS, MVS, MVS/XA, MVS/ESA and OS/390. NONVSAM MVS files which do not occupy space within the Catalog. NSPND Non SPaNneD file. OS Operating System. OS/VS Operating System/Virtual Storage. OS/390 Open integrated Server Operating Sytem Environment. (The latest rel of MVS.) PAGESP MVS system PAGE SPace. PRIME the PRIME data extent of VSAM or ISAM file. RBA Relative Byte Address. RDF Record Descriptor Field. REORG a file reorganisation. REPRO an IBM utility program. RRDS Relative Record DataSet. A VSAM file structure having a "pigeon hole" or slot structure. Each slot is associated with a Relative Record Number. It can be processed sequentially, or randomly by its relative record number. SAM Sequential Access Method. SEOF Software End Of File. SEV Block CBLVCAT tuning block containing SEVerity messages. SMS System Managed Storage. STACK a CMS area used to pass data between commands and programs. STANDARD LABEL AREA an area of DASD used to store label information. STEPCAT MVS description of Catalog to be used for a step. SPANNED records which span control intervals. SPLIT action taken on a CI or CA for some record insertions (VSAM). -and- a file occupying a split cylinder (VTOC). STRNO number of strings used. SYSIN SYStem INput unit for OS/MVS and CMS. SYSIPT SYStem InPuT unit for VSE. SYSLST SYStem LiST unit for VSE. SYSPCH SYStem PunCH unit for VSE. SYSPRINT SYStem PRINT unit for MVS. SYSPUNCH SYStem PUNCH unit for MVS. TSO Time Sharing Option. TUNE Block CBLVCAT tuning block containing IDCAMS define recommendations. USERCAT VSAM USER CATalog. VERIFY IDCAMS command to reset a file's high used RBA. VSAM Virtual Storage Access Method. VSE Virtual Storage Extended. VSE systems Generic term for DOS, DOS/VS, VSE and VSE/ESA. VSE/ESA Virtual Storage Extended/ Enterprise System Architecture. VTOC Volume Table Of Contents. VVDS VSAM Volume Data Set (used with BCS). VVR VSAM Volume Record (For a VVDS). XA eXtended Architecture (MVS). *** _______________________________________________________ | | | | | List - Guide to List Output | | | |_______________________________________________________| This chapter illustrates and explains the output from CBLVCAT if the TUNE parameter is not specified (See tab Tune, for information on TUNE output). However, TUNE is mentioned in the final section of this Chapter to illustrate its use in conjunction with DEFINE. A full list of all Commands, with their associated Parameters and sub-parameters, is given in tab Sum. A detailed description of commands, parameters and sub-parameters in alphabetical order, commences at tab A-B. Contents -------- Standard Reports Introduction. Example 1 - Standard Catalog Report. Example 2 - Standard Catalog Report with OPTIONS. Example 3 - VSAM Volume Summary. Example 4 - VVDS Report. Example 5 - ICF Volume Summary. Example 6 - Standard VTOC Report. Example 7 - Standard Label Report. Customised Reports Introduction. Example 8 - Basic Customised Report. Example 9 - Selective Customised Report. Example 10 - Advanced Customised Report. Example 11 - Customised VVDS Report. Example 12 - Combined VTOC Report. Example 13 - Combined Catalog Report. Example 14 - Combined Catalog and VTOC Report. Example 15 - Combined VTOC Report for all VTOCs. Example 16 - Combined Catalog Report for all Catalogs. Example 17 - Combined Report for all Catalogs & VTOCs. Example 18 - Free Space across all VTOCs. IDCAMS DEFINE and Reorg Introduction. Supported File Types. Output File. Selection. Security Keywords. Warning Messages. IX Allocation. Installation Standards. Example 19 - DEFINE without TUNE. Example 20 - DEFINE with TUNE. Example 21 - Skeleton Reorg Jobstreams. Standard Reports *-***-* Introduction ------------ CBLVCAT has a standard report format which contains the most frequently required file information. Some columns of this report can display different fields depending upon the installation defaults and/or the run time OPTIONS chosen. OPTIONS can also be used to control the page geometry (See OPTIONS in tab M-R for full details). Example 1. Standard Catalog Report ----------------------------------- A more readable replacement for an IDCAMS LISTCAT report (for ICF or VSAM catalogs), which is produced in a fraction of the time. The important data-component information is contained on only one line. Access to additional Catalog information is achieved either via the customised REPORT feature, or by using OPTIONS to alter the standard report content. Both these methods are shown in later examples. e.g. List the Catalog identified by the DDNAME CBLV91. LC DD=CBLV91 __________________________________________________________________________________________________________________________________________ | | | CBLVCAT REL 9.70 AT COMPUTE (Bridgend) Ltd - Wales (OS) VM/CMS=VM05 11.36 THU 21 MAR 96 PAGE 1 | | o -------------------------------------------------- ------------------------------------ -------- o | | | | LISTCAT DDNAME=CBLV91 | | o o | | | | USERCAT CBLV91 (3350) TYPE NRECS PCNT ---- ALLOC TRACKS ---- FRSP LMAX KL,RKP CISIZE BUFSP EXCPS SHR TIMESTMP | | o --------------------- ---- ----- ---- TOTAL PRIME SEC CI CA ---- /BLK/IMB ------ /IXL ----- --- -------- o | | | | CBL.VSAM.CATALOG KSDS 57 35.2 12 12 3 505 44,0 512 3072 7172 3,3 93/02/07 16.25 | | o ---------------- IX 3 3.6 3 3 3 505 --IMB-- 512 IXL=2 460 3,3 o | | CBL.TEST.ABCD.CATALOG KSDS 13 27.1 2 2 0* 512 45,10 2048 6144 365 1,3 94/02/17 19.06 | | IX 1 12.5 1 1 0* 2041 2048 335 1,3 | | o CBL.TEST.ABCD.CATALOG2 KSDS 13 27.1 2 2 0* 512 45,10 2048 6144 6 1,3 94/02/23 23.57 o | | IX 1 12.5 1 1 0* 2041 2048 6 1,3 | | CBL.TEST.ABCD ESDS 7 6.3 2 2 0* 400V 2048 4096 283 1,3 94/02/17 19.05 | | o CBL.TEST.ABCD2 ESDS 7 6.3 2 2 0* 400V 2048 4096 4 1,3 94/02/23 23.42 o | | EG.OF.LOW.BUFSP.HIGH.IXLEVEL | | KSDS 401 33.5 C=2 C=1 C=1 25 20 800 4,0 4096 12288* 275 1,3 93/11/09 00.55 | | o IX 3 75.0 1 1 1 4089 +4096+ IXL=2 145 1,3 o | | FILE.CREATED.BY.JOHN RRDS 2 20.0 1 1 1 1200 3072 6144 4 1,3 93/11/08 21.29 | | NO.SEC.ALLOC.1 KSDS(R) 1 0.1 10 10 0* 17 5,10 1024 3584 10 1,3 93/11/08 21.41 | | o IX 1 9.1 1 1 0* 1529 1536 7 1,3 o | | PRIME.SPACE.TEST.FILE ESDS 1 ** ALL** 1 1 1 2000V 512 SPANNED 4 1,3 93/12/12 17.07 | | SABCDE.TEMP.TEST.FILE ESDS 25 13.4 1 1 1 300V 1024 2048 6 1,3 93/11/02 16.57 | | o SHARE.4.TEST KSDS 5 3.2 10 10 0* 1017 4,0 2048 6144 9 *4,3* 93/11/09 01.09 o | | IX 1 12.5 1 1 0* 2041 2048 5 *4,3* | | SPACE.TEST.FILE RRDS 17 **85.0** 2 1 1 1200 3072 6144 37 1,3 94/02/22 07.49 | | o STUVE.TEST.FILE ESDS 17 7.5 1 1 1 120V 512 1024 28 1,3 94/02/22 09.36 o | | STUVK.TEST.FILE KSDS(R) 5 2.1 1 1 1 100V 7,8 1024 3072 82 1,3 93/07/19 05.49 | | IX 1 6.7 1 1 1 1017 1024 32 1,3 | | o XYZ2.ENTRY.SEQ ESDS 7 0.7 20 20 0* 2038V 2048 4096 8 1,3 93/11/08 21.50 o | | XYZ4.EXAMPLE.1 ESDS 2472 76.6 16 8 8 800V 4096 8192 31 1,3 93/11/09 00.05 | | XYZ4.FILE KSDS 1 3.2 2 2 0* 1017 5,0 2048 6144 4 1,3 93/11/09 01.03 | | o IX 1 12.5 1 1 0* 2041 2048 4 1,3 o | | XYZ8.REUSABLE.EXAMPLE.FILE | | KSDS(R) 6 0.1 10 10 0* 17 5,10 1024 3584 7 1,3 93/11/09 01.33 | | o IX 1 9.1 1 1 0* 1529 1536 4 1,3 o | | XYZ9.KSDS.FILE KSDS(R) 6 0.1 10 10 0* 17 5,10 1024 3584 8 1,3 93/11/09 01.17 | | IX 1 9.1 1 1 0* 1529 1536 5 1,3 | | o o | | --- --- -- | | 177 138 52 | | o --- --- -- o | | | | | | o o | | ------ DEV CHARS ------ DATA SPACE DATA --------- TRACKS --------- | | VOLUME CRA TYPE MIN-CA MAX-CA SETS CLASS SPACES ALLOC USED PCNT FREE MAXF TIMESTMP | | o ------ --- ---- ------ ------ ---- ----- ------ ----- ---- ---- ---- ---- -------- o | | CBLV91 NO 3350 13.5-18K 405-540K 28 0 1 240 177 73.8 63 56 93/02/07 16.25 | | | | o o | | | | | | o ** ** ** ** ** ** ** CBLVCAT IS LICENSED BY COMPUTE (BRIDGEND) LTD +44 (1656) 652222 & 656466 ** ** ** ** ** ** ** o | | ** EXPIRY DATE -- 10 JUN 1997 ** | |__________________________________________________________________________________________________________________________________________| Example: Standard Catalog Report (CBL Ref: vmxvfull) Notes ----- SPANNED is a non-standard message appearing in the BUFSP/IXL column, indicating that the file is defined with the SPANNED attribute. --IMB-- in the KL,RKP/BLK/IMB column, indicates that the file was defined with the IMBED attribute. A V suffix on the LMAX value, indicates that the loaded records are of variable length. IXL=n in the BUFSP/IXL column, indicates the number of index levels. To enable easy monitoring of file condition, CBLVCAT also displays warning indications (*,+) when various, user controlled, threshold values are exceeded. This allows corrective action to be taken before serious problems occur. The warnings in this example are as follows: 1. PCNT (** ALL**) All primary space is used and file additions will cause secondary allocations. 2. PCNT (**nn.n**) The file full percentage threshold has been reached - default 85% (See CBLVCPCF in tab CBLNAME). 3. CISIZE (+nnnnn+) Excessively large index CISIZE (See tab Tech for a discussion of index CISIZE). 4. SEC (0*) No secondary allocation defined (Highlighted as the file cannot be expanded). 5. BUFSP (nnnnn*) The DEFINED Bufferspace is too small (See BUFSP in tab Sum). 6. SHR (*n,n*) The file is defined with Share-option 4 which is costly on performance. Example 2. Standard Catalog Report with OPTIONS ------------------------------------------------ OPTIONS can be used to control, among other things, the page geometry and the content of the standard report (For a full description see OPTIONS in tab M-R). It is applicable to both LISTVCAT and LISTVTOC operations, with parameters which relate specifically to the two different commands, as well as common parameters. e.g. Using OPTIONS to display non-default report fields of the Standard Report. OPTIONS UNUSED AVRL CI/CA S/C DEFINED * Non-default options. LC DD=CBLV10 __________________________________________________________________________________________________________________________________________ | | | CBLVCAT REL 9.50 AT COMPUTE (Bridgend) Ltd - Wales (OS) VM/CMS=VMPC02 10.53 TUE 19 APR 94 PAGE 1 | | o -------------------------------------------------- ------------------------------------ -------- o | | | | OPTIONS UNUSED AVRL CI/CA S/C DEFINED * Non-Default options | | o o | | LISTVCAT DD=CBLV10 | | | | o o | | USERCAT CBLV10 (3380) TYPE NRECS ----- ALLOCATED TRACKS ----- FRSP AVRL KL,RKP CISIZE BUFSP CI/CA S C DEFINED | | --------------------- ---- ----- TOTAL UNUSED PRIME SEC CI CA ---- /BLK/IMB ------ /IXL ----- --- ------- | | o o | | TEST.GRP1.USER.CATALOG KSDS 34 87 84 87 3 505 44,0 512 3072 92 3 0 93/08/10 | | ---------------------- IX 3 3 2 3 3 1 --IMB-- 1024 IXL=2 31 3 0 | | o DEFAULT.MODEL.ESDS.SAM SAM (R) 0 TEMP 1 1 4100 4100 4608 9216 9 1 0 93/08/13 o | | PRODUCT.FS.HIST.NEWMAST | | SAM (R) 28200+ C=5 C=5 C=5 80 4000 10240 20480 60 1 0 93/08/17 | | o PRODUCT.FS.CICSXX.MASTER o | | SAM (R) 570+ C=9 C=4 C=9 C=9 4092 4092 10240 20480 60 1 0 93/08/17 | | PRODUCT.FS.PARAMETER KSDS(R) 2351 12 2 3 3 158 21,0 4096 14436 30 2 0 93/07/13 | | o IX 5 1 1 1 1 512 IXL=2 46 2 0 o | | PRODUCT.FS.REPORT.TEST01 | | SAM (R) 326+ C=9 C=6 C=9 C=9 4092 4092 10240 20480 60 1 0 94/03/25 | | o PRODUCT.HIST.001.EXTRACT.CICS o | | ESDS(R) 115 5 4 5 5 60 4096 8192 50 2 0 94/04/16 | | TEST.TEMP.HISTORY.BASE SAM (R) 0 TEMP 9 9 250 5000 5120 10240 72 1 0 93/10/19 | | o o | | --- --- --- --- | | 453 246 454 370 | | o --- --- --- --- o | | | | | | o o | | ------ DEV CHARS ------ DATA SPACE DATA --------- TRACKS --------- | | VOLUME CRA TYPE MIN-CA MAX-CA SETS CLASS SPACES ALLOC USED PCNT FREE MAXF TIMESTMP | | o ------ --- ---- ------ ------ ---- ----- ------ ----- ---- ---- ---- ---- -------- o | | CBLV10 NO 3380 32-44K 480-660K 9 0 2 13259 453 3.5 12806 12800 93/08/10 | | (NOALLOC=10) | | o o | | | | | | o ** ** ** ** ** ** ** CBLVCAT IS LICENSED BY COMPUTE (BRIDGEND) LTD 0656-652222, 0656-656466 ** ** ** ** ** ** ** o | | ** EXPIRY DATE --- 6 JUN 1995 ** | |__________________________________________________________________________________________________________________________________________| Example: Catalog Report with OPTIONS (CBL Ref: vmxvopt) Notes ----- The fields in this report which are non-default, are as follows: 1. UNUSED Display the percentage of allocated space which is unused (UNUSED), instead of the percentage which is used (PCNT). 2. AVRL Display the average record length (AVRL), instead of the maximum record length (LMAX). 3. CI/CA Display control intervals per control area (CI/CA), instead of Channel Programs executed (EXCPS). 4. S/C Display Share Options and Space Class (S/C), instead of Share Options (SHR). 5. DEFINED Display the date the file was defined (DEFINED), instead of the date the file was last closed by an operation that may have changed its contents (TIMESTMP). Any, or all, of these OPTIONS may be made the installation default by setting the relevant switches in the CBLNAME module (See tab CBLNAME). For some of the files in this example, a plus sign is displayed after the number of records (NRECS - nnnnn+). This indicates that the record count has not been maintained by VSAM and the displayed value is CBLVCAT's estimate (See NRECS in tab M-R for further details). Files shown as TEMP are temporary reusable files (VSE only), which means that the file has been defined as a WORK file. These files are not allocated until they are opened for output, at which time the required space is taken from unused remaining space. The total blocks/tracks these files will occupy is reported separately at the end of the report (in this example NOALLOC=10). It is then possible to see if there is enough space left for all the files to be open at once (It is however, extremely unlikely that this would be required). Example 3. VSAM Volume Summary ------------------------------- The volume summary follows the files, as shown in the previous examples. It appears on the standard Catalog report and the standard Catalog report with OPTIONS, but is not user configurable. You can, however, report on volumes only, via the SUMMARY parameter: e.g. LC DD=CBLV05 SUMMARY __________________________________________________________________________________________________________________________________________ | | | CBLVCAT REL 9.50 AT COMPUTE (Bridgend) Ltd - Wales (OS) VM/CMS=VMPC02 10.55 TUE 19 APR 94 PAGE 1 | | o -------------------------------------------------- ------------------------------------ -------- o | | | | LISTVCAT DD=CBLV05 SUMMARY | | o o | | | | | | o USERCAT CBLV05 (3380) TYPE NRECS PCNT ---- ALLOC TRACKS ---- FRSP LMAX KL,RKP CISIZE BUFSP CI/CA SHR TIMESTMP o | | --------------------- ---- ----- ---- TOTAL PRIME SEC CI CA ---- /BLK/IMB ------ /IXL ----- --- -------- | | | | o COPY.OF.P001.UCAT KSDS 556 33.6 66 57 3*4 505 44,0 512 3072 92 3,3 94/03/06 10.48 o | | ----------------- IX 3 2.7 3 3 3 1017 --IMB-- 1024 IXL=2 31 3,3 | | | | o o | | | | ------ DEV CHARS ------ DATA SPACE DATA --------- TRACKS --------- | | o VOLUME CRA TYPE MIN-CA MAX-CA SETS CLASS SPACES ALLOC USED PCNT FREE MAXF TIMESTMP o | | ------ --- ---- ------ ------ ---- ----- ------ ----- ---- ---- ---- ---- -------- | | CBLV05 NO 3380 32-44K 480-660K 51 0 2 13245 4867 36.8 8378 4672 93/08/05 14.24 | | o CBLV15 NO 3380 32-44K 480-660K 150 0 1 13245 10560 79.8 2685 1232 93/08/05 14.46 o | | CBLV25 NO 3380 32-44K 480-660K 72 0 1 13259 11534 **87.0** 1725 1600 93/08/08 09.30 | | *** WARN 012 *** DATA SPACE GETTING/IS FULL | | o o | | --- - ----- ----- ---- ----- | | 273 4 39749 26961 67.9 12788 | | o --- - ----- ----- ---- ----- o | | | | | | o o | | *** WARN 001 *** 06 = RETURN CODE FROM CBLVCAT | | | | o o | | ** ** ** ** ** ** ** CBLVCAT IS LICENSED BY COMPUTE (BRIDGEND) LTD 0656-652222, 0656-656466 ** ** ** ** ** ** ** | | ** EXPIRY DATE --- 6 JUN 1995 ** | |__________________________________________________________________________________________________________________________________________| Example: VSAM Volume Summary (CBL Ref: vmxvsum) Notes ----- When summary is used to suppress the report detail, the self-defining Catalog entry is still reported. On the above report this self defining entry has an asterisk in the SEC column. This indicates that the number of secondary extents has reached the warning threshold value (default 1 - see CBLVCEXT in tab CBLNAME). The actual number of extents is displayed after the asterisk. If the number of secondary extents multiplied by the secondary allocation plus the prime allocation is greater than the total allocation, this indicates that the primary allocation is split over multiple extents. The Catalog to which the Volume Summary applies, owns dataspaces on three volumes. The percentage of space used on volume CBLV25 is flagged and a WARN 012 message is displayed, indicating that this percentage value has exceeded the user defined warning threshold (default 85% - see CBLVCPCV switch in tab CBLNAME). For an explanation of all the SUMMARY fields see SUMMARY in tab S-Z. Return code 06 indicates that a warning message was produced on this run (Additionally, every time CBLVCAT produces a return code a WARN 001 message is produced). Example 4. VVDS Report ----------------------- Reporting directly on the contents of a VVDS is also available (See also Example 11 in the Customised report section for further use of this feature). e.g. LC VVDS=CBLI04 __________________________________________________________________________________________________________________________________________ | | | CBLVCAT REL 9.50 AT COMPUTE (Bridgend) Ltd - Wales (OS) VM/CMS=VMPC02 09.47 TUE 29 MAR 94 PAGE 1 | | o -------------------------------------------------- ------------------------------------ -------- o | | | | LISTVCAT VVDS=CBLI04 | | o o | | | | VVDS CBLI04 TYPE NRECS PCNT ---- ALLOC TRACKS ---- FRSP LMAX KL,RKP CISIZE BUFSP CI/CA SHR TIMESTMP | | o --------------------- ---- ----- ---- TOTAL PRIME SEC CI CA ---- /BLK/IMB ------ /IXL ----- --- -------- o | | | | SYS1.VVDS.VCBLI04 ESDS 30+** ALL** 3 3 2 4089 4096 0 10 *3,4* | | o CICS161.SVSTCICS.CSD KSDS 414 10.3 9 9 0* 200V 22,0 22528 45568 18 2,3 93/03/11 10.32 o | | ** 001 CI SPLITS** | | CICS161.SVSTCICS.CSD KSDS IX 1 2.2 1 1 0* 505 512 46 2,3 | | o CICS161.SVSTCICS.DFHTEMP o | | ESDS 300+** ALL** C=2 C=2 C=0* 4089 4096 8192 150 2,3 93/08/05 17.34 | | CICS161.SVSTCICS.FILEA KSDS 45 8.1 1 1 0* 80 6,1 22528 45568 2 1,3 93/08/05 17.34 | | o CICS161.SVSTCICS.FILEA KSDS IX 1 2.2 1 1 0* 505 512 46 2,3 o | | CICS161.SVSTCICS.DFHINTRA | | ESDS 100+**FULL** 10 10 0* 4089 4096 8192 100 2,3 93/08/05 17.34 | | o ICFCAT.CBLI04 KSDS IX 19+**95.0** 1 1 1 2041 --IMB-- 2048 18 *3,4* o | | TMON.TESTTMXS.TMGT01 KSDS 534 50.9 C=3 C=1 C=1 10*10 8185V 25,0 8192 17408 70 2,3 93/10/31 16.04 | | TMON.TESTTMXS.TMGT01 KSDS IX 4 ** ALL** 1 1 1 1017 IMB+REP 1024 IXL=2 31 2,3 | | o ICFCAT.CBLI04 KSDS 47+ 50.0 14 14 7 10 10 32400V 45,9 1024 SPANNED 186 *3,4* o | | ** 152 CI SPLITS** | | CICS161.SVSTCICS.TMON RRDS(R) 150 ** ALL** C=1 C=1 C=0* 4089 4096 8192 150 2,3 93/08/05 17.34 | | o CICS161.SVSTCICS.RSD KSDS 27 5.4 C=1 C=1 C=1 2000V 10,0 2048 6656 252 2,3 93/08/05 17.34 o | | ** 003 CI SPLITS** | | CICS161.SVSTCICS.RSD KSDS IX 1 50.0 1 1 1 2553 IMB+REP 2560 15 2,3 | | o BUZZ.TESTHARN.LINEAR LDS 281 26.8 C=7 C=7 C=7 4096 4096 8192 150 1,3 o | | /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/| Example: VVDS report (CBL Ref: vbxv5f8) Notes ----- IMB+REP in the KL,RKP/BLK/IMB column, indicates that the file was defined with the IMBED and REPLICATE attributes. Warning indications on this report not described in previous examples are as follows: 1. PCNT (**FULL**) The file space is full and no secondary allocations have been specified. 2. FRSP CI/CA (nn*) Unusable free space has been defined (See tab Tech for details). 3. TIMESTMP (** nnn CI SPLITS**) The number of CI splits has reached the warning threshold (default 1 - see CBLVCSCI in tab CBLNAME for details). Example 5. ICF Volume Summary ------------------------------ The VSAM concept of sub-allocated space does not exist for MVS ICF catalogs, therefore the volume summary for these catalogs contains fewer fields. e.g. LC DD=CBLI94 SUMMARY __________________________________________________________________________________________________________________________________________ | | | CBLVCAT REL 9.50 AT COMPUTE (Bridgend) Ltd - Wales (OS) VM/CMS=VMPC02 11.02 TUE 19 APR 94 PAGE 1 | | o -------------------------------------------------- ------------------------------------ -------- o | | | | LISTVCAT DD=CBLI94 SUMMARY | | o o | | | | | | o ICF CAT CBLI94 (3380) TYPE NRECS PCNT ---- ALLOC TRACKS ---- FRSP LMAX KL,RKP CISIZE BUFSP CI/CA SHR TIMESTMP o | | --------------------- ---- ----- ---- TOTAL PRIME SEC CI CA ---- /BLK/IMB ------ /IXL ----- --- -------- | | | | o ICFCAT.CBLI94 KSDS 47+ 50.0 14 14 7 10 10 32400V 45,9 1024 SPANNED 186 3,4 94/03/08 o | | ------------- ** 152 CI SPLITS** | | IX 19+**95.0** 1 1 1 2041 --IMB-- 2048 18 3,4 | | o o | | | | | | o o | | ------ DEV CHARS ------ DATA TRKS | | VOLUME TYPE MIN-CA MAX-CA SETS USED | | o ------ ---- ------ ------ ---- ---- o | | CBLI94 3380 32-44K 480-660K 39 2223 | | XA2201 3380 32-44K 480-660K 1 0 | | o -- ---- o | | 40 2223 | | -- ---- | | o o | | | | | | o o | | ** ** ** ** ** ** ** CBLVCAT IS LICENSED BY COMPUTE (BRIDGEND) LTD 0656-652222, 0656-656466 ** ** ** ** ** ** ** | | ** EXPIRY DATE --- 6 JUN 1995 ** | |__________________________________________________________________________________________________________________________________________| Example: ICF Volume Summary (CBL Ref: vmxisum) Note ---- When SUMMARY is used to suppress the report detail, the self-defining Catalog entry is still reported (The warning indications above are described in earlier examples). Example 6. Standard VTOC Report -------------------------------- A more readable replacement for IEHLIST/LVTOC. The important VTOC information is contained on only one line. Other VTOC information is available either through OPTIONS to the standard report, or via the customised REPORT feature (see the Customised Report section). e.g. List the VTOC of the volume CBLT93 OPTION FREETAB * Display freespace in a table at the end of the report. LV VOL=CBLT93 __________________________________________________________________________________________________________________________________________ | | | CBLVCAT REL 9.50 AT COMPUTE (Bridgend) Ltd - Wales (OS) VM/CMS=VMPC02 09.48 TUE 19 APR 94 PAGE 1 | | o -------------------------------------------------- ------------------------------------ -------- o | | | | LISTVTOC VOL=CBLT93 | | o FREETAB o | | | | | | o VTOC OF CBLT93 CISIZE START ALLOC USED TYPE EXPIRES BLKSIZE LRECL RECFM CREATED INFO o | | -------------- ------ ----- ----- ---- ---- ------- ------- ----- ----- ------- ---- | | | | o VTOC 557256 286 13 FBA 96 96 OWNED BY VSAM CATALOG o | | | | TEST.SCRN.LIBRARY.4 512 155044 1244 PERMANENT F 94/03/23 NOT LAST VOL | | o TEST.SOURCE.LIBRARY.4 512 156288 36000 PERMANENT F 94/03/23 NOT LAST VOL o | | Z9999994.VSAMDSPC.T9A1BDD6.T8976140 | | 512 331824 744 VSAM PERMANENT F | | o Z9999992.VSAMDSPC.T9A1BDD9.T8014540 o | | 512 332568 224688 VSAM PERMANENT F | | MASTER SORT TABLE 4608 661640 160 PERMANENT F 93/11/27 | | o WORK MASTER 8192 661800 2304 PERMANENT F 94/01/15 o | | ACCOUNTS-DATA 2560 664104 4000 *EXPD* F 93/03/21 FILE SERIAL CBLT13 | | V.TSTDATA 4096 669704 4672 94/09/13 F 94/03/21 | | o B.TSTDATA 4096 674376 5760 94/09/13 F 94/03/21 o | | RRR.SORTS 2560 680136 3200 PERMANENT F 94/03/04 | | PRODN.HIST.FILE 10240 697128 15624 PERMANENT F 94/03/24 ***INVALID EXTENT*** | | o o | | ------------------------------------------------------------------ | | | | o FREE SPACE ON CBLT93 2 155042 OLDEST DATED 93/03/21 o | | 192288 139536 LATEST DATED 94/03/24 | | 557542 104098 VTOC RECS LIVE.....12 | | o 664104 4000 EXPD EXPD......1 o | | 668104 1600 FREE....271 | | TOTAL FREE BLOCKS 683336 13792 TOTAL....284 | | o 418068 OUT OF 712512 ( 41% USED) o | | | | ** ** ** ** ** ** ** CBLVCAT IS LICENSED BY COMPUTE (BRIDGEND) LTD 0656-652222, 0656-656466 ** ** ** ** ** ** ** | | ** EXPIRY DATE --- 6 JUN 1995 ** | |__________________________________________________________________________________________________________________________________________| Example: Standard VTOC Report (CBL Ref: vmxtfull) Notes ----- This report is for an FBA device. For a CKD device, the CISIZE field would be replaced by the CYL/HD field. The CBLVCAT messages shown in the above example are as follows: 1. EXPIRES (*EXPD*) Expiry date is less than or equal to todays date (if OPTION EXPD is in force). 2. EXPIRES (PERMANENT) An expiry date of 99/365 or 99/366 (if OPTION PERM is in force). 3. INFO (OWNED BY VSAM CATALOG) This volume is a prime, or candidate, volume of a VSAM catalog. It is therefore not available to other VSAM catalogs. 5. INFO (NOT LAST VOL) Indicates that a sequential file has more extents on another volume, or that a file has not been closed. 6. INFO (FILE SERIAL CBLT13) The file serial number is different from the disk volume serial number (Possibly caused by changing the VOLID after creation of the file). 7. INFO (***INVALID EXTENT***) The extent is not totally within the extent limits in the VTOC Format 4 label. See INFO in tab F-L for a description of the summary fields and other INFO messages. Example 7. Standard Label Report --------------------------------- For VSE only, a more readable and concise replacement for the LSERV label information area listing. e.g. LISTLABL __________________________________________________________________________________________________________________________________________ | | | CBLVCAT REL 9.60 AT COMPUTE (Bridgend) Ltd - Wales 1995/03/09 18:19 PAGE 1 | | o -------------------------------------------------- ---------------- -------- o | | | | | | o LISTL *** o | | | | | | o PARTN FNAME STD LABEL DSN SYSNO VOLUME CAT/TYP DISP EXPIRES BUFNI BUFND START/PRECS ALLOC/SRECS RECSZ INFO o | | ----- ----- ------------- ----- ------ ------- ---- ------- ----- ----- ----------- ----------- ----- ---- | | BG(T) CBLVSAM CBL.VSAM.LABEL.BG SYS001 SYSWK1 (V) N,T,K 99 2221 3000 | | o BG(T) CBLTEMP CBL.TEMP.LABEL.BG SYS001 SYSWK1 (S) 2010/022 5510 7851 o | | BG CBLMULT CBL.MULT.EXT.FILE.BG.VERY.LONG.DSN | | SYS001 SYSWK1 (S) 7 32767 32767 EXT=000 | | o SYS002 SYSWK2 32768 32768 EXT=001 o | | SYS003 SYSWK3 65535 77566 EXT=002 | | | | o o | | PARTN FNAME STD LABEL DSN SYSNO VOLUME CAT/TYP DISP EXPIRES BUFNI BUFND START/PRECS ALLOC/SRECS RECSZ INFO | | ----- ----- ------------- ----- ------ ------- ---- ------- ----- ----- ----------- ----------- ----- ---- | | o F2(T) IJSYS01 %DOS.WORKFILE.SYS001.RECOVER VSESPUC N,K 30 50 4096 o | | F2(T) IJSYS02 %DOS.WORKFILE.SYS002.RECOVER VSESPUC N,K 30 50 4096 | | | | o o | | PARTN FNAME STD LABEL DSN SYSNO VOLUME CAT/TYP DISP EXPIRES BUFNI BUFND START/PRECS ALLOC/SRECS RECSZ INFO | | ----- ----- ------------- ----- ------ ------- ---- ------- ----- ----- ----------- ----------- ----- ---- | | o CL=D LCLASSD CBL.CLASS.D.LABEL SYS001 SYSWK1 (S) 7 o | | CL=S LCLASSS CBL.CLASS.S.LABEL SYS001 SYSWK1 (S) 7 | | CL=X LCLASSX CBL.CLASS.X.LABEL SYS001 SYSWK1 (S) 7 | | o o | | | | PARTN FNAME STD LABEL DSN SYSNO VOLUME CAT/TYP DISP EXPIRES BUFNI BUFND START/PRECS ALLOC/SRECS RECSZ INFO | | o ----- ----- ------------- ----- ------ ------- ---- ------- ----- ----- ----------- ----------- ----- ---- o | | STD IJSYSRS VSE.SYSRES.LIBRARY SYSRES DOSRES (S) 99/365 2 59146 | | STD IJSYSR2 VSE.SYSRES.LIBRARY SYSCAT DOSRES (S) 99/365 2 59146 | | o STD IJSYSR1 SYS.NEW.RES SYSWK1 (S) 99/365 2 59146 o | | STD IJQFILE VSE.POWER.QUEUE.FILE SYS001 DOSRES (DA) 99/365 59520 372 | | STD DFHJ01A CICS.SYSTEM.LOG.A SYS019 DOSRES (S) 297538 3038 | | o STD DFHJ01B CICS.SYSTEM.LOG.B SYS019 DOSRES (S) 300576 3038 o | | STD DFHJ02A CICS.USER.JOURNAL.A SYS019 DOSRES (S) 303614 3038 | | STD DFHJ02B CICS.USER.JOURNAL.B SYS019 DOSRES (S) 306652 3038 | | o STD IJSYSHF VSE.SYSTEM.HISTORY.FILE SYSCAT DOSRES (S) 99/365 309690 5022 o | | STD SYSDUMP VSE.DUMP.LIBRARY SYSWK1 (S) 99/365 195858 37014 | | STD DTSFILE ICCF.LIBRARY SYS010 SYSWK1 (DA) 99/365 305970 70060 | | o STD IJDFILE VSE.POWER.DATA.FILE SYS002 SYSWK1 (DA) 99/365 392956 72044 o | | STD IJAFILE VSE.POWER.ACCOUNT.FILE SYS000 SYSWK1 (DA) 99/365 465000 2108 | | STD VSEJMGR VSESP.JOB.MANAGER.FILE SYSREC SYSWK1 (S) 99/365 467108 186 | | o STD IJSYSCN VSE.HARDCOPY.FILE SYSREC SYSWK1 (S) 99/365 467294 5022 o | | STD IJSYSRC VSE.RECORDER.FILE SYSREC SYSWK1 (S) 99/365 472316 1054 | | STD BLNDMF INFO.ANALYSIS.DUMP.MGNT.FILE SYS016 SYSWK1 (S) 478392 248 | | o STD BLNXTRN INFO.ANALYSIS.EXT.RTNS.FILE SYS017 SYSWK1 (S) 99/365 478640 124 o | | STD TRFILE VTAM.TRACE.FILE SYS001 SYSWK1 (S) 99/365 478764 496 | | STD NCPLOAD CU37XX.LOAD.FILE SYS005 SYSWK1 (S) 99/365 479260 3038 | | o STD MSGUSR CICS.MSGUSR SYS018 SYSWK1 (S) 482298 434 o | | STD IJSYSCT VSAM.MASTER.CATALOG (V) 99/365 | | STD IJSYSLN %DOS.WORKFILE.SYSLNK VSESPUC 400 600 322 | | o STD IESCNTL VSE.CONTROL.FILE VSESPUC 7 o | | STD IESTRFL VSE.TEXT.REPSTORY.FILE VSESPUC 7 | | STD IESTRWF VSE.TEXT.REPSTORY.WORKFILE VSESPUC 7 | | o STD IESMSGS VSE.MESSAGES.ONLINE VSESPUC 7 o | | STD IESPRB VSE.ONLINE.PROB.DET.FILE VSESPUC 7 | | STD IESROUT VSE.MESSAGE.ROUTING.FILE VSESPUC 7 | | o STD DFHSTM CICS.AUTO.STATS.A VSESPUC N,K o | | STD DFHSTN CICS.AUTO.STATS.B VSESPUC N,K | | STD DFHNTRA CICS.TD.INTRA VSESPUC | | o STD DFHTEMP DFHTEMP VSESPUC o | | /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/| Example: Standard Label Report (CBL Ref: vmxlabl) Notes ----- No parameters are supplied to this command, which must be complete on one logical record. The order of the report is: 1. Partition standard labels (temporary and permanent). 2. Class (Dynamic partition) standard labels. 3. System standard labels. If any group of labels is not accessible to CBLVCAT (possibly because it is currently being updated), a message indicating the group which could not be accessed is included in the report (No warning is given if a particular group of labels is empty). e.g. F4 *** Inaccessible *** In the PARTN column, a system standard label is indicated by STD, a permanent partition label is indicated using the partition-id (a temporary partition label has (T) appended to the partition-id) and a class (dynamic partition) label is represented using CL=x, where "x" indicates the CLASS type. In the CAT/TYP column, VSAM files will show the fname of the Catalog that owns the file, if CAT=xxxx was specified on the DLBL, or (V) otherwise. Sequential files will show (S) and Direct Access files will show (DA). In the DISP (file disposition) column, the abbreviations used are N (NEW), O (OLD), K (KEEP), D (DELETE) and T (DATE). The START/PRECS column contains information which varies according to file type. For sequential files, direct access files and VSAM files (or data spaces) created with the UNIQUE option, it contains extent information (if specified). This is either the sequential track number (relative to zero) where the extent is to begin (CKD), or the physical block where the extent is to begin (FBA). For SAM files which reside in a VSAM space it contains the number of records for the primary allocation (if specified). The ALLOC/SRECS column contains information which varies according to file type. For sequential files, direct access files and VSAM files (or data spaces) created with the UNIQUE option, it contains the extent allocation (if specified) in tracks (CKD) or blocks (FBA). For SAM files which reside in a VSAM space it contains the number of records for the secondary allocation (if specified). As can be seen from the above example, if a DLBL has been defined with more than one extent (i.e. more than one EXTENT card), the additional extent information is included on the following line (the unchanged DLBL information is not repeated). In this case the INFO column contains the extent sequence number in the form EXT=nnn. Customised Reports *-***-* Introduction ------------ If the standard Catalog or VTOC report doesn't provide the required format or content, it is possible to produce a customised report containing the necessary information, in a format tailored to your requirements. (Customised printing for LISTLABL is not supported). Customisation is accomplished using one or more of the following commands/parameters, together with their associated parameters/sub-parameters (See examples 8-18). 1. OPTIONS Used to control the page geometry for the report and the level of data reported for each file. It can also be used to control the fields in the standard report (see OPTIONS in tab M-R). 2. SUBSET Allows the user to select which files should be included in the report (see SUBSET in tab S-Z). 3. REPORT Each parameter of the REPORT command determines which fields will appear in a customised report and the order in which they appear (See tab SUM, for a complete list of REPORT parameters, their default field widths and their column format and heading). 4. SORT Lines of output produced by a REPORT command can be sorted into ascending or descending order using the SORT (synonym SORTA) or SORTD parameters. 5. STOPAFT For use with the REPORT VCAT/VTOC SORT parameter. It allows the user to limit the number of files to be displayed in the report. STOPAFT is ignored if not used in conjunction with REPORT VCAT/VTOC SORT. 6. MERGE Used to combine multiple reports into a single listing (See examples 12-18). Example 8. Basic Customised Report ----------------------------------- REPORT can be used, in conjunction with a LISTVCAT/LISTVTOC operation, to control the fields within the report and the order in which they are displayed. e.g. REPORT VCAT DSN SORTD NRECS TYPE LC DD=CBLI94 NOINDEX ___________________________________________________________________________________ | / | CBLVCAT REL 9.50 AT COMPUTE (Bridgend) Ltd - Wales 94/04/19 PAGE 1 \ | o -------------------------------------------------- -------- -------- / | \ | REPORT VCAT DSN SORTD NRECS TYPE / | o \ | LISTCAT DD=CBLI94 NOINDEX / | \ | o / | ICF CAT CBLI94 (3380) NRECS TYPE \ | --------------------- ----- ---- / | o \ | LOTS.NRECS1 62828 KSDS / | ABCD.NRECS1 61430 KSDS \ | o WXYZ.NRECS1 57809 KSDS / | LESS.NRECS1 57784 KSDS \ | ABCD.123.LESS.NRECS 7500 RRDS / | o SMALLER.NRECS.123 2250 RRDS \ | LAST.SHOWN.NRECS.12 1323 KSDS / |/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\ Example: Basic Customised Report (CBL Ref: vmxvsimp) Notes ----- In this example the three fields of the report are: 1. Dataset name (DSN). 2. Number of records in the file (NRECS). 3. File type (TYPE). The SORTD parameter results in a report which is sorted, in descending order, on the fields which follow the parameter. The NOINDEX parameter (LISTVCAT OPTION), causes KSDS and AIX index lines to be suppressed. Example 9. Selective Customised Report --------------------------------------- So far, the examples have displayed the full contents of a catalog or VTOC. Most of the time you will probably only be interested in a particular file or set of files. e.g. Catalog report on a SUBSET of files. REPORT VCAT DSN 30 SORTD NRECS 14 OPTIONS NOVOL NOASSOC NOINDEX LC DD=CBLV03 SUBSET IGN=/CICS KEY=TEST NRECS=1 TYPE=EK ___________________________________________________________________________________ | / | CBLVCAT REL 9.50 AT COMPUTE (Bridgend) Ltd - Wales 1994/04/19 10:02\ | o -------------------------------------------------- ----------------/ | \ | REPORT VCAT DSN 30 SORTD NRECS 14 / | o OPTIONS NOVOL NOASSOC NOINDEX * Limit the report. \ | LISTVCAT DD=CBLV03 / | SUBSET * Select if : (opt parameter) \ | o IGN=/CICS * 'CICS' not in DSN / | KEY=TEST * DSN starts 'TEST' \ | NRECS=1 * File is not empty / | o TYPE=EK * ESDS or KSDS \ | \ | / | o \ | / | DATASET NAME NRECS \ | o ------------ ----- / | \ | TEST3.TRANS.HISTORY.QUARTER 2557934 / | o TEST2W.WORK.HISTORY.WEEKLY 43555 \ | TEST2W.WORK.HISTORY.WEEKLY.SOR 30067 / | TEST2.TRANS.HISTORY.WEEKLY 1 \ | o \ | / | \ | o / | ** ** ** CBLVCAT IS LICENSED BY COMPUTE (BRIDGEND) LTD 0656-652222, 0656-65646\ | ** EXPIRY DATE --- 6 JUN 1995 ** / |__________________________________________________________________________________\ Example: Selective Customised Report (CBL Ref: vmxvsel) Notes ----- The REPORT command is described in the previous example. However, any of its parameters can also be supplied with a numerical argument which overrides the implicit column width, e.g. NRECS 14 (See REPORT in tab M-R for full details). The SUBSET parameter is used for file selection. Only files obeying all the subsequent sub-parameters are selected i.e. a logical AND (The exceptions are KEY and IGN which use a logical OR). The word SUBSET is optional as its associated sub-parameters are unique. NOVOL suppresses Volume information. NOASSOC suppresses file association information. NOINDEX suppresses index lines for AIX and KSDS files. The files which are included in this report must obey the following conditions: 1. NRECS=1 All files with 1, or more, records i.e. all non-empty files. 2. TYPE=EK All ESDS (E) or KSDS (K) files. 3. KEY=TEST All files with a Dataset name starting with TEST. 4. IGN=/CICS Ignore all files with a name containing the string 'CICS'. Remember that NRECS and TYPE will be processed as a logical AND (i.e. both conditions must be true). A file that satisfies this condition will then have to satisfy IGN =/CICS OR KEY=TEST. (See the description of these parameters in tab F-L for further information) The customised report produced will also have been sorted in descending order (SORTD). The sort is performed on the fields which follow SORTD in the parameter list (In this case the number of records - NRECS). Example 10. Advanced Customised Report -------------------------------------- A customised report can also be an invaluable tool to more experienced users, who prefer to analyse information themselves. By allowing the report to focus on particular aspects of file activity, the user can produce a clear, concise report which makes for easier analysis. e.g. Catalog report relating to I/O performance. REPORT VCAT DSN 25 EXCPS RECSTATS 28 IXL CISIZE BUFSP 12 NSEC LC DD=CBLV93 TYPE=K * Select: KSDS only KEY=A.DEMO * DSN's starting 'A.DEMO' only. ______________________________________________________________________________________________ | / | USERCAT CBLV93 (3370) EXCPS -- RECORD STATISTICS -- IXL CISIZE BUFSP NSEC \ | o --------------------- ----- DEL INS UPD INP --- ------ ----- ---- / | \ | / | o A.DEMO.HIGH.EXCPS.INP 17.2K 1 9760 9779 2048 16000 39 \ | 6253 3 512 / | \ | o A.DEMO.ORDINARY.1 159 3 1 2 197K 1536 4096 / | 165 1 512 \ | / | o A.DEMO.ORDINARY.2 60 2 39 1536 4096 \ | 46 1 512 / | \ | o A.DEMO.ORDINARY.3 2075 9 5 1424 18.7K 1536 4096 / | 649 1 512 \ | / | o A.DEMO.ORDINARY.4 2674 1 4415 1 2048 16000 11 \ | 939 2 512 / | \ | o A.DEMO.ORDINARY.5 1646 9 4 1047 8738 1536 4096 / | 591 1 512 \ | / | o A.DEMO.MORE.IX.EXCPS 2475K 18 448 563K 1806K 3072 14336 5 \ | 6830K 3 1536 / | \ | o A.DEMO.XYZ.1 12K 21 3 10.9K 67.8K 1536 4096 / | 579 1 512 \ | / | o A.DEMO.XYZ.2 225 5 2 287 1536 4096 \ | 231 1 512 / | \ | o A.DEMO.XYZ.3 440 9 7 64 2028 1536 4096 / | 187 1 512 \ |_____________________________________________________________________________________________/ Example: Advanced Customised Report (CBL Ref: vmxvadv) Notes ----- The maximum report width is 250 characters. The columns with an overall heading of -- RECORD STATISTICS -- display a breakdown of file I/O activity. The four columns which comprise this field are: 1. Number of deletions (DEL). 2. Number of inserts (INS). 3. Number of updates (UPD). 4. Number of records read (INP). The file A.DEMO.MORE.IX.EXCPS has approximately 3 times as many index EXCPS as data EXCPS. This is very detremental to performance and should be addressed immediately. It either needs to be re-defined with a larger Bufferspace or the data and/or index CISIZE need changing. The file A.DEMO.HIGH.EXCPS.INP has a high number of EXCPS, inserts and records read. It also has acquired 39 secondary extents. Running this report with the SUBSET SEV=3, would have highlighted the files with performance problems as part of CBLVCAT's general monitoring procedure (including the problems mentioned above). Requesting tuning recommendations, with the TUNE parameter, would have recommended measures to address these problems. See tab TUNE for further information. Example 11. Customised VVDS Report ---------------------------------- There is not always a match between BCS and VVDS entries. This can be caused either by Catalogs being removed without the appropriate entry in the VVDS being deleted, or by a job failure. These orphaned entries increase system overheads and should be deleleted as part of a manual housekeeping operation (Such housekeeping, of course, should be conducted by experienced personnel only). Customised reporting on the VVDS (listing the Catalog and Component) helps the user to detect these orphaned entries (provided he/she knows which catalogs have been removed). The IDCAMS command DELETE VVR can then be used to delete the relevant VVR (VSAM Volume Record) entries from the VVDS and the VTOC. e.g. Customised report containing Catalog and component information only and also sorted primarily by Catalog and then by Component. ___________________________________________________________________________________ | / | CBLVCAT REL 9.50 AT COMPUTE (Bridgend) Ltd - Wales 94/03/18 PAGE 1 \ | o -------------------------------------------------- -------- -------- / | \ | REPORT VCAT SORT CATALOG 30 COMPONENT 30 / | o \ | LISTVCAT VVDS=CB9043 / | \ | o / | CATALOG COMPONENT \ | ------- --------- / | o \ | SYS1.VVDS.VCB9043 / | CATALOG.MASTER01 CNM.CBL1.DSIKPNL.INDEX \ | o CATALOG.MASTER01 CNM.CBL1.DSILOGP.DATA / | CATALOG.MASTER01 CNM.CBL1.DSILOGP.INDEX \ | CATALOG.MASTER01 CNM.CBL1.DSILOGS.DATA / | o CATALOG.MASTER01 CNM.CBL1.DSILOGS.INDEX \ | CATALOG.MASTER01 CNM.CBL1.DSISVRT.DATA / | CATALOG.MASTER01 CNM.CBL1.DSISVRT.INDEX \ | o CATALOG.MASTER01 CNM.CBL1.DSITRCP.DATA / | CATALOG.MASTER01 CNM.CBL1.DSITRCP.INDEX \ | CATALOG.MASTER01 CNM.CBL1.DSITRCS.DATA / | o CATALOG.MASTER01 CNM.CBL1.DSITRCS.INDEX \ | SYS1.ICFCAT.OLDCAT NOT.NEEDED01.DATA / | SYS1.ICFCAT.OLDCAT NOT.NEEDED01.INDEX \ | o SYS1.ICFCAT.OLDCAT NOT.NEEDED02.DATA / | SYS1.ICFCAT.OLDCAT NOT.NEEDED03.DATA \ | SYS1.ICFCAT.OLDCAT NOT.NEEDED04.DATA / | o SYS1.ICFCAT.OLDCAT NOT.NEEDED05.DATA \ | SYS1.ICFCAT.LIVECAT CICSPV.PRISM.COPY.DFHNTRA.DATA / | SYS1.ICFCAT.LIVECAT CICSPV.PRISM.COPY.DFHTEMP.DATA \ | o SYS1.ICFCAT.LIVECAT CICSPV.PRISM.RSD.DATA / | SYS1.ICFCAT.LIVECAT CICSPV.PRISM.RSD.INDEX \ | SYS1.ICFCAT.LIVECAT CICSPV.PRISM.TMON.ALERTA.DATA / | o SYS1.ICFCAT.LIVECAT CICSPV.PRISM.TMON.ALERTB.DATA \ \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Example: Customised VVDS Report (CBL Ref: vbxv5f6) Notes ----- As the report is sorted by Catalog, all entries relating to a non-existent Catalog will appear consecutively on the report making location easier. If the Catalog SYS1.ICFCAT.OLDCAT no longer exists, the VVR records in VVDS CB9043 which reference this Catalog are therefore redundant. Example 12. Combined VTOC Report -------------------------------- The MERGE parame