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
 

 

What is the diffrence between VSAM and DATABASE

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

New User


Joined: 28 Feb 2006
Posts: 3

PostPosted: Fri Jun 23, 2006 11:50 am    Post subject: What is the diffrence between VSAM and DATABASE
Reply with quote

Hi,

Is there any query that we can retrieve only duplicate records for the database table.

What is the diffrence between VSAM AND DATABASE? Which one is more advantageous?

Could anyone explain me about RESTART LOGIC?

Regards,
Vamshi.
Back to top
View user's profile Send private message

hadimam
Currently Banned

New User


Joined: 15 Jun 2006
Posts: 10
Location: Bangalore

PostPosted: Fri Jun 23, 2006 3:10 pm    Post subject:
Reply with quote

Hi Vamshi,
if we use the cursor we can fetch the dupliacte records from the table.
2)The VSAM data base is of file concept and the datadase may be table concept,etc
Th data base can store more records into it and the access from the DB is very fast....


If u have any doubts ,please query me.
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Fri Jun 23, 2006 5:27 pm    Post subject: hello vamshi2476
Reply with quote

The vsam is a file concept while u could say the database is a collection of vsam files .obviously databases are more preferable and agin that depends on the volume of data being processed.
but vsam are more cost effective so it is up to the requirement to decide

restart logic is a concept used in IMS where we treat all the files(i/p and o/p) as GSAM DATABASES so that we could take checkpoints easily.

IMS Checkpoint gives us the ability to take a program image and retain its valuable contents which is in working storage so that you can recompile and restart your program execution without loosing any information in case of job abends.The checkpoint
1. Allows restart possibility from the Last commit point.
2. Ensure database /File integrity
3. Records checkpoint data on IMS Log files.

so when a job abends we do not lose any info and we can restart from the last checkpoint.
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 how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am


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