IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

VSAM Spacce allocated and used --> REXX


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sat Mar 09, 2019 3:54 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10888
Location: italy

PostPosted: Sat Mar 09, 2019 4:14 pm
Reply with quote

using the IGGCSI interface will be more effective than parsing the listcat output
search the forum for the examples ( IGGCSIRX )
Back to top
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sat Mar 09, 2019 4:39 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10888
Location: italy

PostPosted: Sat Mar 09, 2019 4:46 pm
Reply with quote

searching the forum with "IGGCSI*" returned 90' hits and at least one of them has what You need
Back to top
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sat Mar 09, 2019 6:03 pm
Reply with quote

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
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK

PostPosted: Sun Mar 10, 2019 3:32 am
Reply with quote

Why not ask the File Aid creators? Why do you expect anyone here to have that sort of (proprietory) information?
Back to top
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sun Mar 10, 2019 9:23 am
Reply with quote

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
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sun Mar 10, 2019 9:40 am
Reply with quote

Here the link from old forums

www.ibmmainframeforum.com/vsam-sms/topic1171.html

Thanks!
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA

PostPosted: Sun Mar 10, 2019 9:55 am
Reply with quote

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
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sun Mar 10, 2019 10:21 am
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA

PostPosted: Sun Mar 10, 2019 5:19 pm
Reply with quote

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
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sun Mar 10, 2019 5:31 pm
Reply with quote

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
View user's profile Send private message
David Robinson

Active User


Joined: 21 Dec 2011
Posts: 199
Location: UK

PostPosted: Tue Mar 12, 2019 3:48 pm
Reply with quote

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
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Tue Mar 12, 2019 9:32 pm
Reply with quote

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
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 917
Location: The Universe

PostPosted: Tue Mar 12, 2019 10:02 pm
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales

PostPosted: Wed Mar 13, 2019 1:05 pm
Reply with quote

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
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sat Mar 16, 2019 11:49 am
Reply with quote

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
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sat Mar 16, 2019 12:13 pm
Reply with quote

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
View user's profile Send private message
upendrasri

Active User


Joined: 28 Sep 2017
Posts: 124
Location: India

PostPosted: Sat Mar 16, 2019 12:15 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts Run rexx with JCL Job CLIST & REXX 1
No new posts Run rexx in batch job CLIST & REXX 7
No new posts Does anyone know rexx for VSE CLIST & REXX 3
No new posts TSO ALLOC In REXX Needs Improvement JCL & VSAM 3
No new posts REXX/CMS How to place command console... CLIST & REXX 4
Search our Forums:

Back to Top