db2性能监控.ppt

Snapshot Monitor: Taking snapshots Start ofMonitoring Event Specific Cumulative Event Specific Cumulative GET SNAPSHOT FOR DATABASE MANAGER DBM ALL DATABASES ALL APPLICATIONS ALL BUFFERPOOLS APPLICATION FCM FOR ALL NODES LOCKS FOR APPLICATION APPLID AGENTID appl-id agentid ALL DATABASE DB APPLICATIONS TABLES TABLESPACES LOCKS BUFFERPOOLS DYNAMIC SQL appl-id database-alias ON WRITE TO FILE Bufferpool 快照KPI Snapshot管理视图 $ DB2 LIST TABLES FOR SCHEMA SYSIBMADM SNAPDBM SNAPDB SNAPTBSP SNAPAPPL, SNAPAPPL_INFO SNAPTAB SNAPDYN_SQL SNAPBP SNAPCONTAINER SNAPLOCK … db2top介绍 监控思路 db2 get snapshot for database on xxdb snapdb.out db2 get snapshot for tablespaces on xxdb snaptbs.out db2 get snapshot for tables on xxdb snaptab.out db2 get snapshot for dynamic sql on xxdb snapsql.out Snapshot的问题 会锁db2 engine，造成db2 Hang。 db2pd 获取db2实例或数据库的统计信息 提供有用信息用于诊断和问题定位，性能提升和应用开发设计： Locks / bufferpools / table spaces / containers / dynamic SQL statements / agents / applications / memory pools and sets / transactions / logs / ... 收集数据时不需要加任何锁，不需要获取任何引擎资源。轻量级的诊断工具 使用db2pd 分析锁使用情况 可以通过db2pd联合几个选项进行监控，一次执行可以获得几个报告，使得分析更容易。 You may want to: Determine transaction IDs with object locks Determine Application IDs for the suspect transaction View Application information on the lock holder db2pd –db sample –lock –trans –appl –dynamic Event Monitor （事件监控器） MAXFILESIZE 1024 (4 KB) MAXFILES 3 CREATE EVENT MONITOR WRITE TO TABLE FOR event-monitor-name MANUALSTART AUTOSTART Example file structure /evmon1 directory Event Monitor turned OFF after 3 files generatedevt 4 MB first file in streamevt 4 MBevt 4 MB second file in stream third file in stream table options event type PIPE pipename FILE file options path-name Output of events: Table File Named pipe 过滤 Event Monitor 结果 Creator can specify filters using WHERE clause Example: CREATE EVENT MONITOR georgepay FOR STATEMENTSWHERE APPL_NAME = ‘PAYROLL’ AND AUTH_ID = ‘GEORGE’WRITE TO FILE ‘/monitors/georgepay’MAXFI