Use the db2top tool to monitor your DB2 database (zt)

Monitor
, Database
, Tools

IBM AlphaWorks provides a db2top Tool To help you monitor your DB2 database in real time . It is more convenient to support partition data. And allows you to monitor session-level applications. The usage is as follows: Download (86.61 KB) 7 minutes ago Usage: db2top [-D dbname] [-N nodename] [-u username] [-P Password] [-V schema] [-I interval] [-P <part>] [-A] [-R] [-K] [-x] [-F file <+ time> </Regexp>] [-B options]-O OUTFILE] [-C] [-M duration] Db2top-H -D: Database Name (default DB2 Dbdft) -N: node name -U: User Name -P: User Password -V: Default explain Schema -I: interval in seconds between snapshots -B: Background Mode Option: D = Database , L = sessions, t = tablespace S, B = bufferpools, t = table S, D = dynamic SQL , S = statements, u = locks -O: output file for background Mode -A: monitor only active objects -R: reset snapshot at startup -K: Display cumulated counters -X: Extended display -P: partition snapshot (number or current) -F: replay monitoring session from snapshot data collector file, can skip entries when + seconds is specified -C: Run db2top in snapshot data collector Mode -M: Max duration in minutes for-B and-C -H: This help At the same time, this tool is similar to IBM's nmon and supports running in the background, allowing you to collect data from the system at regular intervals to help you analyze trends. In addition, there are even some sample scripts in the downloaded db2top package to help you call them in your own scripts. For example: Db2top-D db_name-I 2- Indicates that the interactive mode is used to monitor the active objects of the database every two seconds. Use-B Parameters You can perform regular sampling in the background like nmon and generate the data to a CSV file. And then make a good-looking chart in Excel. Download (43.86 KB) 7 minutes ago Download (84.46 KB) 7 minutes ago Download (36.49 KB) 7 minutes ago

 

 

From http://space.itpub.net/4096/viewspace-52593