IBM Support

Monitoring health of MAXIMO DB2 Database/Tables

Technical Blog Post


Abstract

Monitoring health of MAXIMO DB2 Database/Tables

Body

Monitoring health of MAXIMO Database/Tables

In order to perform tuning on maximo database it is important to identify and activities on all OR specific table

in maximo database. This function is available in db2 v9.7 and above.

 

Monitored activities presented by function :

Rows read , inserted,updated ,deleted

Number of Tables can implying need fro Indexes

Hit Ratio - Physical Reads / Logical reads.

Number of Locks Waits and lock Wait Time

No need to turn on the monitor switches.

 

The DB CFG parameter mon_obj_metrics should be set to EXTENDED

Use following command

db2 get db cfg; to identify settings

db2 update DB cfg for <databasename> using mon_obj_metrics=EXTENDED to set.

Ho to use function. Based on scope please use the following examples

SELECT varchar(tabschema,20) as tabschema,

varchar(tabname,20) as tabname,

sum(rows_read) as total_rows_read,

sum(rows_inserted) as total_rows_inserted,

sum(rows_updated) as total_rows_updated,

sum(rows_deleted) as total_rows_deleted

FROM TABLE(MON_GET_TABLE('','',-2)) AS t

GROUP BY tabschema, tabname

ORDER BY total_rows_read DESC                                   for all tables in a database

 

 

SELECT varchar(tabschema,20) as tabschema,

varchar(tabname,20) as tabname,

sum(rows_read) as total_rows_read,

sum(rows_inserted) as total_rows_inserted,

sum(rows_updated) as total_rows_updated,

sum(rows_deleted) as total_rows_deleted

FROM TABLE(MON_GET_TABLE('maximo','workorder',-1)) AS t

GROUP BY tabschema, tabname

ORDER BY total_rows_read DESC                                      for maximo.workorder table.

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11132011