Determining metrics for specific application?

[jsquizz]

got a requirement from our application team to figure out-

Application XYZ, which is part of AG 123, takes up XXX GB in TSM.

Does anyone have a query handy, or something to determine this. I have a feeling it will require some fancy footwork behind the scenes to do this.

[Justin Derrick]

By AG, this is relatively straightforward.  By Application...  This is a nightmare.  :D

-JD.

[jsquizz]

By AG, this is relatively straightforward.  By Application...  This is a nightmare.  :D

-JD.

If this was AG, it would have already been done.

I'm probably going to take a dump of ALL 87's from the system log for a particular application load, throw it into excel...

Then look at log entries for "deletes", throw them into excel...

I've found it quite easy to gather metrics and info this way. It sure beats having to have my operations team run queries in prod, especially since I'm the only one that knows the relationships of the tables.