What is the function of the Data Manager?

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

(Continued from previous question...)

What is the function of the Data Manager?

The Data Manager is a DB2 component that manager the physical databases. It invokes other system components, as necessary, to perform detail function such as locking, logging, and physical I/O operations ( such as search, retrieval, update, and index maintenance).

(Continued on next question...)

Other Job Interview Questions

• What is the best lock size that you could use when you create a tablespace?
• What can the Locate option of the Repair Utility accomplish?
• Can we declare DB2 HOST variable in COBOL COPY book ?
• Explain the use of the WHERE clause?
• What will the COMMIT accomplish?
• What is a clustered index?
• Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2
• What is a DB2 bind?
• I need to view the number of tables existing under one particular OWNER. ?
• Explain what a plan?
• More...