It's all about the answers!

Ask a question

How can I find QM repository size in CLM 502 or 603?


0
1
Wayne Hanson (6124) | asked Aug 17 '17, 5:55 p.m.

How can I find out what the physical size of a Quality Management repository is in CLM 502 or 603?


Comments
Wayne Hanson commented Aug 21 '17, 9:02 a.m.

I should have been more clear. I already have the size of the QM database. I would like to find the size of a particular Quality Management repository within the QM database. 


Kevin Ramer commented Aug 22 '17, 4:12 p.m.

There is only 1 QM repository in a QM database.  


Wayne Hanson commented Aug 23 '17, 9:04 a.m.

Forgive me for I am using the incorrect terminology.  How do I find out the size of a project within the QM database?

One answer



permanent link
Sunil Kumar R (1.1k13344) | answered Aug 21 '17, 8:36 a.m.
JAZZ DEVELOPER

Hi Wayne, most easiest way to get the size of QM repository is as follows..
DB2 - run query db2 "call get_dbsize_info(?,?,?,-1)"
SQL Server - run query exec sp_spaceused
Oracle - Is a bit different, each application data is saved in separate "table spaces" rather than database as in case of DB2, MS SQL server.
Here is one post explaining how to get size of tablespace in Oracle

One more way to get the database size without using any of the database tools is as follows.

1. Go to page below:
https://yourRQMServer:port/qm/service/com.ibm.team.repository.migration.internal.stats.IDBTableSizeHttpService/
2. Add all non-zero values under column "Content Size (K)"
The end result is the size of RQM database in KB.

Hope this helps!

Best Regards
Sunil

Your answer


Register or to post 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.