Usually, which is more important for DB2 system

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

(Continued from previous question...)

Usually, which is more important for DB2 system performance

Q;Usually, which is more important for DB2 system performance - CPU processing or I/O access ?

An:
I/O operations are usually most critical for DB2 performance (or any other database for that matter ).

(Continued on next question...)

Other Job Interview Questions

• What are the various locking levels available ?
• What do you mean by NOT NULL WITH DEFUALT? When will you use it ?
• What is an access path?
• What is RUNSTATS?
• What is the maximum number of tables that can be stored on a Partitioned Tables Space?
• When one binds a PACKAGE of a plan what package information is stored and where it is stored?
• DB2 What is the difference between a package and a plan ?
• If I have a view which is a join of two or more tables, can this view be updatable?
• What is a root page?
• How are write I/Os from the buffer pool executed
• More...