What is Call attach facility? How does it work?
Answer Posted / 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.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is buffer pool?
What is db2 look?
What is sqlca?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How does a cursor work?
How to view db2 table structure?
What is iseries database?
What are the contents of a dclmgen?
Define predicate?
Is db2 a programming language?
What is view db2?
What is nvl in db2?
What is cursor in dbms?
What is the role of schema in the db2 database?
can all users have the privilage to use the sql statement select * (dml)?