|
View previous topic :: View next topic
|
| Author |
Message |
viplavmodi36
New User
Joined: 12 Feb 2018
Posts: 2
Location: India
|
|
|
|
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 - 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 |
|
 |
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
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 |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| 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 |
|
|
viplavmodi36
New User
Joined: 12 Feb 2018
Posts: 2
Location: India
|
|
|
|
| Thanks a lot everyone for your responses. I really appreciate it. |
|
| Back to top |
|
|
|
|
