What is DB2 ( IBM Database 2 )?

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

What is DB2 ( IBM Database 2 )?

DB2 is subsystem of the MVS operating system. It is a Database Management System ( DBMS ) for that operating system.

(Continued on next question...)

Other Job Interview Questions

• Give some example of statistics collected during RUNSTATS?
• What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?
• What is the difference between primary key and unique index?
• What is REORG? When is it used
• What are the disadvantages of PAGE level lock?
• When can an insert of a new primary key value threaten referential integrity ?
• What is a page?
• What is read-only cursor?
• In SPUFI suppose you want to selet maximum of 1000 rows ...
• What is correlated subquery ?
• More...