Answer / sunil1405

CICS attachment facility is used to communicate between
CICS and DB2 interface.

Answer / senthil

There are Other attachement Facilities

CAF - Call Attachment Facility
RRSAF - Recoverable Resource Servcie Attachement Facility

Answer / s

Attachment facility provides an interface between DB2 with
other environments like IMS,CICS,TSO.
CICS,IMS,TSO,CAF are attachement facilities.

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

What do you mean by between and in? Is between inclusive of specified range values?

1 Answers  

---

What is cursor stability in db2?

1 Answers  

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1 Answers   MCN Solutions,

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1 Answers  

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

What is a db2 table?

1 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What are the functions in DB2?

3 Answers   Satyam,

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---