Monitor DB2 obsługuje bieżącą kontrolę ważnych informacji systemowych. W dowolnym momencie można uzyskać podsumowanie statusu systemu, wprowadzając komendę GET SNAPSHOT. Użytkownik może uzyskać obrazy z monitora jeśli ma uprawnienie SYSMAINT, SYSCTRL lub SYSADM do instancji menedżer baz danych, którą chce monitorować.
Jest pięć komend tworzenia obrazów, które są użyteczne do monitorowania informacji DCS. Są to:
Każda komenda tworzenia obrazu powoduje utworzenie szczegółowego raportu dotyczącego żądanego obszaru.
Na przykład wprowadzenie komendy GET SNAPSHOT FOR DCS DATABASE ON DCSDB spowoduje utworzenie następującego raportu:
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
Raport ten udostępnia informacje na temat połączeń bazy danych, wydajności, błędów i przepustowości żądań SQL. Obrazy z monitora DB2 mogą być w rzeczywistości o wiele bardziej szczegółowe. Na przykład jeśli zostanie wydana komenda GET SNAPSHOT FOR ALL DCS APPLICATIONS, to uzyskany raport będzie podobny do następującego:
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)
Więcej informacji na temat komendy GET SNAPSHOT i innych przydatnych komend monitora DB2 można znaleźć w podręczniku System Monitor Guide and Reference.