IBM Support

Table snapshot command and table operations

Question & Answer


Question

What kind of operations are reported by a table snapshot command when the table monitor switch is turned off?

Answer

Table snapshot command (get snapshot for tables on dbname) will report all the table operations EXCEPT for a rows_read even if the table switch is off i.e select requires table monitor switch to be turned on, however the insert, update, delete operations doesn't need the table monitor switch to be enabled. So, with table monitor switch enabled, when you run a select on a table, the snapshot command will list the table and its details whereas the table is not listed when the table monitor switch is turned off.

Reference:


rows_read - Rows read monitor element

The number of rows read from the table.

Snapshot Level Logical Data Grouping Monitor Switch
TableTableTable
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.mon.doc/doc/r0001317.html

rows_written doesn't require the table switch to be turned on. Notice Monitor Switch is Basic.

rows_written: Rows Written monitor element

This is the number of rows changed (inserted, deleted or updated) in the table.

Snapshot Level Logical Data Grouping Monitor Switch
TableTableBasic

http://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.mon.doc/doc/r0001316.html

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Performance - Snapshot monitor","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;11.1;9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21986520

Page Feedback