QM_USER.REPOSITORY_ITEM_STATES table growth
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
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
Comments
Paul Ellis
JAZZ DEVELOPER Nov 05 '13, 10:59 a.m.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?