cics db2 interview questions

rambabu · New User Joined: 18 Apr 2005 Posts: 67

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?

Gaurav.Virmani · New User Joined: 23 Jun 2005 Posts: 3

According to me there is table in CICS may be RCT which allows CICS to use the Database.

jagadish2005 · New User Joined: 08 Mar 2005 Posts: 20

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

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

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