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

can you say VSAM as a database


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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
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
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: 2359
Location: Israel

PostPosted: Mon Jul 10, 2006 11:34 am
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
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: 2359
Location: Israel

PostPosted: Tue Jul 11, 2006 4:40 pm
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
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
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
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
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
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
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Change history of vsam file. JCL & VSAM 3
No new posts DASD - non SMS - volser change - VSAM... JCL & VSAM 2
No new posts writing into VSAM indexed tabl in PL1... PL/I & Assembler 8
No new posts vsam file access JCL & VSAM 12
No new posts Products/Tools to Optimize Adabas Dat... Compuware & Other Tools 2
Search our Forums:

Back to Top