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
 

 

How VSAM differs from DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
k_s_ashok

New User


Joined: 22 Apr 2006
Posts: 1

PostPosted: Sat Apr 22, 2006 11:07 am    Post subject: How VSAM differs from DB2
Reply with quote

How VSAM differs from DB2. Normally VSAM holds the data from the DB2.
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Fri Apr 28, 2006 10:02 am    Post subject: Re: VSAM Vs DB2
Reply with quote

VSAM is a File Management System(FMS) and DB2 is a Data Base Management System(DBMS). So you can enlist all the difference between VSAM & DB2 on the basis of that concept.

FMS doesn't know generally the record lay-out, hence any attempt to fetch data based on specific conditions of record structure couldn't be successful. Like get all STUDENTS with MARKS > 85

Again there are security concerns with the FMS too.

You can check out all the characteristics of a DBMS, and it'll make a clear difference than FMS.

Regards,
Priyesh.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm


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