Posted: Fri Mar 19, 2010 9:15 am Post subject: Generate a Report from Listcat Listing
I have a dataset with 120 bytes in which I am storing the LISTCAT information of many VSAM datasets.I want to create an output file
which should give me the dataset name and size of Primary Quantity and size of Secondary Quantity for those only whose ALLOCATION SPACE-TYPE is CYLINDER and SPACE-PRI should be more than or equal to 50 .
Sample Input File:
Code:
IDCAMS SYSTEM SERVICES TIME: 10:03:59
LISTCAT ENT('DB2T.DSNDBD.TEST') ALL
DATA ---------- DB2T.DSNDBD.TEST
IN-CAT --- VSAMDSET.ICF01.DB2F82
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2010.007
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--DB2T.DSNDBC.TEST
ATTRIBUTES
KEYLEN-----------------0 AVGLRECL---------------0 BUFSPACE-------
RKP--------------------0 MAXLRECL---------------0 EXCPEXIT-------
SHROPTNS(3,3) RECOVERY UNIQUE NOERASE LINEAR N
UNORDERED REUSE NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS----------
REC-DELETED------------0 SPLITS-CA--------------0 EXTENTS--------
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAM
REC-UPDATED------------0 FREESPACE-%CA----------0 X'00000000
REC-RETRIEVED----------0 FREESPC----------------0
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA---------2949120
SPACE-PRI--------------4 HI-U-RBA---------1474560
SPACE-SEC--------------1
VOLUME
VOLSER------------DBAP35 PHYREC-SIZE---------4096 HI-A-RBA-------
DEVTYPE------X'3010200F' PHYRECS/TRK-----------12 HI-U-RBA-------
VOLFLAG------------PRIME TRACKS/CA-------------15
EXTENTS:
LOW-CCHH-----X'005E0000' LOW-RBA----------------0 TRACKS---------
HIGH-CCHH----X'0061000E' HIGH-RBA---------2949119
IDCAMS SYSTEM SERVICES TIME: 10:03:59
THE NUMBER OF ENTRIES PROCESSED WAS:
AIX -------------------0
ALIAS -----------------0
CLUSTER ---------------0
DATA ------------------1
GDG -------------------0
INDEX -----------------0
NONVSAM ---------------0
PAGESPACE -------------0
PATH ------------------0
SPACE -----------------0
USERCATALOG -----------0
TAPELIBRARY -----------0
TAPEVOLUME ------------0
TOTAL -----------------1
THE NUMBER OF PROTECTED ENTRIES SUPPRESSED WAS 0
IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 0
I am interested only in the data component . Yes you are correct the LISTCAT gives output in VBA format with 125 bytes.Could you please help me further. Thanks.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum