Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to meassure the project size in storage

Questions
Tags
Users
Badges
Felipe Hernandez
(30●3●11●16) Aug 26 '13, 8:06 p.m.
 Hi all,

I would like to know if there is a way to meassure the size of a project, how much is it taking from the database and check if there is a way to compress it so it doesn't take much space.

Regards,
Felipe.

0 votes

3 answers
8,352 views
0 votes

Accepted answer

Permanent link
Krzysztof Kaźmierczyk
(7.5k●4●80●103) Oct 11 '13, 2:45 a.m.
Hi Feilipe,
Maybye I will have a luck to help you :)
We can check which objects are using the most space in your database:
I believe that it was already similar quesiton on jazz.net forum.
https://jazz.net/forum/questions/21799/how-do-i-find-out-database-info-such-as-size-etc
and
https://jazz.net/forum/questions/111357/how-to-check-which-tables-are-using-the-most-space

Please run the report from the second link and provide us the output. It might be helpful for you.
Felipe Hernandez selected this answer as the correct answer

0 votes

Comments
Felipe Hernandez
Oct 14 '13, 7:50 p.m.
Hi Krzysztof, Here is the digested result of the report

Krzysztof Kaźmierczyk
Oct 15 '13, 2:58 a.m.
Hi Felipe, I would expect the report having more lines. Is it entire report page? Or only part of it? Did you have to wait for a long time for loading it?

Felipe Hernandez
Oct 16 '13, 2:27 p.m.
 Is only part of it, and I didn't have to wait long for it, only a couple of minutes to have the information. I only left the lines where there was a lot of usage.

2 other answers

Permanent link
ankur sharma
JAZZ DEVELOPER (662●1●22●28) Aug 27 '13, 3:01 a.m.
 There are a bunch of repository and datawarehouse metrics report shipped with CLM server. These reports will help you estimate the size of the repository based on different parameters.

This link will help you with how to deploy them
https://jazz.net/wiki/bin/view/Main/HowToDeployBIRTReportTemplates#Deploying_New_Reports

0 votes

Permanent link
Georg Kellner
(840●5●82●110) Aug 27 '13, 7:47 a.m.
There is a predefined report called "Latest Repository Metrics"

This has to be applied to each project area and will print out the current space statistics.

greetings georg.

0 votes

Comments
Felipe Hernandez
Oct 13 '13, 5:24 p.m.
 Hi thanks for the response but I haven't been able to find those report, where I can find them? I'm new to the tool so if you could point me to the instructions I'll be really grateful. Regards, Felipe.

Jia Jia Li
Oct 13 '13, 5:26 p.m.
I think ankur has give the useful link contains "How to deploy the report template" Setup the Rich Client (see above). Right-click on the  Report Templates  folder. Select  Deploy New Templates... . In the  Select a Project Area or Team Area  dialog, select the root node which is the target project area. In the  Report Templates To Deploy  dialog, check all the BIRT report templates you want to deploy. Select normal-sized parent report templates if you want to view the report in the Reports Web UI (e.g.  Execution Status using Weight ). Select the micro-sized child report templates ( Micro* ) if you want to view the report in a viewlet on Dashboards (e.g.  Micro Execution Status using Weight ). Click "OK". Repeat the process for each target project area.

1 vote

Felipe Hernandez
Oct 13 '13, 5:24 p.m.
 Ok so I finally was able to Activate the reports that you recommended Execution Status using Weight and Micro Execution Status using Weight but these reports talk about the weight given on the tests and no the actual size of the project in the database, which is what I'm looking for. So thanks for your input but I still need a way to figure out why my database went from 6 gb to almost 33 gb and which project is taking the more space. Regards, Felipe.

Georg Kellner
Oct 14 '13, 5:58 a.m.
Have you seen the "Latest Repository Metrics" report/template?

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,622

Question asked: Aug 26 '13, 8:06 p.m.

Question was seen: 8,352 times

Last updated: Oct 16 '13, 2:27 p.m.

Confirmation Cancel Confirm