Which DB2 command is used to retireve environmen

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

(Continued from previous question...)

Which DB2 command is used to retireve environmental information?

The DISPLAY command can return the following environmental data: DATABASE info, RLIMIT info, THREAD info, TRACE info, and UTILITY info.

(Continued on next question...)

Other Job Interview Questions

• MAX number of columns in a DB2 table
• What is a clustering index ?
• What is a clustering index ?
• What does it mean if the null indicator has -1, 0, -2??
• How does DB2 determine what lock-size to use?
• What is the difference between SYNONYM and ALLAS?
• What should be specified along with a cursor in order to continue updating process after commit ?
• DB2 can implement a join in three ways using a merge join...
• How does DDB2 use multiple table indexes ?
• What happens to the PLAN if index used by it is dropped?
• More...