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 FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 0 Mon Sep 18, 2017 4:31 pm
No new posts Julian Date to CICS ABSTTIME blayek CICS 3 Wed Aug 30, 2017 11:15 pm
No new posts Need to track the CICS transaction fr... sam8051 CICS 3 Mon Aug 07, 2017 3:11 pm
No new posts How to Clear all TSQs during CICS sta... Hooman24 CICS 10 Mon Jun 26, 2017 9:46 pm
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm

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