View previous topic :: View next topic
|
Author |
Message |
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi All,
There is a requirement in our environment where we have to Identify space allocated and used for all Vsam datasets (More than 20000 Data sets). And
We have to prepare report whose space utilization is < 10% .
As of now using LISTC we can get Allocated (HI-A-RBA) and Used space(HI-U-RBA). But when we check these allocated and used space information in File Aid its not matching. The below example of Listc of one of the dataset.
Code: |
DATA ---------- PPPP.TEST.DATA
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
SPACE-PRI--------------1 HI-U-RBA----------829440
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
SPACE-PRI--------------1 HI-U-RBA----------829440
SPACE-SEC--------------1
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
SPACE-PRI--------------1 HI-U-RBA----------829440
SPACE-SEC--------------1
VOLUME
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
SPACE-PRI--------------1 HI-U-RBA----------829440
SPACE-SEC--------------1
VOLUME
VOLSER------------O1MID1 PHYREC-SIZE--------18432 HI-A-RBA----------829440 EXTENT-NUMBER----------1
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
SPACE-PRI--------------1 HI-U-RBA----------829440
SPACE-SEC--------------1
VOLUME
VOLSER------------O1MID1 PHYREC-SIZE--------18432 HI-A-RBA----------829440 EXTENT-NUMBER----------1
DEVTYPE------X'3010200F' PHYRECS/TRK------------3 HI-U-RBA----------829440 EXTENT-TYPE--------X'40'
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
SPACE-PRI--------------1 HI-U-RBA----------829440
SPACE-SEC--------------1
VOLUME
VOLSER------------O1MID1 PHYREC-SIZE--------18432 HI-A-RBA----------829440 EXTENT-NUMBER----------1
DEVTYPE------X'3010200F' PHYRECS/TRK------------3 HI-U-RBA----------829440 EXTENT-TYPE--------X'40'
VOLFLAG------------PRIME TRACKS/CA-------------15
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
SPACE-PRI--------------1 HI-U-RBA----------829440
SPACE-SEC--------------1
VOLUME
VOLSER------------O1MID1 PHYREC-SIZE--------18432 HI-A-RBA----------829440 EXTENT-NUMBER----------1
DEVTYPE------X'3010200F' PHYRECS/TRK------------3 HI-U-RBA----------829440 EXTENT-TYPE--------X'40'
VOLFLAG------------PRIME TRACKS/CA-------------15
EXTENTS:
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
SPACE-PRI--------------1 HI-U-RBA----------829440
SPACE-SEC--------------1
VOLUME
VOLSER------------O1MID1 PHYREC-SIZE--------18432 HI-A-RBA----------829440 EXTENT-NUMBER----------1
DEVTYPE------X'3010200F' PHYRECS/TRK------------3 HI-U-RBA----------829440 EXTENT-TYPE--------X'40'
VOLFLAG------------PRIME TRACKS/CA-------------15
EXTENTS:
LOW-CCHH-----X'00300000' LOW-RBA----------------0 TRACKS----------------15
DATA ---------- PPPP.TEST.DATA
IN-CAT --- USER.TEST.CATALOG
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2013.165
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--PULN.MR.NMA00.FSLINK
ATTRIBUTES
KEYLEN----------------13 AVGLRECL-------------300 BUFSPACE-----------37376 CISIZE-------------18432
RKP--------------------0 MAXLRECL-------------300 EXCPEXIT----------(NULL) CI/CA-----------------45
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK UNORDERED NOREUSE
NONSPANNED
STATISTICS
REC-TOTAL--------------0 SPLITS-CI--------------0 EXCPS------------------4
REC-DELETED------------1 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA----------0 X'CB82A975FB6C382A'
REC-RETRIEVED----------1 FREESPC-----------811008
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA----------829440
SPACE-PRI--------------1 HI-U-RBA----------829440
SPACE-SEC--------------1
VOLUME
VOLSER------------O1MID1 PHYREC-SIZE--------18432 HI-A-RBA----------829440 EXTENT-NUMBER----------1
DEVTYPE------X'3010200F' PHYRECS/TRK------------3 HI-U-RBA----------829440 EXTENT-TYPE--------X'40'
VOLFLAG------------PRIME TRACKS/CA-------------15
EXTENTS:
LOW-CCHH-----X'00300000' LOW-RBA----------------0 TRACKS----------------15
HIGH-CCHH----X'0030000E' HIGH-RBA----------829439
|
The below is File Aid information of the above data set..
Code: |
Related Datasets - 'PPPP.TEST'
CLUSTER - PPPP.TEST Storage: STANDARD
Data: SCR
Management: NOACTION
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - -
Current Space: ALLOCATED USED Data Records
Tracks: 15 1 ( 7 %) Total:
Extents: 1 1 ( 100 %) Deleted: 1
KSDS Index: 1 - Inserted: 0
|
Am planning to code a REXX to grab space allocated and used information for all VSAM data sets.
Any body suggested how File aid is considering space allocated and space used?
Thanks. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
using the IGGCSI interface will be more effective than parsing the listcat output
search the forum for the examples ( IGGCSIRX ) |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi Enrico,
Thanks for your quick response. I have gone through SYS1.SAMPLIB(IGGCSIRX) and looks bit complex to me. Is there any other way
to get VSAM Allocated and Used space information for a single Vsam dataset..
Thanks! |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
searching the forum with "IGGCSI*" returned 90' hits and at least one of them has what You need |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi Enrico,
I have executed one of the old rexx(From old forums search as suggested by you) which will provide the below information.
/* REXX ** RETURNS VSAM INFO, HARBA, HURBA, PHYRECSZ, RECS/TRK */
This information is same as LISTC information. But my query is these allocated and Used space details are different from File Aid ..
Just want to know what basis File aid is calculated Allocated and Used space details..
Thanks! |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2454 Location: Hampshire, UK
|
|
|
|
Why not ask the File Aid creators? Why do you expect anyone here to have that sort of (proprietory) information? |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi Nic,
Actually am using formula (HI-U-RBA/HI-U-RBA) * 100 to find out used percentage of a Vsam file in my REXX. But Client is verifying this information using File Aid and lot of differences found in Usage percentage. And I know File aid is more accurate then LISTC.
I searched old forums and some one explained how file aid calculates Allocated space of Vsam file. But no information on Usage space calculation.
Just thought of checking in case if any body is having similar situation earlier..
Thanks! |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8700 Location: Dubuque, Iowa, USA
|
|
|
|
Since you have no way to identify exactly how File Aid is doing the calculation, you'll just have to tell the client that your numbers are as close as you can get. If the difference is generally just a few percent, there's not really anything that should be done. If the difference is significant (such as 25% or more), then that would indicate a problem. |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi RoberT,
If I use HI-U-RBA and HI-U-RBA values the difference between file aid and LISTC is between 20 - 25%(which is high).
Thanks! |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8700 Location: Dubuque, Iowa, USA
|
|
|
|
You have started -- FINALLY -- to quantify the issue. You need to go further, though. Is the File Aid calculation larger or smaller than the LISTCAT calculation? Is the issue for every data set? If so, CONTACT THE FILE AID VENDOR FOR ASSISTANCE. If the issue only occurs for certain data sets, you need to identify for which data sets the issue occurs (small? large? SMS-managed?). After you've done this, you will still need to contact the vendor about the issue.
Since File Aid is not part of base z/OS, you really, really, REALLY need to start by contacting the vendor -- they know far more about their software than anyone on this (or any) forum. |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi Robert,
File Aid calculation is larger than LISTCAT. Yeah.. am contacting Vendor but not sure whether I can ask how File aid Calculates Allocated and Used space. But Am running FDR Reports to grab similar information.I will let you know more details.
Thanks! |
|
Back to top |
|
|
David Robinson
Active User
Joined: 21 Dec 2011 Posts: 199 Location: UK
|
|
|
|
IIRC, doesn't the LISTCAT output show the data at the point the dataset was last closed, or some other process that writes these stats. I may be off here, it's just a vague memory!
Perhaps File/Aid has a way of getting more "real time" information.
File/Aid can also run in batch, that might be an option for what you're after (although whether ALL File/Aid functionality is available in batch, I'm not sure). |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi All,
I ran FDR reports to extract Vsam utilization information. Not matching with File Aid but some what near to File Aid values.
Thanks! |
|
Back to top |
|
|
steve-myers
Active Member
Joined: 30 Nov 2013 Posts: 917 Location: The Universe
|
|
|
|
Allocated space should match, ideally exactly.
Used space is much more complex. To some extent it depends on embedded free space, and actual CA and CI splits, and whether the calculation removes the defined embedded free space from HI-U-RBA.
The final issue is the relative reliability of HI-U-RBA and CA and CI splits. It's only recalculated every time the data set is closed. If the data set wasn't closed properly, say the system crashed or the address space updating the data set crashed, or possibly the application just abnormally terminated, these statistics are not going to be all that reliable. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
Given the above post, it may be useful to attempt to run a VERIFY on the cluster before getting the stats as that will, if the cluster is unallocated, OPEN / CLOSE the cluster and update the stats. |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi David,
Yes, we can use File Aid batch job to grab VSAM Information. I need to grab this information for almost 20,000 data sets which is bit tough. We dont have File Aid Batch option in our environment.
I have queried Vendor on Calculations used for Vsam Allocated and Used space information but didnt receive proper response from them.
Thanks! |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi Steve,
Yes , Allocated space is exactly matching. Looks like file is considering space inside CI's as well. File Aid information is more accurate than FDR and LISTC.
Thanks! |
|
Back to top |
|
|
upendrasri
Active User
Joined: 28 Sep 2017 Posts: 124 Location: India
|
|
|
|
Hi Expat,
I have created my own test file(Copied from prod file) and again ran verify against to it. Even then there is difference between LISTC and File Aid values.
Thanks! |
|
Back to top |
|
|
|