Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009

    Unanswered: Performance Monitoring under UNIX with CLP

    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

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Check out DB2 Health Monitor in the manual.
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2010
    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.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts