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 |
Can you Average the Characters ?
What is package versioning? Please give an example.
What is database alias db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Can I use LOCK TABLE on a view?
select 100 records from million records ?
What are the contents of dclgen?
What are the disadvantages of PAGE level lock?
What is a db2 collection?
When is the access path determined for dynamic SQL?
where can we use index and subscript ? with example ?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?