How To get the column definitions of the DB2 Monitor table functions

02 June,2014 by Tom Collins

Question: How can I get the column definitions  of the DB2  Monitor (MON) table function?

Answer: You can describe the Monitor function tables output by prefixing describe output before the SELECT statement . It will return the column definition. For example,


--return column details of MON_GET_BUFFERPOOL
 db2 "describe output SELECT * FROM TABLE(MON_GET_BUFFERPOOL('',-2))"
---return column details of waits and processing times for a connection
db2 “describe output select r.metric_name, r.parent_metric_name,    r.total_time_value as time, r.count, c.member                                                                                
from table(mon_get_connection_details(125,-2)) as c,                                                
 table(mon_format_xml_times_by_row(c.details)) as r                                             
order by total_time_value desc

Read More

Reorg table DB2

DB2 table reorg and table truncate

DB2 Used Space and REORG




Author: Rambler(


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How To get the column definitions of the DB2 Monitor table functions

Comments are moderated, and will not appear until the author has approved them. | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright