Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum 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: 726
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: 10639
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: 726
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: 10639
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 Reading the CSV data in COBOL and mov... wik123 COBOL Programming 4 Tue Dec 03, 2019 5:13 pm
No new posts Is multiple program names allowed in ... Sakthidevi PL/I & Assembler 1 Tue Nov 19, 2019 11:12 pm
No new posts COBOL -DB2 SQL code to have GROUP BY ... vinu78 DB2 21 Wed Oct 23, 2019 7:00 pm
No new posts Running a REXX exec program using ZOSMF Sakthi344 CLIST & REXX 3 Tue Oct 15, 2019 3:13 pm
No new posts How to handle NULL in COBOL program bhaskar_kanteti COBOL Programming 8 Mon Oct 07, 2019 3:54 pm

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