Hello,
I would like to know, if it is possible, to monitor the performance of a DB2 database with the command line interpreter. We are running SAP on DB2 under UNIX and we aren´t able to use the transaction DBACOCKPIT. With that transaction we would be able to have a look at things like backup, performance and so on. There is the only way to monitor things within UNIX.

It is important that we are able to monitor the following things.
- what is the status of the logfiles? Are there problems?
- is the status of the tablespaces ok or do they reach their limit?
- what about the performance? is everything running fine?

So I found out the following commands to gather information about the status:
-db2 list backup history all for <DBSID> ->are the backups ok?
-list tablespaces show detail -> to get an overview about the capacities of the TS
- examine the file db2diag.log -> to find out what errors happened.

Does anyone know more commands to acknowledge that the db is running fine?

Thanks for your replies.

Kind regards
docholiday

Check out DB2 Health Monitor in the manual.

If you want to see some real-time Information from the DB2, you should have a look at db2top-Command. (It can also be used for performance-monitoring.)