Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
A couple of Interview Questions on Cobol-DB2 program

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

New User


Joined: 12 Feb 2018
Posts: 2
Location: India

PostPosted: Fri Feb 23, 2018 6:21 pm    Post subject: A couple of Interview Questions on Cobol-DB2 program
Reply with quote

Hi Everyone,

Please find below some of the interview questions that I came across recently and my answers to those questions -

a) There are 3 Cobol-Db2 programs A,B and C. A is statically calling B and B is dynamically calling C. If I have made some changes to the program C than what all things I need to take care of ?
Ans -> As 'C' is dynamically linked I think only C needs to be recompiled and rebound. I hope this correct.

I have seen a similar post - http://ibmmainframes.com/about49875.html where the discussion is about 2 programs but the problem explained under this post is slightly different than mine.

b) There are two independent Db2 programs 'A' and 'B'. They are sharing two packages which are part of the same package list. Basically, the DBRM of 'A' and 'B' are in separate package(which is obvious) and both the packages belong to same collection and this collection is bound to a plan.
Now, I have made some changes to 'B', do I need to rebind 'A' as well or not ?
Ans - > Rebind of 'A' is required.

c) I have a COBOL-DB2 program which I am running in multiple regions. I am testing the same program in multiple regions (for instance - Test, UAT and Production region). Basically qualifier is different in different regions.
The question is how I will run the same program in different regions or where I will mention the qualifier ?

Ans - In the bind parameter card but I am not very sure about this.

Please let me know your views on this.
Back to top
View user's profile Send private message

daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 714
Location: Pennsylvania

PostPosted: Fri Feb 23, 2018 8:20 pm    Post subject:
Reply with quote

You did pretty well. Two out of three ain't bad.

A) Correct.

B) Incorrect. Program A does not need to be rebound. This package has not changed.
This is the purpose of the collection design.

c) Correct. The Bind card has the Qualifier pointing to your 'region'.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10541
Location: italy

PostPosted: Fri Feb 23, 2018 10:02 pm    Post subject:
Reply with quote

c) Correct. The Bind card has the Qualifier pointing to your 'region'.

almost correct ...
the qualifier IIRC does not have to be the same as the region
all depends on the standards used

the TS will have also have to connect for the bind to the proper DB2 instance
( guess that region means instance )
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 714
Location: Pennsylvania

PostPosted: Fri Feb 23, 2018 10:11 pm    Post subject:
Reply with quote

Enrico,

This is why 'region' is in quotes. It really has no meaning as far as DB2 goes.

The connect you refer to is the DB2 Subsystem.

The qualifier parameter used during the bind, really refers to a schema (subset of tables with a like qualifier).

'Region' is often used in place of schema. Perhaps a carry over from cics.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10541
Location: italy

PostPosted: Fri Feb 23, 2018 10:17 pm    Post subject: Reply to: A couple of Interview Questions on Cobol-DB2 program
Reply with quote

Quote:
The connect you refer to is the DB2 Subsystem.


yes but region all over the forums is usually a misnomer for the "environment"
production, certification, test, unit test, ..., ...
and sometimes even a LPAR

certainly there is lots of confusion in most of the TS heads about proper naming of things
( most found, submit a job to a certain region )
Back to top
View user's profile Send private message
viplavmodi36

New User


Joined: 12 Feb 2018
Posts: 2
Location: India

PostPosted: Sun Feb 25, 2018 3:48 pm    Post subject:
Reply with quote

Thanks a lot everyone for your responses. I really appreciate it.
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 CICS program with Delay question MSTP CICS 2 Tue Dec 11, 2018 11:18 pm
No new posts COBOL D2 program execution without us... dipsybaby DB2 3 Mon Dec 10, 2018 2:08 pm
No new posts calling java code(on mainframe from c... elixir1986 COBOL Programming 1 Fri Nov 30, 2018 1:57 am
No new posts COBOL file declaration jithinraghavan COBOL Programming 2 Fri Nov 16, 2018 10:54 pm
No new posts Accessing control blocks to retrieve ... menonkiran COBOL Programming 5 Wed Nov 14, 2018 9:08 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us