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
 

 

can you say VSAM as a database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
charu arora

New User


Joined: 30 May 2006
Posts: 13
Location: bangalore

PostPosted: Fri Jun 02, 2006 4:50 pm    Post subject: can you say VSAM as a database
Reply with quote

In CSC they have asked that can you say that VSAM is database.If yes than is it like DBMS.

Please Advise

Charu
Back to top
View user's profile Send private message

balajiofcrrcoe

New User


Joined: 07 Jul 2005
Posts: 41
Location: chennai

PostPosted: Fri Jun 02, 2006 8:02 pm    Post subject: Re: can you say VSAM as a database
Reply with quote

i think we can call it as database.
Back to top
View user's profile Send private message
sand
Warnings : 1

New User


Joined: 20 Nov 2005
Posts: 19

PostPosted: Mon Jul 10, 2006 4:18 am    Post subject:
Reply with quote

VSAM is not a DBMS.
As it doesn't inherit features of DBMS.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Mon Jul 10, 2006 11:34 am    Post subject:
Reply with quote

VSAM is not a DBMS. You can read about the features of DBMS here.

By the way - DB2, which is a DBMS, is underlying on VSAM.

O.
Back to top
View user's profile Send private message
sand
Warnings : 1

New User


Joined: 20 Nov 2005
Posts: 19

PostPosted: Tue Jul 11, 2006 3:58 pm    Post subject:
Reply with quote

VSAM is a database but it is not DBMS.

ofer71 you just tell me does it support physical data independence????

If u dont know then tell me I'll give u the answer....
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Tue Jul 11, 2006 4:40 pm    Post subject:
Reply with quote

Well, I'm not an expert, but it looks like DB2 supports physical data independence, as opposed to VSAM.

You may read more about Data Independence here.

O.
Back to top
View user's profile Send private message
bright_skull

New User


Joined: 22 May 2006
Posts: 7
Location: Bangalore

PostPosted: Mon Jul 17, 2006 8:59 pm    Post subject: VSAM as a DB
Reply with quote


Yes,

VSAM files are used to support the Database, but it doesn't have DBMS. Even IMS Database is having VSAM underneath it.
Back to top
View user's profile Send private message
Muthukumar.PLindia

New User


Joined: 03 Jul 2006
Posts: 51
Location: Chennai

PostPosted: Tue Jul 18, 2006 8:59 pm    Post subject:
Reply with quote

Data in DB2 Mainframes will be finally dposited at VSAm only.. Every table spaces were stored in a Data file of a VSAm.....

It can be said as a Data store.....

However we cannot say it as a DBMS.. as it is not at all poessing any Databse concepts, like schema, constraints.. and many basic DBMS properties..
Correct me if i am wrong...
Back to top
View user's profile Send private message
bharath_raok
Currently Banned

New User


Joined: 13 Jul 2006
Posts: 0
Location: bangalore

PostPosted: Thu Jul 20, 2006 5:25 pm    Post subject: Re: can you say VSAM as a database
Reply with quote

Yes Obviously it is finaly a VSAM. Because the storage group is a ESDS ie a entry sequenced data base.
Back to top
View user's profile Send private message
parikshit123

Active User


Joined: 01 Jul 2005
Posts: 269
Location: India

PostPosted: Thu Jul 20, 2006 5:33 pm    Post subject:
Reply with quote

Hi Bharath,

I think, DB2 stores data in LDS ( One of the VSAM dataset types) and not in ESDS.

As per a very crude definition of databse(given by C.J. Date, an author and researcher at IBM), "Database systems OR DBMS are simply an electronic record keeping system" , so, looking at this very high level definition, I would go ahead and say that VSAM is a DBMS .
DBMS - Database management system.
Yes, I think it allows data to be managed isn't it?

But, here is a catch, VSAM is not a RDBMS. It doesn't follow most of the Codd's golden rules.

I would say, VSAM is a core component of operating system MVS which has an interface in userland through a utility program called IDCAMS.

Thanks,
Parikshit.
Back to top
View user's profile Send private message
Muthukumar.PLindia

New User


Joined: 03 Jul 2006
Posts: 51
Location: Chennai

PostPosted: Fri Jul 21, 2006 7:25 pm    Post subject:
Reply with quote

yes... I find it in my tablespaces are stored finally in a LDS
Back to top
View user's profile Send private message
rischith

New User


Joined: 24 Feb 2006
Posts: 9
Location: bangalore

PostPosted: Fri Jul 21, 2006 7:33 pm    Post subject: Re:can you say VSAM as a database
Reply with quote

Muthukumar.PLindia wrote:
yes... I find it in my tablespaces are stored finally in a LDS


Hi Muthu,

How to find that? ie tablespaces stored in a LDS?
Back to top
View user's profile Send private message
Muthukumar.PLindia

New User


Joined: 03 Jul 2006
Posts: 51
Location: Chennai

PostPosted: Fri Jul 21, 2006 9:28 pm    Post subject: Re: can you say VSAM as a database
Reply with quote

hi rischith,
We have a tool in our shop (BMC viewer), to know about the meta data and physical data locations of the Database objects. IN that i take a Db, and inturn Table spaces of it, then i find the Dataset which holds the data for it....using the options provided.....

IF you have any such tools to see the table details, database details then u can try with the options provided, Then u would come to KNow...
Back to top
View user's profile Send private message
Aditya Bhardwaj
Warnings : 1

New User


Joined: 02 Nov 2004
Posts: 18
Location: Noida, India

PostPosted: Sat Jul 22, 2006 9:08 pm    Post subject: Re: can you say VSAM as a database
Reply with quote

Hi all,

VSAM is not at all a Database. However it give freedon to manage the data and use it's own storage area to manipulate it accordingly, but it never has the relativity feature i.e. you can not link it with any other Table/File and can not have relations as what we can have in DBMS with Primary and Foreign keys.

Thus VSAM is a File, however we many of the times say it Table for our convenience.

Please correct me if i am wrong.

- Aditya.
Back to top
View user's profile Send private message
rischith

New User


Joined: 24 Feb 2006
Posts: 9
Location: bangalore

PostPosted: Mon Jul 24, 2006 6:32 pm    Post subject: Re: can you say VSAM as a database
Reply with quote

Muthukumar.PLindia wrote:
hi rischith,
We have a tool in our shop (BMC viewer), to know about the meta data and physical data locations of the Database objects. IN that i take a Db, and inturn Table spaces of it, then i find the Dataset which holds the data for it....using the options provided.....

IF you have any such tools to see the table details, database details then u can try with the options provided, Then u would come to KNow...



Thanks for info Muthu........
Back to top
View user's profile Send private message
mfguruintraining

New User


Joined: 26 Sep 2006
Posts: 8

PostPosted: Sat Sep 30, 2006 6:47 pm    Post subject: VSAM
Reply with quote

According to the strict definition of a database : "A database is a logically related collection of coherent data"

In that sense VSAM is a database ... however according to CODD's rules it is not a relational database

Hope this helps

Cheers icon_biggrin.gif
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 -> Mainframe Interview Questions 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