What is performance tuning in DB2?

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

(Continued from previous question...)

What is performance tuning in DB2?

The performance of an application can be monitored and enhanced in the application, as well as at the database level. •In application side the SQL’s can be tuned to make them more efficient, and avoid redundancy.
•It is better to structure the SQLs so that they perform only the necessary operations.
•On the database side, the major enhancements can be done to the definitions of tables, indexes and the distribution of tablespace and indexspace.
•The application run statistics are obtained from EXPLAIN or DB2PM (DB2 Performance Monitor) report.

(Continued on next question...)

Other Job Interview Questions

• What techniques are used to retrieve data from more than one table in a single SQL statement?
• How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ?
• What is ACQUIRE/RELEASE in BIND?
• What is the difference between SYNONYM and ALIAS?
• How would you find out the total number of rows in a DB2 table?
• What is REORG? When is it used?
• What is check pending and copy pending status in D...
• How do you do the EXPLAIN of a dynamic SQL statement?
• What is a precompiler?
• What is a clustering index ?
• More...