What is Call attach facility? How does it work?
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.
| Is This Answer Correct ? | 5 Yes | 2 No |
What is a Resource Control Table(RCT)? Describe its characteristics.
What is database reorganization?
how to identify the pseudo conversation by seeing the program
When Can you be sure that a query will return only one row?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How to find the number of rows in a db2 table?
What is a predicate?
What is Reorg Recovery? when will you run it?
What is deadlock in db2?
How does the processing of a correlated subquery differ from a non correlated subquery?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
How to fetch the uncommited data from table ?