DB2, OS/390

Is there a utility I can run which will list tables & columns accessed by program name?

Thanks in anticipation.

If you rebind all the plans/packages with Explain = Yes, you can query the plan_table to find out which programs access which tables. This will work with statically bound plans/packages (embedded SQL) and not ad-hoc queries or dynamically prepared SQL statements. But you can manually explain ad-hoc queries with the SQL statement EXPLAIN if you know what the SQL statements are.

Also, the plan_table will only tell you the tables and not the columns, although you can create a statement table as part of the explain process. See the "Administration Guide" or "Application Programming and SQL Guide".

You could also query the DB2 catalog to associate plans, tables, and statements.