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

Vsam space allocated and usage percent


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
quanzhong

New User


Joined: 12 Aug 2008
Posts: 46
Location: china

PostPosted: Tue Sep 23, 2008 8:20 am
Reply with quote

Hi,
now i met a problem on PRD enviroment on VSAM.
Code:
 
                       Tracks %Used XT  Devi
 AAAA.S1.KE           78000    ?  67  3390
 AAAA.S1.KE.D           202    ?  55  3390
 AAAA.S1.KE.I         20190   99  21  3390


space parameter is
Code:

cyl(50   50)

as its allocated space is close 90K Tracks(because its managed by DATACLASS(VSSML),which limits file size not over 90K tracks), so we suggest to change its DATACLASS, but client said that file only used 35% allocated space.

so my doubt is, how to get the usage percentage? if what he said is true, how to release the allocated but unused space.. thanks.

Ps. we have file-aid tool in our shop.
Back to top
View user's profile Send private message
quanzhong

New User


Joined: 12 Aug 2008
Posts: 46
Location: china

PostPosted: Tue Sep 23, 2008 8:29 am
Reply with quote

sorry,
Quote:


Tracks %Used XT Devi
AAAA.S1.KE 78000 ? 67 3390
AAAA.S1.KE.D 202 ? 55 3390
AAAA.S1.KE.I 20190 99 21 3390

should be changed to
Code:

                                     Tracks %Used XT  Devi
AAAA.S1.KE                                       
AAAA.S1.KE.D                  78000    ?  67  3390
AAAA.S1.KE.I                    202    ?  55  3390

so another question is, when ignore index space parameter, and use jclcheck to check the synax, i will get warning message, and say that lastcc is 12. but in fact, we seldom assign space parameter for index, so how system do that ? thanks..
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Tue Sep 23, 2008 11:28 am
Reply with quote

IDCAMS LISTCAT ALL will show you the high allocated and high used RBA

(Hi used / Hi alloc) * 100 = % used.
Back to top
View user's profile Send private message
quanzhong

New User


Joined: 12 Aug 2008
Posts: 46
Location: china

PostPosted: Tue Sep 23, 2008 12:59 pm
Reply with quote

Hi, expat
the listcat result
Code:

ALLOCATION                                             
  SPACE-TYPE------CYLINDER     HI-A-RBA------3833856000
  SPACE-PRI-------------50     HI-U-RBA------3813212160
  SPACE-SEC-------------50                             

so used is more than 99%

then i reproed this file to another file, and listcat the new file, and found that space allocated is 35% of the origina file..

more listcat result for the original file
Code:

ATTRIBUTES                                                                 
  KEYLEN----------------22     AVGLRECL------------6549     BUFSPACE-------
  RKP--------------------0     MAXLRECL------------6549     EXCPEXIT-------
  SHROPTNS(2,3)      SPEED     UNIQUE           NOERASE     INDEXED       N
  UNORDERED          REUSE     NONSPANNED                                 
STATISTICS                                                                 
  REC-TOTAL---------161487     SPLITS-CI--------------0     EXCPS----------
  REC-DELETED-------107128     SPLITS-CA-----------4786     EXTENTS--------
  REC-INSERTED------233928     FREESPACE-%CI----------0     SYSTEM-TIMESTAM
  REC-UPDATED----------233     FREESPACE-%CA----------0          X'C308FE7F
  REC-RETRIEVED---51091680     FREESPC-------2497085440                   

this file is KSDS, and as you can see, there are frequently deletes and inserts every day, is there any way to release the unused space fragment, split, except delete, re-define, then repro?
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Tue Sep 23, 2008 1:22 pm
Reply with quote

How many extents has it extended to at the moment ?
Back to top
View user's profile Send private message
quanzhong

New User


Joined: 12 Aug 2008
Posts: 46
Location: china

PostPosted: Tue Sep 23, 2008 1:37 pm
Reply with quote

Hi
Code:

EXCPS------------8534497
EXTENTS---------------67
SYSTEM-TIMESTAMP:       
     X'C308FE7F1D2F52C4'

now already 67 extends
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Tue Sep 23, 2008 1:42 pm
Reply with quote

I would consider performing a periodic reorg of the file

Use either EXPORT & IMPORT

or REPRO to flat file, delete / define the cluster, and the REPRO from the flat file back to the cluster.
Back to top
View user's profile Send private message
quanzhong

New User


Joined: 12 Aug 2008
Posts: 46
Location: china

PostPosted: Tue Sep 23, 2008 1:47 pm
Reply with quote

Hi, expat.

Ok, i will try to persude the client. thanks.
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Tue Sep 23, 2008 1:53 pm
Reply with quote

Your cluster has 65% free space in it, but because of the CA splits the free space is spread aound and may become unusuable depending on the position within the file that inserts / deletes occur.

A periodic reorg will recoup the free space and ensure that it is totally usable again until the same situation arises once more.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Tue Sep 23, 2008 4:59 pm
Reply with quote

What's the data CISIZE and the index CISIZE? It's unusual to have so many CA splits without CI splits.
Back to top
View user's profile Send private message
quanzhong

New User


Joined: 12 Aug 2008
Posts: 46
Location: china

PostPosted: Tue Sep 23, 2008 7:56 pm
Reply with quote

Hi, Robert
Quote:

What's the data CISIZE and the index CISIZE? It's unusual to have so many CA splits without CI splits.

it also confused me. we didn't assign CASIZE and CISIZE, it muse be use the default value, bue how can i find out that?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Tue Sep 23, 2008 8:00 pm
Reply with quote

LISTCAT will contain the CISIZEs. Default values are likely to be quite bad for this file.
Back to top
View user's profile Send private message
quanzhong

New User


Joined: 12 Aug 2008
Posts: 46
Location: china

PostPosted: Wed Sep 24, 2008 7:16 am
Reply with quote

Hi, Robert
I got the LISTCAT info about CISIZE and CI/CA.
Code:

ATTRIBUTES                                                 
  KEYLEN----------------22     AVGLRECL------------6549     BUFSPACE-----------17920     CISIZE--------------8192
  RKP--------------------0     MAXLRECL------------6549     EXCPEXIT----------(NULL)     CI/CA-----------------90
  SHROPTNS(2,3)      SPEED     UNIQUE           NOERASE     INDEXED       NOWRITECHK     NOIMBED       NOREPLICAT
  UNORDERED          REUSE     NONSPANNED   
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Wed Sep 24, 2008 5:41 pm
Reply with quote

With CISIZE of 8192, you're wasting 1643 bytes per CI or 20% (ignoring overhead bytes). Setting CISIZE to 26624 would allow half track blocking and reduce the wasted bytes per CI to about 1%. You probably should assign CA freespace to allow for the record inserts, maybe FRSP(0 10)?

78,000 tracks represents 468,000 control intervals which are holding 161,487 records at one per CI. It sounds like a good bit of the free space is in the CA splits, so a frequent unload / delete / define / reload to get rid of the CA splits would also keep the free space at a minimum.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 3
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Allocated cylinders of a dataset DB2 12
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts CVDA value for RRDS VSAM dataset. CICS 2
Search our Forums:

Back to Top