At a previous site I worked at, we had a DB2 table that we could lookup using Tablename and Column. It would return a plan, package, dbrm (where applicable) and an indicator showing how the column was used (U, D, I, or S).
I have a feeling that there was an in house program (possibly written in REXX by one of the DBAs) that ran overnight and populated this table from the sysibm catalog.
Does anybody know of any utility that is commonly available that performs a similar function? Platform is mainframe, Zos, DB2 v7.
Marc
I have a feeling that there was an in house program (possibly written in REXX by one of the DBAs) that ran overnight and populated this table from the sysibm catalog.
Does anybody know of any utility that is commonly available that performs a similar function? Platform is mainframe, Zos, DB2 v7.
Marc