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

How to write new records into a VSAM?


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

New User


Joined: 13 Apr 2007
Posts: 59
Location: Chennai

PostPosted: Fri Jun 22, 2007 4:05 pm
Reply with quote

Hi,

I have a VSAM which has already got records in it. I want to add new records into it. Is it possible to increase the space available without droppping it and creating a new one?

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

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Fri Jun 22, 2007 4:11 pm
Reply with quote

Reni,

Quote:
I want to add new records into it.


What are you trying to do? Appending the records at end or loading records in the new vsam?

Quote:
Is it possible to increase the space available without droppping it and creating a new one?

How much space is available in the vsam? Has it completly occupied allocated space?
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Fri Jun 22, 2007 4:24 pm
Reply with quote

Run IDCAMS with LISTCAT and study the results. Check secundary allocations (16 reached?) and the CI- and CA-splits. Make sure you have enough FREESPACE when defining your clusters.
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Fri Jun 22, 2007 5:03 pm
Reply with quote

VSAM can use 123 extents per volume, assuming that you have them specified. And multiple volumes, again only if specified. I think that with z/OS 1.7 and above that the number of extents may be elevated to 255.

CI & CA splits ............ These will affect the data distribution of the file, but depending on the RAID version in use, may or may not affect performance. But that's another story.

FREESPACE, again its effectiveness depends on the RAID technology that your DASD is using.

But, as suggested run LISTCAT and find out everything you ever need to know about your VSAM cluster.

Is this an ESDS or KSDS ?
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 Write line by line from two files DFSORT/ICETOOL 7
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
Search our Forums:

Back to Top