QM_USER.REPOSITORY_ITEM_STATES table growth
The QM_USER.REPOSITORY_ITEM_STATES table is growing at approximately 1GB per day. Please can you tell me what the table is used for and whether this growth is normal. Ideally I would like to investigate why the growth is this high but to do that I need to know what the table stores.
Thanks |
One answer
The ITEM_STATES table stores the information needed to make a java object out of the item instance data stored in the database. The table contains a row for each state of each item in the repository.
I do not have statistics for table size and growth in a large system. Growth in the ITEM_STATES table would indicate that lots of items (test cases, test suites, users, project areas, etc) are being created or modified. Hope that helps, Ruby Jazz Foundation L3 Developer |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
I do not want to answer this post as I want others to look at it, but this is very unlikely to be normal. The table contains a row for each state of each item in the repository. I will ask a colleague to answer the question more fully, as I don't want to plagiarise.
When it comes to changes though, what have you changed in the system since this occurred? Did you apply Suspect Links to QM per chance?