IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

A couple of Interview Questions on Cobol-DB2 program


IBM Mainframe Forums -> Interview Questions
Post new topic   Reply to topic
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
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 - Use [URL] BBCode for Links 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: 746
Location: Pennsylvania

PostPosted: Fri Feb 23, 2018 8:20 pm
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: 10697
Location: italy

PostPosted: Fri Feb 23, 2018 10:02 pm
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: 746
Location: Pennsylvania

PostPosted: Fri Feb 23, 2018 10:11 pm
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: 10697
Location: italy

PostPosted: Fri Feb 23, 2018 10:17 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Interview Questions

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts COBOL Performance Tuning COBOL Programming 6
No new posts JCL for replacing code in Cobol JCL & VSAM 8
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
This topic is locked: you cannot edit posts or make replies. Sample CICS Webservices Program CICS 1
No new posts XML Parsing in COBOL creating "h... COBOL Programming 0

Back to Top