What is a Resource Control Table(RCT)? Describe its
characteristics.
Answers were Sorted based on User's Feedback
Answer / s
CICS RCT defines the connection between CICS and DB2.
| Is This Answer Correct ? | 18 Yes | 3 No |
Answer / nag(igate)
All db2 plans should be registered in the RCT
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / guest
RST defines the relationship between the CICS transaction
and DB2 plans.
| Is This Answer Correct ? | 6 Yes | 2 No |
What are the full forms of spufi and dclgen and why are they used?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is a predicate?
What is Skeleton cursor table (SKCT)?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Once you create a view, where would information about the view be stored?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What are the levels of isolation available with DB2V4
How to run db2 command in windows?
how can we find nth max salary from A table
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is bind plan?