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

VSAM and DB2


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
elixir1986
Warnings : 1

New User


Joined: 10 Nov 2015
Posts: 29
Location: USA

PostPosted: Sat Oct 30, 2021 7:30 am
Reply with quote

Team,

Can a COBOL CICS program access both VSAM and DB2? I was asked in an interview today.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2815
Location: NYC,USA

PostPosted: Sat Oct 30, 2021 5:17 pm
Reply with quote

Yes . Why not?
Back to top
View user's profile Send private message
elixir1986
Warnings : 1

New User


Joined: 10 Nov 2015
Posts: 29
Location: USA

PostPosted: Mon Nov 01, 2021 1:52 am
Reply with quote

Hi Team - May be I did not convey my question correct.

I will rephrase my questions,

1) Can a COBOL CICS program access both VSAM and DB2 simultaneously?

2) How does the SYNCHPOINT & ROLLBACK impact VSAM and DB2 changes in that COBOL CICS program?

Many thanks in advance for all your responses!
Back to top
View user's profile Send private message
Phrzby Phil

Senior Member


Joined: 31 Oct 2006
Posts: 1025
Location: Richmond, Virginia

PostPosted: Mon Nov 01, 2021 7:40 pm
Reply with quote

I see you are still considered a new user but have been on this excellent site for 6 years.

So here is my usual reply to questions like yours.

If you want to become an expert, the go-to-person in your organization, then you cannot expect to learn by asking, but rather by doing.

I recommend you set up a test platform/library/etc., and create skeleton programs/scripts/etc. to test the various questions that will continue to arise during your career.

You will then have documented proof you can rely on and refer others to as to what will happen when you try, in this case:

1) a COBOL CICS program accessing both VSAM and DB2 simultaneously

2) Doing a SYNCHPOINT & ROLLBACK and identifying the impact VSAM and DB2 changes in that COBOL CICS program

It may seem like a lot of trouble at first, but once you've done it, adding new small programs to test this-or-that will be quick, and you'll really know the answer, not just what you think the answer is.

I had a great career as a programmer/analyst - loads of fun and interesting technical challenges.

Good Luck.
Back to top
View user's profile Send private message
elixir1986
Warnings : 1

New User


Joined: 10 Nov 2015
Posts: 29
Location: USA

PostPosted: Tue Nov 02, 2021 4:00 am
Reply with quote

There is no organization to go! I said I was asked in an interview!
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2815
Location: NYC,USA

PostPosted: Tue Nov 02, 2021 7:15 am
Reply with quote

elixir1986 wrote:
Hi Team - May be I did not convey my question correct.

I will rephrase my questions,

1) Can a COBOL CICS program access both VSAM and DB2 simultaneously?

2) How does the SYNCHPOINT & ROLLBACK impact VSAM and DB2 changes in that COBOL CICS program?

Many thanks in advance for all your responses!


It doesn't change the answer regardless if you ask differently. I second Phil, Do test by yourself and nothing can beat that learning.

Besides , Please read manuals to get clear understanding of how it works. Syncpoint and rollback applies to the current unit of work. for e.g. if there is a successful updates to both then syncpoint else rollback everything. Now this gets tricky when you do these updates in called modules and the way you do those calls e.g. START, XCTL, TDQs, MQ triggers etc. .

Moved to Students Section.
Back to top
View user's profile Send private message
sergeyken
Warnings : 2

Senior Member


Joined: 29 Apr 2008
Posts: 1231

PostPosted: Tue Nov 02, 2021 5:27 pm
Reply with quote

elixir1986 wrote:
There is no organization to go! I said I was asked in an interview!

In order to pass any interview, you need to really understand the matter of the subject, while you are trying just to remember the answers to a number of standard questions. Please, do not consider the interview as a sort of quiz, similar to this example:
Quote:
Who was the first President of the United States? Please choose the correct answer:

1) Micky Maus
2) Arnold Schwarzenegger
3) George Washington
4) Jacky Chung

Even after correct answers to 100 of such questions you may not become a Bachelor of Science in History.

Same story, even more serious one, is with your interview for an IT position.
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 Map VSAM Dataset to a Table/Tablespace DB2 5
No new posts Recreating VSAM cluster catalog info ... All Other Mainframe Topics 6
No new posts VSAM file Storage Calculation JCL & VSAM 3
No new posts FILE STATUS - 39 ON VARIABLE LENGTH V... COBOL Programming 2
No new posts VSAM Alter Command - Cylinder Extent ... JCL & VSAM 3
Search our Forums:

Back to Top