Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 CICS Transaction Timeout Hooman24 CICS 2 Sun Apr 16, 2017 2:16 pm
No new posts The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Asynchronous CICS Processing Question moezbud CICS 1 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us