DB2:getTableSpaceMetrics

List the activity on all tables accessed since the database was activated, aggregated across all database members, ordered by highest number of reads.

Note: This method can be used IF-AND-ONLY-IF you have access and privileges to execute SYSPROC database objects.

Type

SYNC, IMPACT_INFO

Arguments

None.

Returns

Name	Type	Description
Table Space Name	Integer	Table space Name.
Table Space Id	Integer	Table space Identifier.
Table Space Type	String	Table space Type.
Page Size	String	Table space page size.
Extent Size	Big Integer	Table space extent size.
Prefetch Size	Big Integer	Table space prefetch size.
Rebalancer Mode	String	Rebalancer mode and is one of: NO_REBAL, FWD_REBAL, REV_REBAL, FWD_REBAL_OF_2PASS, REV_REBAL_OF_2PASS.
Auto Storage?	Big Integer	Table space enabled for automatic storage or not.
Auto Resize?	Big Integer	Table space automatic resizing enabled or not.
Direct Reads	Big Integer	Direct reads from database.
Direct Writes	Big Integer	Direct writes to database.
BufferPool Physical Reads	Big Integer	Buffer pool data physical reads.
BufferPool XDA Physical Reads	Big Integer	Buffer pool XDA data physical reads.
BufferPool Index Physical Reads	Big Integer	Buffer pool index physical reads.
BufferPool Writes	Big Integer	Buffer pool data writes.
BufferPool XDA Physical Writes	Big Integer	Buffer pool XDA data writes.
BufferPool Index Physical Writes	Big Integer	Buffer pool index writes.
Used Pages	Big Integer	Used pages in table space.
Free Pages	Big Integer	Free pages in table space.
Usable Pages	Big Integer	Usable pages in table space.
Total Pages	Big Integer	Total pages in table space.

Usage Notes

Invoking this method, returns results computed on the basis of all activities performed since the database was first activated.

Did you find this helpful?

Yes No