Collecting ETM repository size metrics in order to monitor growth

On this page, we provide information on how you can monitor the growth of the data in the repository for the Engineering Test Management (ETM) application using MBeans. Although we will be presenting some information that is ETM specific, most of the information applies to other ELM applications as well.

The ELM MBeans are covered on the release related guides available on the page Reference Guides for ELM JMX MBeans. Each guide has a link a zip archive containing an html page that describes the common MBeans provided by Foundation. For 7.1, the link to this document is Common application MBeans (requires file download). The com.ibm.team.foundation.itemcounts MBean described in this document can be used to track the space used by various item types on the database. Over time, this MBean can be used to monitor the growth of the database.

Item Count Details

The com.ibm.team.foundation.itemcounts MBean provides information about each type of item in the repository and their counts in terms of number of states and the overall size of these items in relation to the total size. This is useful to understand the data growth in the system and also the breakdown between the different types of items. Sometimes items like attachments or build results may be growing at an alarming rate and tracking this metric can explain the reason for this growth. Added to this, increase in DB size during a period can also be explained by the items that were added during this period.

Note: This MBean is applicable for EWM, ETM, and DOORS Next.

Serviceability Property

To enable this MBean:

• Go to the Servicability admin page (<server-url>/admin#action=com.ibm.team.repository.admin.serviceability)
• Enable this bean by setting Enable Item Count Metrics Mbean to true
  • Member of ItemCountMetricsCollectorTask property group

Default Frequency of Publishing

The default frequency of publishing is 1 Week (604800 second) but this can be modified in the Serviceability section

Object Name

Here is a list of the objects available from the item counts MBean for the main ETM items.

• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.execution.ExecutionElementResult
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.execution.ExecutionResult
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.execution.ExecutionResultGroup
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.execution.TestcaseExecutionRecord
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.execution.TestSuiteExecutionRecord
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.Attachment
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.ExecutionElement2
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.ManualExecutionScript
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.ManualExecutionScriptStepLookup
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.TestCase
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.TestPlan
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.TestSuite
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.VersionedExecutionScript
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.VersionedTestCase
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.VersionedTestPlan
• com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.VersionedTestSuite

Attributes

The following screenshots show the attributes available for com.ibm.team.foundation.itemcounts:name=qm,type=itemCountMetrics,typeName=com.ibm.rqm.planning.TestCase

The main attributes of interest are:

• itemTypeName - This is the name of the item type
• noOfStates - This is total number of states that exists in the REPOSITORY.ITEM_STATES system table for this item type
• statesSize - This is total size of all the states that exists in the REPOSITORY.ITEM_STATES system table for this item type in bytes
• noOfContents - This is total number of content blobs that exists in the REPOSITORY.CONTENT_STORAGE system table for this item type
• contentsSize - This is total size of content blobs that exists in the REPOSITORY.CONTENT_STORAGE system table for this item type in bytes
• sizePercentage - This is percentage of the total size of this item type in relation to the total size of all item types together
• totalSize - This is sum of all the content objects and state objects for this item type in bytes
• totalAllSize - This is sum of all the content objects and state objects for all item types in bytes

Use Repodebug to see MBean

To use repodebug to view the output of the bean, go to

• <server-url>/repodebug/mxBeans
• From the Domain dropdown choose: com.ibm.team.foundation.itemcounts
• From the Type dropdown choose: ItemTypeMetrics
• Click the Search button.

This will show a list of all available objects where each object is associated with a different item type. You can choose an object to see the metrics for the corresponding item type.

Related topics: JMX Application MBeans Reference Guide for ELM 7.1

• Collecting data related metrics using JMX MBeans