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 difference between alias and synonym in db2?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
Can a Db2 table data be retrived through JCL?
How to design maps
Can we able to find all the Table names under a Particular Plan?
What is meant by the attachment facility?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is iseries database?
What is copy book?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?