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

What is the diffrence between VSAM and DATABASE


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts What database does Jobtrac use CA Products 4
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts CVDA value for RRDS VSAM dataset. CICS 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
Search our Forums:

Back to Top