Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Is there any option for VSAM file to free the space .

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
nkreddy5

New User


Joined: 06 May 2008
Posts: 7
Location: BANGALORE

PostPosted: Thu Nov 13, 2008 1:28 am    Post subject: Is there any option for VSAM file to free the space .
Reply with quote

in idcams step..my input file has 2 gb records..so my output file is vsam file which has cataloged in production with 4 gb space..is there any parameter can we code to free the space after idcams utility run as it will occupy only 2 gb space,rest 2 gb space will be empty..

in normal files we can give rlse or free but vsam i dont know..can you please help me to get thi info if above scenario is poossible.

Thanks,
Karthik
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7932
Location: Bellevue, IA

PostPosted: Thu Nov 13, 2008 1:38 am    Post subject:
Reply with quote

Why is the file created with 4 GB of space if you're only using 2 GB? Change the IDCAMS DEFINE would be my first choice, although there's a lot to be understood still -- could the file have been defined as 4 GB to allow for expansion? What's the usage pattern (read only after load, inserts throughout the file, inserts only at the end)? What does the LISTCAT look like? Is there free space specified?

In general, unless you unload, delete, define, and reload the VSAM file you're not going to decrease the space used. Once a VSAM file is defined, it may get bigger but you can't make it get smaller without redefining it.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Thu Nov 13, 2008 2:45 am    Post subject: Reply to: Is there any option for VSAM file to free the spa
Reply with quote

what is the usage pattern for the dataset ??
when defining a dataset there are many things to be taken into account
but the most important for vsam at least is the insert pattern,
and the distribution of the keys
there are insert key patterns that cause a ci split almost at every insert

but then even with lots of inserts with clustered keys it is sometimes better
to defines the ci free space percentage as 0

the first insert of a group of keys will cause a CI split and for a while there will be no more CI splits,

lots od dasd space can be saved in this way
but the issue must be closely watched and tuned
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Nov 17, 2008 3:01 pm    Post subject:
Reply with quote

VSAM extended facilites allows for the release of allocated and unused space.

Please speak nicely to your storage people to help you
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fail to change physical VSAM filename... jacobdng CICS 5 Fri Jan 20, 2017 12:36 pm
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us