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
 
cics db2 interview questions

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

New User


Joined: 18 Apr 2005
Posts: 67

PostPosted: Fri Jun 24, 2005 2:23 pm    Post subject: cics db2 interview questions
Reply with quote

can any body give me the answers asap
1)
when can u say that a query return only one row?
2)
have u worked on performance improvements of sql queries? if yes how do u analyze the performance of the query?
3)
what are the ways ucan release exclusive access acquired over the control intervel during Read Update?
4)
what r the compiler options with which ur cobol programhas to be compiled to use in cics region?
5)
which is the parameter of the DFHFCT macro that is used to translate all lower characters to uppercase for 3270 terminal?
6)which is the aid that willnot be identified in the any key option of the handle aid command?
7)
what facillity connects cics and db2?
8) how to submit a jcl from a cics program?
Back to top
View user's profile Send private message

Gaurav.Virmani

New User


Joined: 23 Jun 2005
Posts: 3

PostPosted: Fri Jun 24, 2005 3:33 pm    Post subject: Answer to Question 7
Reply with quote

According to me there is table in CICS may be RCT which allows CICS to use the Database.
Back to top
View user's profile Send private message
jagadish2005

New User


Joined: 08 Mar 2005
Posts: 20

PostPosted: Sat Jun 25, 2005 8:05 am    Post subject: Re: cics db2 interview questions
Reply with quote

Hi,
1) when can u say that a query return only one row?
ans: use primary key in where clause

6) which is the aid that willnot be identified in the any key option of the handle aid command?
answer : ENTER Key

7) what facillity connects cics and db2?
answer :
A mechanism named the CICS Attach Facility connects CICS with DB2. Using the CICS Attach Facility, you can connect each CICS region to only one DB2 subsystem at a time. You can connect each DB2 subsystem, however, to multiple CICS regions simultaneously. DB2 provides services to CICS via MVS TCBs. Furthermore, the resource control table (RCT) must be configured for each DB2 program that will run under CICS. The RCT applies only to CICS transactions that access DB2 data; it defines the manner in which DB2 resources will be used by CICS transactions. In particular, the RCT defines a plan for each transaction that can access DB2. Additionally, it defines parameters detailing the number and type of threads available for application plans and the DB2 command processor.
I have given answer in detailed way u should understand it

4. what r the compiler options with which ur cobol programhas to be compiled to use in cics region ?
answer: actually whether answer corret / not some have to verify it . For COBOL - CICS program in compiler options u should put y for CICS. Path for TRANSLATOR , PDS path for cics COPY book & RCT details etc

With regards
Arunachalla
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Wed Jun 29, 2005 9:19 am    Post subject:
Reply with quote

rambabu

1) when can u say that a query return only one row?

Ans: When you use PRIMARY Key in where clause

2) have u worked on performance improvements of sql queries? if yes how do u analyze the performance of the query?

Ans: Yes, USE EXPLAIN to see the optimized access path, identify the index columns and use them in where clause

3) what are the ways ucan release exclusive access acquired over the control intervel during Read Update?

Ans: Use Uncommited Read Isolation Parameter

4) what r the compiler options with which ur cobol programhas to be compiled to use in cics region?

Ans:
Compiler Options
VS COBOL: LIB/CLIST/DMAP/OPTIMIZE/SXREF
VS COBOL II: LIB/OFFSET/MAP/OPTIMIZE/XREF/FDUMP/RENT

5) which is the parameter of the DFHFCT macro that is used to translate all lower characters to uppercase for 3270 terminal?

Ans: UCTRAN

6)which is the aid that willnot be identified in the any key option of the handle aid command?

Ans: ENTER Key

7) what facillity connects cics and db2?

Ans: CAF Call Attach Facility

8) how to submit a jcl from a cics program?

Ans: Write the JCL to SPOOL


Hope this helps

Regards
Mayuresh
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 Is CICS BMS logic on z/OS different ... Andi1982 CICS 2 Fri Dec 01, 2017 1:56 pm
No new posts How to get complete URL from CICS Con... mbattu CICS 1 Tue Nov 14, 2017 11:59 pm
No new posts Integrating CICS applications craig2020 CICS 1 Sun Oct 29, 2017 6:49 pm
No new posts ASP3 ABEND IN CICS Vedant CICS 0 Fri Oct 20, 2017 3:18 pm
No new posts Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm

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