MVSFORUMS.com

[ksandy]

We have few VSAM files in our application , occupying lots of space . Can anybody inform me possible ways to optimize VSAM files , so that we can have better utilization of DASD.

If require , I will post LISTCAT details too..

[warp5]

We need to see information about the cluster and what kind of disk system you are using.

[ksandy]

Here are details of one of the VSAM file. Please let me know your suggestions for space optimization

==============================
0CLUSTER -------
IN-CAT --- CATALOG.TSO.VSYS009
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2003.085
RELEASE----------------2 EXPIRATION------0000.000
SMSDATA
STORAGECLASS -----SCNORM MANAGEMENTCLASS--MCSTAND
DATACLASS --------(NULL) LBACKUP ---0000.000.0000
BWO STATUS------00000000 BWO TIMESTAMP---00000 00:00:00.0
BWO---------------(NULL)
RLSDATA
LOG ----------------(NULL) RECOVERY REQUIRED --(NO) FRLOG ------------(NULL)
VSAM QUIESCED -------(NO) RLS IN USE ---------(NO)
0 LOGSTREAMID-----------------------------(NULL)
RECOVERY TIMESTAMP LOCAL-----X'0000000000000000'
RECOVERY TIMESTAMP GMT-------X'0000000000000000'
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
DATA-----.DATA
INDEX----.INDEX
0 DATA ------- .DATA
IN-CAT --- CATALOG.TSO.VSYS009
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2003.085
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
1IDCAMS SYSTEM SERVICES TIME: 15:15:41 03/28/03 PAGE 4
0 PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--
ATTRIBUTES
KEYLEN----------------34 AVGLRECL--------------71 BUFSPACE-----------30000 CISIZE-------------10240
RKP--------------------0 MAXLRECL------------9800 EXCPEXIT----------(NULL) CI/CA-----------------75
SHROPTNS(3,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK NOIMBED NOREPLICAT
UNORDERED NOREUSE NONSPANNED
STATISTICS
REC-TOTAL--------1007800 SPLITS-CI------------401 EXCPS--------------50499
REC-DELETED------------3 SPLITS-CA--------------8 EXTENTS---------------11
REC-INSERTED-------15233 FREESPACE-%CI---------10 SYSTEM-TIMESTAMP:
REC-UPDATED----------142 FREESPACE-%CA---------10 X'B93041398BFFF003'
REC-RETRIEVED----9372782 FREESPC---------14387200
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA-------122880000
SPACE-PRI-------------60 HI-U-RBA-------121344000
SPACE-SEC-------------10
VOLUME
VOLSER------------BP3076 PHYREC-SIZE--------10240 HI-A-RBA-------122880000 EXTENT-NUMBER---------11
DEVTYPE------X'3010200F' PHYRECS/TRK------------5 HI-U-RBA-------121344000 EXTENT-TYPE--------X'40'
VOLFLAG------------PRIME TRACKS/CA-------------15
EXTENTS:
LOW-CCHH-----X'02360000' LOW-RBA----------------0 TRACKS---------------900
HIGH-CCHH----X'0271000E' HIGH-RBA--------46079999
LOW-CCHH-----X'02720000' LOW-RBA---------46080000 TRACKS---------------150
HIGH-CCHH----X'027B000E' HIGH-RBA--------53759999
LOW-CCHH-----X'027C0000' LOW-RBA---------53760000 TRACKS---------------150
HIGH-CCHH----X'0285000E' HIGH-RBA--------61439999
LOW-CCHH-----X'00D10000' LOW-RBA---------61440000 TRACKS---------------150
HIGH-CCHH----X'00DA000E' HIGH-RBA--------69119999
LOW-CCHH-----X'012E0000' LOW-RBA---------69120000 TRACKS---------------150
HIGH-CCHH----X'0137000E' HIGH-RBA--------76799999
LOW-CCHH-----X'01380000' LOW-RBA---------76800000 TRACKS---------------150
HIGH-CCHH----X'0141000E' HIGH-RBA--------84479999
LOW-CCHH-----X'01C80000' LOW-RBA---------84480000 TRACKS---------------150
HIGH-CCHH----X'01D1000E' HIGH-RBA--------92159999
LOW-CCHH-----X'01D20000' LOW-RBA---------92160000 TRACKS---------------150
HIGH-CCHH----X'01DB000E' HIGH-RBA--------99839999
LOW-CCHH-----X'01DC0000' LOW-RBA---------99840000 TRACKS---------------150
HIGH-CCHH----X'01E5000E' HIGH-RBA-------107519999
LOW-CCHH-----X'028B0000' LOW-RBA--------107520000 TRACKS---------------150
HIGH-CCHH----X'0294000E' HIGH-RBA-------115199999
LOW-CCHH-----X'02A50000' LOW-RBA--------115200000 TRACKS---------------150
HIGH-CCHH----X'02AE000E' HIGH-RBA-------122879999
VOLUME
VOLSER-----------------* PHYREC-SIZE------------0 HI-A-RBA---------------0 EXTENT-NUMBER----------0
DEVTYPE------X'3010200F' PHYRECS/TRK------------0 HI-U-RBA---------------0 EXTENT-TYPE--------X'FF'
VOLFLAG--------CANDIDATE TRACKS/CA--------------0
0 INDEX ------ .INDEX
1IDCAMS SYSTEM SERVICES TIME: 15:15:41 03/28/03 PAGE 5
0 IN-CAT --- CATALOG.TSO.VSYS009
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2003.085
RELEASE----------------2 EXPIRATION------0000.000
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--
ATTRIBUTES
KEYLEN----------------34 AVGLRECL---------------0 BUFSPACE---------------0 CISIZE--------------2048
RKP--------------------0 MAXLRECL------------2041 EXCPEXIT----------(NULL) CI/CA-----------------21
SHROPTNS(3,3) RECOVERY UNIQUE NOERASE NOWRITECHK NOIMBED NOREPLICAT UNORDERED
NOREUSE
STATISTICS
REC-TOTAL------------162 SPLITS-CI--------------8 EXCPS---------------4439 INDEX:
REC-DELETED------------0 SPLITS-CA--------------1 EXTENTS----------------3 LEVELS-----------------3
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP: ENTRIES/SECT-----------8
REC-UPDATED----------473 FREESPACE-%CA----------0 X'B93041398BFFF003' SEQ-SET-RBA------------0
REC-RETRIEVED----------0 FREESPC------------55296 HI-LEVEL-RBA------217088
ALLOCATION
SPACE-TYPE---------TRACK HI-A-RBA----------387072
SPACE-PRI--------------3 HI-U-RBA----------331776
SPACE-SEC--------------3
VOLUME
VOLSER------------BP3076 PHYREC-SIZE---------2048 HI-A-RBA----------387072 EXTENT-NUMBER----------3
DEVTYPE------X'3010200F' PHYRECS/TRK-----------21 HI-U-RBA----------331776 EXTENT-TYPE--------X'40'
VOLFLAG------------PRIME TRACKS/CA--------------1
EXTENTS:
LOW-CCHH-----X'00100003' LOW-RBA----------------0 TRACKS-----------------3
HIGH-CCHH----X'00100005' HIGH-RBA----------129023
LOW-CCHH-----X'0013000C' LOW-RBA-----------129024 TRACKS-----------------3
HIGH-CCHH----X'0013000E' HIGH-RBA----------258047
LOW-CCHH-----X'00140000' LOW-RBA-----------258048 TRACKS-----------------3
HIGH-CCHH----X'00140002' HIGH-RBA----------387071
VOLUME
VOLSER-----------------* PHYREC-SIZE------------0 HI-A-RBA---------------0 EXTENT-NUMBER----------0
DEVTYPE------X'3010200F' PHYRECS/TRK------------0 HI-U-RBA---------------0 EXTENT-TYPE--------X'FF'
VOLFLAG--------CANDIDATE TRACKS/CA--------------0
VOLUME
VOLSER-----------------* PHYREC-SIZE------------0 HI-A-RBA---------------0 EXTENT-NUMBER----------0
DEVTYPE------X'3010200F' PHYRECS/TRK------------0 HI-U-RBA---------------0 EXTENT-TYPE--------X'FF'
VOLFLAG--------CANDIDATE TRACKS/CA--------------0
1IDCAMS SYSTEM SERVICES TIME: 15:15:41 03/28/03 PAGE 6
0 THE NUMBER OF ENTRIES PROCESSED WAS:
AIX -------------------0
ALIAS -----------------0
CLUSTER ---------------1
DATA ------------------1
GDG -------------------0
INDEX -----------------1
NONVSAM ---------------0
PAGESPACE -------------0
PATH ------------------0
SPACE -----------------0
USERCATALOG -----------0
TAPELIBRARY -----------0
TAPEVOLUME ------------0
TOTAL -----------------3
0 THE NUMBER OF PROTECTED ENTRIES SUPPRESSED WAS 0
============================================

[warp5]

According to the data you posted you have a insert ratio of only 1.5% but are reserving 10% CI and 10% CA freespace. You should set your CI freespace to 0 and reduce your CA freespace. Your CA freespace depends upon how often you reorganize and how many inserts you have until you reorganize.
I would recommend changing your primary and secondary sizes to reduce the number of extents you are using.

[R.Nickel]

ksandy,

Set freespace for both CI's and CA's to zero, change your CISIZE to 18432( if you are not using extended format vsam datasets, which I don't think you are, and you use 3390's) space allocation using these figures will be about 865 primary cylinders, you could even reduce index CISIZE to 1024.
Load up your file and repost the listcat from the amended file.
_________________
Rainer