IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Performance tuning > Tivoli Data Warehouse > Relational database design and performance tuning for DB2 Database servers > Monitor tools

IBM Tivoli Monitoring, Version 6.3 Fix Pack 2


DB2BATCH

A benchmark tool called DB2BATCH is provided in the sqllib/bin subdirectory of your DB2 installation. This tool can read SQL statements from either a flat file or standard input, dynamically describe and prepare the statements, and return an answer set.

You can specify the level of performance information that is supplied, including the elapsed time, CPU and buffer pool usage, locking, and other statistics collected from the database monitor. If you are timing a set of SQL statements, DB2BATCH also summarizes the performance results and provides both arithmetic and geometric means. For syntax and options, type db2batch.


Parent topic:

Monitor tools

+

Search Tips   |   Advanced Search