DB2 Performance Statistics

DB2 Performance Statistics

 

  

Hi fellow DB2 DBA's,

I was asked to run a complete stat on DB2 performance...
Free space on tablespaces, record counts, most accessed tables during the day... etc. (ALL). :)

We don't use any utilities besides IBM's.

I talked to a coleague who told me that i could put TRACE ON for a day and then analyse the data with DB2 PM (performance monitor).

I'm not sure that I have DB2 PM installed on OS/390.

How can I know if i have my PM installed?


Or else, what options do you give me to make that kind of statistics?


Thank you,

Pedro Gonçalves.

DB2 & UDB email list listserv db2-l LazyDBA home page