DB2 モニターは、有用なシステム情報を絶えず記録しています。 GET SNAPSHOT コマンドを発行すれば、システム状況の要約情報をいつでも入手できます。 モニター・スナップショットは、モニターしたいデータベース・マネージャーのインスタンスに対して SYSMAINT、 SYSCTRL、SYSADM のいずれかの権限があればとることができます。
DCS 情報をモニターするのに役立つスナップショット・コマンドは 5 つあります。 それらのコマンドは以下のとおりです。
スナップショット・コマンドは要求した領域に関する詳細なレポートを生成します。
たとえば、GET SNAPSHOT FOR DCS DATABASE ON DCSDB を発行すると、以下に示すレポートが生成されます。
DCS Database Snapshot DCS database name = DCSDB Host database name = GILROY First database connect timestamp = 12-15-1999 10:28:24.596495 Most recent elapsed time to connect = 0.950561 Most recent elapsed connection duration = 0.000000 Host response time (sec.ms) = 0.000000 Last reset timestamp = Number of SQL statements attempted = 2 Commit statements attempted = 1 Rollback statements attempted = 0 Failed statement operations = 0 Total number of gateway connections = 1 Current number of gateway connections = 1 Gateway conn. waiting for host reply = 0 Gateway conn. waiting for client request = 1 Gateway communication errors to host = 0 Timestamp of last communication error = None High water mark for gateway connections = 1 Rows selected = 0 Outbound bytes sent = 140 Outbound bytes received = 103
このレポートは、データベース接続、パフォーマンス、SQL 要求のエラーやスループットなどに関する情報を提供します。 しかし実際には、DB2 モニター・スナップショットにはさらに多くの詳細情報が含まれています。 たとえば、GET SNAPSHOT FOR ALL DCS APPLICATIONS コマンドを発行すると、 以下のようなレポートが表示されます。
DCS Application Snapshot Client application ID = 09150F74.B6A4.991215152824 Sequence number = 0001 Authorization ID = SMITH Application name = db2bp Application handle = 1 Application status = waiting for request Status change time = 12-15-1999 10:29:06.707086 Client node = sys143 Client release level = SQL06010 Client platform = AIX Client protocol = TCP/IP Client codepage = 850 Process ID of client application = 49074 Client login ID = smith Host application ID = G9150F74.B6A5.991215152825 Sequence number = 0000 Database alias at the gateway = MVSDB DCS database name = DCSDB Host database name = GILROY Host release level = DSN05012 Host CCSID = 500 Outbound communication address = 9.21.21.92 5021 Outbound communication protocol = TCP/IP Inbound communication address = 9.21.15.116 46756 First database connect timestamp = 12-15-1999 10:28:24.596495 Host response time (sec.ms) = 0.000000 Time spent on gateway processing = 0.000000 Last reset timestamp = Rows selected = 0 Number of SQL statements attempted = 2 Failed statement operations = 0 Commit statements = 1 Rollback statements = 0 Inbound bytes received = 404 Outbound bytes sent = 140 Outbound bytes received = 103 Inbound bytes sent = 287 Number of open cursors = 0 Application idle time = 1 minute and 32 seconds UOW completion status = Previous UOW completion timestamp = 12-15-1999 10:28:25.592631 UOW start timestamp = 12-15-1999 10:29:06.142790 UOW stop timestamp = Elapsed time of last completed uow (sec.ms)= 0.034396 Most recent operation = Execute Immediate Most recent operation start timestamp = 12-15-1999 10:29:06.142790 Most recent operation stop timestamp = 12-15-1999 10:29:06.707053 Statement = Execute Immediate Section number = 203 Application creator = NULLID Package name = SQLC2C07 SQL compiler cost estimate in timerons = 0 SQL compiler cardinality estimate = 0 Statement start timestamp = 12-15-1999 10:29:06.142790 Statement stop timestamp = 12-15-1999 10:29:06.707053 Host response time (sec.ms) = 1.101612 Elapsed time of last completed stmt(sec.ms)= 0.564263 Rows fetched = 0 Time spent on gateway processing = 0.013367 Inbound bytes received for statement = 220 Outbound bytes sent for statement = 130 Outbound bytes received for statement = 49 Inbound bytes sent for statement = 27 SQL statement text: create table t12 (col1 int, col2 char)
GET SNAPSHOT コマンドとその他の役立つ DB2 モニター・コマンドについて詳しくは、 システム・モニター 手引きおよび解説書 を参照してください。