What is Call attach facility? How does it work?
- 1 Answers
- 11909 Views
- Syntel, I also Faced
- E-Mail Answers
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
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What are foreign keys in db2?
Explain various types of locks in db2?
What is nvl in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How would you find out the total number of rows in a db2 table?
How to check last update on table in db2?
What is null indicator in cobol db2?
What is a bind card?
What are host variables in db2?
What is ibm db2 client?
How can we retrieve the total number of records in RPG & CLLE?
What is the physical storage length of date data type?
can all users have the privilage to use the sql statement select * (dml)?
