What is meant by the attachment facility?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is meant by the attachment facility?

The attachment facility is an interface between DB2 and TSO, IMS/VS, CICS, or batch address spaces. It allows application programs to access DB2.

(Continued on next question...)

Other Job Interview Questions

• How many Buffer pools are there in DB2 and what are they ?
• What are the three DB2 date and time data types and their associated functions?
• Can you access the DB2 Directory table using SQL?
• What is a DB2 bind?
• What is subselect? Is it different from a nested select ?
• What is the self-referencing constraint ?
• What is SQLcode - 811?
• If the base table underlying a view is restructured ...
• What are the three lock types?
• When is the results table for the query in a DECLARE CURSOR statement created ?
• More...