Answer / mani

Call Attach Facility is used for application programs that
run under batch to establish a connection with db2.It is an
alternative to DSN command processor and provides greater
control over the execution environment.

Programs using CAF can

1)Access DB2 from address spaces where there is no TSO,
CICS, or IMS
2)Access the Instrumentation Facility Interface (IFI)
3)Access DB2 from multiple tasks within an address space
4)Control the connection to DB2 explicitly
5)Connect to DB2 implicitly, using a default subsystem ID
and plan name
6)Receive a signal from DB2 on start-up or shutdown.

The Call Attach Facility is being slowly replaced by the
more powerful RRS (resource recovery services) attachment
facility.

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,

---

What is meant by a unit of recovery?

1 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

What is db2? Explain.

0 Answers  

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

What does the REORG Utility do?

2 Answers  

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

How do you find the maximum value in a column in db2?

0 Answers  

---

What is the use of db2?

0 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

What are leaf pages?

3 Answers  

---