Discovering DB2 Access Using the Explain Plan Table

While reviewing a clients’ DB2 performance issues, we researched the SQL that was being executed against a table on a daily basis by analyzing the DB2 access methods with the plan table. The DB2 access methods are captured at compile and bind time through the explain process. Its output is available in the plan table. . . . → Read More: Discovering DB2 Access Using the Explain Plan Table