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

What are the advantages and disadvantages of VSAM


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mframes

New User


Joined: 29 Apr 2004
Posts: 8
Location: Chennai(Madras)

PostPosted: Thu Apr 29, 2004 1:38 pm
Reply with quote

what are the advantages and disadvantages of VSAM ?
which other dataset organisation has all the features to override its disadvantages ?
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Thu Apr 29, 2004 3:25 pm
Reply with quote

As compared to what? icon_question.gif
Back to top
View user's profile Send private message
mframes

New User


Joined: 29 Apr 2004
Posts: 8
Location: Chennai(Madras)

PostPosted: Thu Apr 29, 2004 5:06 pm
Reply with quote

superk,
i wanted to know abt the
1.advantages of VSAM over other data management systems ?
2.also advantages of VSAM applications over IMS ,DB2 applications?
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Apr 30, 2004 12:33 am
Reply with quote

Since VSAM is only a storage access method, I can't see how you can make a comparison between it and a data management system such as DB2. You are talking about two entirely different things.

Maybe someone who does storage management and/or database management will have a different point of view.
Back to top
View user's profile Send private message
mframes

New User


Joined: 29 Apr 2004
Posts: 8
Location: Chennai(Madras)

PostPosted: Fri Apr 30, 2004 10:22 am
Reply with quote

superk ,
atleast give me the advantages and disadvantages of VSAM over other access methods ?
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Fri Apr 30, 2004 6:29 pm
Reply with quote

Hello mframes,

Vsam is one coherent file storage system used to store and retrieve data.It is not a database management system like IDMS or DB2.It does not provide for relationships among the data.The existing databases like IMS or DB2 may be implemented using VSAM

If you see the advantages........

VSAM provides protection of data against unauthorized access through password facility
Cross-system (MVS & VSE) compatibility.VSAM datasets can be imported ans exported in MVS and VSE systems.
Also DEVICE Independence(Access via catalog).

Check out this link for some comparison (IAM vs. VSAM)

www.bmc.com/technews/003/IAMvsVSAM.html

hope this helps.

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

New User


Joined: 29 Apr 2004
Posts: 8
Location: Chennai(Madras)

PostPosted: Mon May 03, 2004 11:51 am
Reply with quote

anu,
thanx for the info
Back to top
View user's profile Send private message
prasanth_thavva

New User


Joined: 28 Jul 2005
Posts: 86
Location: Chennai

PostPosted: Thu Sep 08, 2005 11:09 am
Reply with quote

vsam is virtual access storage method its access method to retrieve data and orgnaize data..
db2 data base manage
if u query the table
select * from table;
it first pass control to db2 db2 fetches the data ... gives control to the vsam
vsam fetches the data and returns to db2.. so we dont know the internal accessing ...
interm given access to vsam only
Back to top
View user's profile Send private message
amalli

New User


Joined: 06 Sep 2005
Posts: 17

PostPosted: Thu Sep 08, 2005 12:14 pm
Reply with quote

vsam is virtual access storage method its access method to retrieve data and orgnaize data.
ESDS,KSDS,LDS,RRDS are the datasets of VSAM

dB2 IS RELATIONAL DATABASE MANAGEMENT SYSTEM.
Back to top
View user's profile Send private message
nitin_agr

New User


Joined: 06 Sep 2005
Posts: 28
Location: Minneapolis US

PostPosted: Fri Sep 09, 2005 12:08 am
Reply with quote

Advantages of using VSAM

? One method to support all types of data retrieval (KSDS, ESDS etc.)
? Can be a stand alone file or within a DBMS
? Supports fixed and Variable Records
? One utility, IDCAMS, to manage everything (IEBGENER for seq files, IEBCOPY for PDS, IEBISAM for ISAM files)
? Supports alternate index
? Device Independence (EXPORT and IMPORT)
? Portable across systems
? Modular, catalog contains all the information
? Catalogs are protected by internal security


Disadvantages of VSAM

? Require lot of DASD space
? For KSDS, primary key cannot be changed
? Performance can be slow because of complexity of Index
? Only resides on DISK
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts CVDA value for RRDS VSAM dataset. CICS 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
No new posts Open VSAM File in IMS DC Region - DFS... IMS DB/DC 0
Search our Forums:

Back to Top