没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
DB2TOP(1) User Manuals DB2TOP(1)
NAME
db2top − DB2 performance monitor
SYNOPSIS
db2top [−d dbname] [−n nodename] [−u username] [−p pass-
word] [−V schema] [−i interval] [−P <partition> ] [−b
option] [−a] [−k] [−R] [−x] [−f file </pattern> <+offset>
] [−C] [−m duration] [−o outfile]
db2top [−H host ] [−N port ] [−h]
DESCRIPTION
db2top is a monitor for DB2 UDB specifically designed for
DPF environments. It provides a unified, ’single system
view’ of a multi−partition DB2 database that can be used
to quickly identify either partition−specific or global
problems in the system.
The user interface is character−based and built using the
curses library and is similar in nature to many UNIX moni-
toring utilities.
db2top uses the DB2 snapshot monitoring APIs to retrieve
data. It uses both global as well as partition−specific
monitoring information to provide aggregation as well as
quick drill−down capabilities.
It can be run interactively or in batch mode. Main fea-
tures can be selected by an interactive command or by
specifying the option in the personal or system−wide con-
figuration file. See below .db2toprc for more information.
COMMAND OPTIONS
−n specifies the node to attach to.
−d specifies the database to monitor.
−u specifies the DB2 username used to access the database.
−p specifies the DB2 password.
−V specifies the default schema used in explains.
−i specifies the delay between screen updates.
−k specifies whether to display actual or delta values.
−R Reset snapshot at startup.
−P <number>. Snapshot issued on current or partition num-
ber.
−x specifies whether to display additionnal counters on
session snd appl creens (might run slower on session).
−b tells db2top to run in background mode.
−a specifies only active queries will be displayed.
−C Runs db2top in snapshot collector mode, raw snapshot
data is saved in <db2snap−<Machine>.bin>.
−f <file> </pattern> <+offset>. Run db2top in replay mode
when snapshot data has been previously collected in
<file>. offset will jump to a certain point in time in the
file. It can be expressed in seconds (+10s), minutes
(+10m) or hours (+10h). /pattern will analyse file and
display at which offset matches appear. pattern can speci-
fied as regular expression.
−m Will limit duration of db2top in minutes for −b and −C.
−o <outfile>. Outfile for −b option.
−h short help.
When using the −b option, db2top will display information
in CSV format. db2top can be run in background mode in
combination with reading snapshot data from collection
Oct 07, 05 2:16 Page 1/6db2top
file, in this case, use the −f <file> option. Valid sub−
options are :
d : database
l : sessions
t : tablespaces
b : bufferpools
T : Tables
D : Dynamic SQL
s : Statements
U : Locks
Interactive commands
d Goto database screen.
l Goto sessions screen.
a Goto application details for agent (or restrict on
agent on statement screen). db2top will prompt for
the agent−id.
G Toggle between all partitions and current partitions.
P Select db partition on which to issue snapshot.
t Goto tablespaces screen.
T Goto tables screen.
b Goto bufferpools screen.
D Goto the dynamic SQL screen.
m Display memory pools.
s Goto the statements screen.
U Goto the locks screen.
p Goto the partitions screen.
H Goto the history screen (experimental).
f Freeze screen.
W Watch mode for agent_id, os_user, db_user, applica-
tion or netname. Statements returned by the session
snapshot (option l) will be written to agent.sql,
os_user−agent.sql, db_user−agent.sql, application−
agent.sql or netname−agent.sql. When issued from the
dynamic SQL screen (option D), statements will be
written to db2adv.sql in a format compatible with
db2advis.
/ Enter expression to filter data. /fession must con-
form to regular expression. Each function (screen)
can be filtered differently. regexp check is applyied
to the whole row.
<|> Move to left or right of screen.
z|Z Sort on ascending or descending order.
c This option allows to change the order of the columns
displayed on the screen. The syntax is in the form:
1,2,3,... where 1,2,3 correspond respectively to the
1st, 2nd and 3rd columns displayed. These are the
column numbers to use when specifying a sort crite-
Oct 07, 05 2:16 Page 2/6db2top
Printed by
Friday October 07, 2005 1/3db2top
资源评论
- yuppie112014-04-21入门级别的快收藏
- eliceladygg2013-03-21挺好的资料,很全面
- a051202302015-12-27新手宝典 非常实用
huiyzou
- 粉丝: 1
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功