| View previous topic :: View next topic |
| Author |
Message |
Sarangadhar
Beginner
Joined: 14 Oct 2004
Posts: 130
Topics: 43
Location: virtual village
|
 Posted: Thu Oct 14, 2004 3:48 pm Post subject: VSAM space usage process using a program not using tool |
 |
|
Hi all,
Could anybody gimme a program that calculates used space , free space of a VSAM file(KSDS). We can get some information using IDCAMS-LISTCAT option. Using this info form LISTCAT can we calculate usage&free space. Or any other way?
(We can see details using fileaid->3->5 option, but I need a program)
_________________
Thanks |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12368
Topics: 75
Location: San Jose
|
| Posted: Thu Oct 14, 2004 6:30 pm Post subject: |
|
|
Sarangadhar,
Post your file Attributes from your listcat listing , I will show you how to calculate the usage and free space
Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Sarangadhar
Beginner
Joined: 14 Oct 2004
Posts: 130
Topics: 43
Location: virtual village
|
| Posted: Fri Oct 15, 2004 8:42 am Post subject: |
|
|
Hi kolusu, this is the info I got from List cat all in IDCAMS:
----------------------------------------------------------------------------------------------
| Code: |
1IDCAMS SYSTEM SERVICES TIME: 10:31:56 10/07/04 PAGE 1
0
LISTCAT ALL ENTRIES(COG.KRIS.TEST)
0CLUSTER ------- COG.KRIS.TEST
IN-CAT --- ICFCAT.VTSO001
HISTORY
DATASET-OWNER------COGRK CREATION--------2004.280
RELEASE----------------2 EXPIRATION------0000.000
SMSDATA
STORAGECLASS ---SCTSOSTD MANAGEMENTCLASS-MTSOSTD1
DATACLASS --------DCNULL LBACKUP ---2004.281.0338
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-----COG.KRIS.TEST.DATA
INDEX----COG.KRIS.TEST.INDEX
0 DATA ------- COG.KRIS.TEST.DATA
IN-CAT --- ICFCAT.VTSO001
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2004.280
RELEASE----------------2 EXPIRATION------0000.000
ACCOUNT-INFO-----------------------------------(NULL)
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--COG.KRIS.TEST
ATTRIBUTES
KEYLEN-----------------2 AVGLRECL--------------10 BUFSPACE------------9728 CISIZE--------------4096
RKP--------------------0 MAXLRECL--------------10 EXCPEXIT----------(NULL) CI/CA-----------------24
SHROPTNS(2,3) SPEED UNIQUE NOERASE INDEXED NOWRITECHK NOIMBED NOREPLICAT
UNORDERED REUSE NONSPANNED
STATISTICS
REC-TOTAL--------------4 SPLITS-CI--------------0 EXCPS------------------7
REC-DELETED------------0 SPLITS-CA--------------0 EXTENTS----------------1
REC-INSERTED-----------0 FREESPACE-%CI---------10 SYSTEM-TIMESTAMP:
REC-UPDATED------------0 FREESPACE-%CA---------10 X'BBEDBD78F4026C40'
REC-RETRIEVED---------12 FREESPC-----------192512
ALLOCATION
SPACE-TYPE---------TRACK HI-A-RBA----------196608
SPACE-PRI--------------4 HI-U-RBA-----------98304
SPACE-SEC--------------2
VOLUME
VOLSER------------TSO923 PHYREC-SIZE---------4096 HI-A-RBA----------196608 EXTENT-NUMBER----------1
1IDCAMS SYSTEM SERVICES TIME: 10:31:56 10/07/04 PAGE 2
0 DEVTYPE------X'3010200F' PHYRECS/TRK-----------12 HI-U-RBA-----------98304 EXTENT-TYPE--------X'40'
VOLFLAG------------PRIME TRACKS/CA--------------2
EXTENTS:
LOW-CCHH-----X'00230006' LOW-RBA----------------0 TRACKS-----------------4
HIGH-CCHH----X'00230009' HIGH-RBA----------196607
0 INDEX ------ COG.KRIS.TEST.INDEX
IN-CAT --- ICFCAT.VTSO001
HISTORY
DATASET-OWNER-----(NULL) CREATION--------2004.280
RELEASE----------------2 EXPIRATION------0000.000
PROTECTION-PSWD-----(NULL) RACF----------------(NO)
ASSOCIATIONS
CLUSTER--COG.KRIS.TEST
ATTRIBUTES
KEYLEN-----------------2 AVGLRECL---------------0 BUFSPACE---------------0 CISIZE--------------1536
RKP--------------------0 MAXLRECL------------1529 EXCPEXIT----------(NULL) CI/CA-----------------26
SHROPTNS(2,3) RECOVERY UNIQUE NOERASE NOWRITECHK NOIMBED NOREPLICAT UNORDERED
REUSE
STATISTICS
REC-TOTAL--------------1 SPLITS-CI--------------0 EXCPS------------------6 INDEX:
REC-DELETED------------0 SPLITS-CA--------------0 EXTENTS----------------1 LEVELS-----------------1
REC-INSERTED-----------0 FREESPACE-%CI----------0 SYSTEM-TIMESTAMP: ENTRIES/SECT-----------4
REC-UPDATED------------0 FREESPACE-%CA----------0 X'BBEDBD78F4026C40' SEQ-SET-RBA------------0
REC-RETRIEVED----------0 FREESPC------------38400 HI-LEVEL-RBA-----------0
ALLOCATION
SPACE-TYPE---------TRACK HI-A-RBA-----------39936
SPACE-PRI--------------1 HI-U-RBA------------1536
SPACE-SEC--------------0
VOLUME
VOLSER------------TSO923 PHYREC-SIZE---------1536 HI-A-RBA-----------39936 EXTENT-NUMBER----------1
DEVTYPE------X'3010200F' PHYRECS/TRK-----------26 HI-U-RBA------------1536 EXTENT-TYPE--------X'00'
VOLFLAG------------PRIME TRACKS/CA--------------1
EXTENTS:
LOW-CCHH-----X'0009000E' LOW-RBA----------------0 TRACKS-----------------1
HIGH-CCHH----X'0009000E' HIGH-RBA-----------39935
1IDCAMS SYSTEM SERVICES TIME: 10:31:56 10/07/04 PAGE 3
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
0IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 0
0
0IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 0
|
_________________
Thanks |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12368
Topics: 75
Location: San Jose
|
| Posted: Fri Oct 15, 2004 11:00 am Post subject: |
|
|
Sarangadhar,
From your listcat a SPACE-TYPE of TRACK means that the size of a DATA CA is 1 track. A typical dasd 3390 will accommodate 10 * 4096 CIs per track or 10 CA per track
No: of records per CI = CI size / max lrecl = 4096/ 10 = 409
10% freespace of CI = 4096 - 409 = 3686 which will accomodate 368 records
10% freespace of CA = 10 - 1 = 9 loadable CI's
The HI-A-RBA is 196608 which converts to 5 tracks ( 196608/(4096 * 10))
The HI-U-RBA is 98304 which converts to 2 tracks ( 98304 /(4096 * 10))
The freespace is 192512 which accounts for (192512/4096 = 47 loadable CI's)
Which means you can load 368 * 47 = 17,296 records.
Hope this helps...
Cheers
kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Sarangadhar
Beginner
Joined: 14 Oct 2004
Posts: 130
Topics: 43
Location: virtual village
|
| Posted: Fri Oct 15, 2004 12:12 pm Post subject: |
|
|
Kosulu,
But form the file Aid I can see this info:
Current Allocations in Tracks:
Allocated space: 4
Allocated extents: 1
Current Utilization in Tracks:
Used data space: 1 ( 25 %)
Used extents: 1 ( 100 %)
Prime records: 4
Then how 17,296 records can be loaded? Can you please clarify.
_________________
Thanks |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12368
Topics: 75
Location: San Jose
|
| Posted: Fri Oct 15, 2004 1:31 pm Post subject: |
|
|
Sarangadhar,
Look at the FREESPC parameter in attributes listing. You have 192512 bytes of free space.
Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Sarangadhar
Beginner
Joined: 14 Oct 2004
Posts: 130
Topics: 43
Location: virtual village
|
| Posted: Fri Oct 15, 2004 2:45 pm Post subject: |
|
|
That's OK, but how FileAid is showing 25% used space for 4 records And 17000 records can be accommodated in 75% space. Does it allocate more extents upto 250 whenever meeded? I fo please gimme details, I like know how it is allocating?
Can all the VSAM files go upto 4GB or upto 250 extents regardless of allocation at the time of creation?
_________________
Thanks |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12368
Topics: 75
Location: San Jose
|
| Posted: Fri Oct 15, 2004 3:06 pm Post subject: |
|
|
Sarangadhar,
| Quote: |
Does it allocate more extents upto 250 whenever meeded? I fo please gimme details, I like know how it is allocating?
|
SMS Managed VSAM clusters can acquire up to 123 extents. Multivolume VSAM data sets can now have a maximum of 255 extents across volumes for each component, but no more than 123 extents per volume.
| Quote: |
Can all the VSAM files go upto 4GB or upto 250 extents regardless of allocation at the time of creation?
|
Standard VSAM files have a 4GB(4,294,967,295) limit . If you need more then you need to create the cluster with extended attributes. If your shop is sms managed then you can use the DATACLASS(EXTENDR) parameter on the definiton of the vsam cluster.
I would strongly recommend you read this excellent Manual
http://www.redbooks.ibm.com/abstracts/sg246105.html
Hope this helps...
Cheers
Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
