In the examples, a SAS macro variable is used to specify the
DDname part of the CA MICS file name. These macro variables
are a standard part of CA MICS and are available for all
files. The macro variable name has the form &diiit, where d
is the database identifier, iii is the information area
name, and t is the timespan. For the examples, a database
identifier of P is used. The identifier is installation
dependent, so you should find out what the identifiers are at
your installation.
1. List all VSAM data sets created yesterday with a high
level data set name qualifier of 'PERDB'.
DATA;
SET &PVCAX..VCA_VS01;
IF DSNAME=:'PERDB';
IF TODAY() - 1 = CREATEDT;
PROC PRINT; VAR DSNAME DAACATNM VOLSER
DAASPACA DAASPACU;
RUN;
2. List VSAM structures with 50 or more CA splits or 5000 or
more CI splits.
DATA;
SET DETAIL.VCA_VS01;
IF DAANCAS GE 50 OR DAANCIS GE 5000;
PROC PRINT NOOBS LABEL;
VAR DSNAME DAAVCOMP VOLSER DAANCAS DAANCIS;
TITLE1 'CI/CA SPLIT REPORT';
An example of the output appears as follows:
CI/CA SPLIT REPORT 12:04 FRIDAY, mmmddyyyy Data VSAM Data Set Volume Number Number Set Component Serial of CA of CI Name Type Number Splits Splits CATALOG.MVSICF1.VMVSWXA DATA MVSWXA 44 5819 CNM.SA08.BNJLGPR.DATA DATA LRG008 0 14514 CNM.SA08.AAUVSPL.DATA DATA LRG010 116 40623 CSS.PROD.LMP.SDDS.DATA DATA TSU060 140 1401 CSS.PROD.LMP.SDDS.DATA DATA TSU061 140 1401 CSS.PROD.LMP.SDDS.DATA DATA TSU062 140 1401 CSS.PROD.LMP.SDDS.DATA DATA TSU067 140 1401 CSS.PROD.DB5.SDDS.DATA DATA TSU060 150 1408 CSS.PROD.DB5.SDDS.DATA DATA TSU062 150 1408 KTI004.CED.IPCSDDIR.DATA DATA MVS343 32 16460 ESASMPE.MVSDLIB.CSI.DATA DATA S32RS1 33 5332 ESASMPE.TARGET.CSI.DATA DATA S32RS1 32 13112 INFORAM.TPX.VSAM.DATA DATA TSU030 0 13124 IPOIPCS.RAMJX11.DEBUGD DATA MVS965 11 16228 IPOIPCS.RAMRK11.DEBUGD DATA MVS965 55 12736 IPOIPCS.RAMAM11.DEBUGD DATA MVS3C3 64 13653 IPOIPCS.RAMBP11.DEBUGD DATA MVS3C3 9 5412 IPOIPCS.RAMGM11.DEBUGD DATA MVS3C3 25 14727 IPOIPCS.RAMKB22.DEBUGD DATA MVS3C3 26 5101 IPOIPCS.RAMLP11.DEBUGD DATA MVS3C3 43 7941 IPOIPCS.RAMOS11.DEBUGD DATA MVS3C3 10 15829 IPOIPCS.RAMPL11.DEBUGD DATA MVS3C3 31 5276 IPOIPCS.RAMRC11.DEBUGD DATA MVS3C3 51 26015 IPOIPCS.RAMVK11.DEBUGD DATA MVS3C3 7 13391 IPOIPCS.RAMPR33.DEBUGD DATA LRG008 14 14510 IPOIPCS.RAMAP11.DEBUGD DATA TSU028 10 7229 IPOIPCS.RAMDS11.DEBUGD DATA TSU036 6 7264 IPOIPCS.RAMDV11.DEBUGD DATA TSU029 22 6431 IPOIPCS.RAMGO11.DDIRD DATA TSU033 42 16766 IPOIPCS.RAMGO11.DEBUGD DATA TSU028 28 13393 IPOIPCS.RAMJK11.DEBUGD DATA TSU059 49 5389 IPOIPCS.RAMJP11.DEBUGD DATA TSU027 24 18521 IPOIPCS.RAMRB11.DEBUGD DATA TSU059 24 17467 IPOIPCS.RAMRF11.DEBUGD DATA TSU063 46 6852 IPOIPCS.RAMTL11.DEBUGD DATA TSU027 74 25631 IPOIPCS.RAMTR11.DEBUGD DATA TSU033 24 13514 IPOIPCS.RAMWM11.DEBUGD DATA TSU055 17 11823 SYS9.HSM.BCDS.DATA DATA MVS961 87 2294 RAMPE22.DDIRD DATA TSU057 14 6754 RAMKD11.RAMKD11.DEBUGD DATA MVS3C3 27 33061 TUNDX.REL40.DPMFAIF.DATA DATA TSU027 98 716 TUNDX.REL40.DPMFVPF0.DATA DATA TSU027 123 2 RAMCG22.DDIRD DATA TSU027 89 13370
Figure 5-4. Sample CI/CA Split Report 3. Show the allocated VSAM space in megabytes by storage group. PROC CHART DATA=DAYS.VCA_VS01; VBAR STORNAME / TYPE=SUM SUMVAR=DAAALLSP; TITLE1 'ALLOCATED VSAM SPACE (MB) BY STORAGE GROUP'; An example of the output appears as follows:
ALLOCATED VSAM SPACE (MB) BY STORAGE GROUP 15:21 FRIDAY, mmmddyyyy BAR CHART OF SUMS DAAALLSP SUM | ***** | ***** 5000 + ***** | ***** | ***** | ***** | ***** 4000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** | ***** ***** 3000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** | ***** ***** 2000 + ***** ***** | ***** ***** | ***** ***** | ***** ***** ***** | ***** ***** ***** 1000 + ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** | ***** ***** ***** ***** ***** | ***** ***** ***** ***** ***** ------------------------------------------------------------------------------------------------------------- BSTGRP CSSGRP LRGGRP MIG3380 MIG3390 PGDGRP TECGRP TMPGRP TSUGRP STORNAME DFSMS Storage Group Name
Figure 5-5. Sample Allocated VSAM Space by Storage Group Report
|
Copyright © 2014 CA.
All rights reserved.
|
|