It's all about the answers!

Ask a question

How to check which tables are using the most space.


0
3
Krzysztof Kaźmierczyk (7.4k34693) | asked Apr 29 '13, 10:38 a.m.
edited Aug 07 '15, 3:41 a.m.
There are sometimes problems with huge size of RQM (or another products database).
Any idea how we can find which exactly objects are using the most space?

4 answers



permanent link
Krzysztof Kaźmierczyk (7.4k34693) | answered Apr 29 '13, 10:40 a.m.
edited Jan 28 '14, 10:24 a.m.
I found the solution for CLM 4.0:

1. go to
https://server:port/qm/service/com.ibm.team.repository.service.ITeamServerStatusContentService/
2. click link
"com.ibm.team.repository.migration.internal.stats.IDBTableSizeHttpService"
Note: Don't go to #2 directly or you'll get a permission denied error.

This takes a little bit, but generates a great table summary of all
artifacts and sizes.

For CLM 3.x there is an internal tablesizes tool which can be fetched by request in the PMR.

Please notice that this tool displays estimated values only and is rather designed to initial review. For more accurate information you need to use SQL queries as Piotr mentioned.

Comments
Rosa Naranjo commented Jul 22 '16, 5:22 p.m. | edited Sep 23 '16, 10:11 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

You need to have JazzAdmin permissions to execute these requests.


Rosa Naranjo commented Sep 23 '16, 9:34 a.m. | edited Sep 23 '16, 10:09 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

This command works for all three applications. Just change the context root from qm to cm or rm. The context root should match your own deployment.


permanent link
Piotr Aniola (3.6k1534) | answered Apr 29 '13, 10:41 a.m.

For Oracle: http://www.dba-oracle.com/t_script_oracle_table_size.htm
For DB2: http://database.ittoolbox.com/groups/technical-functional/db2-l/how-to-calculate-the-table-size-in-db2-1691545
MSSQL: http://stackoverflow.com/questions/7892334/get-size-of-all-tables-in-database

Comments
Krzysztof Kaźmierczyk commented Apr 29 '13, 10:43 a.m.

Thanks Piotr for your answer. Anyway I like my answer more than yours :-)


permanent link
Erik Mats (105523) | answered May 13 '16, 7:04 a.m.
I like both your answers, thank you!

The IDBTableSizeHttpService is easy to invoke over HTTPS via the web UI, BUT I think by "Content Size" column does not report table size, rather something else. Attachment/blob size maybe.

For model.workitem this will report 0 regardless how many work items there are. (In my sandbox right now my workitem table is actual size 6KB but this reports 0. I also checked my customer's repository with tens of thousands of work items. Content Size = 0 there too.)

I like the idea of capturing this on the DB server because that makes it easy to automate.

permanent link
Donn Anderson (12) | answered Oct 21 '16, 3:46 p.m.
HI,
I know this is an old thread - but I found the information very useful (and it still works on v6).

Does anyone have any knowledge of how long it takes the IDBTableSizeHttpService to update?  I had a customer delete a lot of information in build results - the table size and item counts have not decreased yet.

Your answer


Register or to post your answer.