Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Not able to export the VSAM cluster sandeep kumar302 JCL & VSAM 5 Fri May 04, 2018 12:42 pm
No new posts IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 11 Tue Apr 17, 2018 10:42 pm
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts VSAM - Accessing beyond record size Benchwarmer JCL & VSAM 6 Wed Apr 11, 2018 9:20 pm
No new posts VSAM File free space sancraig16 JCL & VSAM 13 Fri Mar 30, 2018 1:02 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us