What are the different methods of accessing DB2

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

(Continued from previous question...)

What are the different methods of accessing DB2 from TSO?

Q: What are the different methods of accessing DB2 from TSO? How is the connection established between TSO and DB2

An:
There are three ways in establishing TSO/DB2 connection
1. SPUFI
2. QMF
3. CATALOG VISIBILITY B.
A thread between TSO and DB2 is established while attempting to make connection between TSO and DB2.

(Continued on next question...)

Other Job Interview Questions

• What is meant by repeatable read?
• What is Declaration Generator ( DCLGEN )?
• When one binds a PACKAGE of a plan what package information is stored and where it is stored?
• What is a composite index and how does it differ from a multiple index ?
• What is correlation names ?
• How does DDB2 use multiple table indexes ?
• Can ALl Users Have The Privilege To Use The SQL Statement Select * (DML) ?
• What is a data page?
• What is a data page?
• Compare a subselect to a join?
• More...