It's all about the answers!

Ask a question

DB2 database size - what is normal?


Alex Mulholland (712111) | asked Mar 30 '09, 2:55 p.m.
Hi,
We have a growing RTC installation with about 50 users, 2 projects, 8 streams, and about 6 months of history. I noticed our DB2 backups getting pretty large and just want to sanity check that we're not doing something daft. Our DB2 database is now approaching 6GB - is this reasonable? Anyone else seeing this sort of size?
Thanks, Alex.

4 answers



permanent link
Matt Lavin (2.7k2) | answered Mar 30 '09, 4:33 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
I believe the size of the Jazz.net database is approximately 30G when
exported to a .tar file (using repotools export). The Jazz team has
been contributing source / workitems to jazz.net for 2-3+ years.

-
Matt Lavin
Jazz Server Team


On Mon, 2009-03-30 at 18:57 +0000, amulholl wrote:
Hi,
We have a growing RTC installation with about 50 users, 2 projects, 8
streams, and about 6 months of history. I noticed our DB2 backups
getting pretty large and just want to sanity check that we're not
doing something daft. Our DB2 database is now approaching 6GB - is
this reasonable? Anyone else seeing this sort of size?
Thanks, Alex.

permanent link
Alex Mulholland (712111) | answered Mar 30 '09, 6:08 p.m.
Hmm thanks Matt, maybe we're in the right ballpark then. Is there any sort of 'hygiene' that should be done to minimize DB size?

permanent link
Rafik Jaouani (5.0k16) | answered Mar 30 '09, 8:02 p.m.
JAZZ DEVELOPER
Can you please use the Report named Latest Metrics under the reports Repository folder. This report will give a breakdown of where the storage is being used.

The Data Warehouse Metrics report will tell you much storage the data warehouse is using.

permanent link
Alex Mulholland (712111) | answered Mar 30 '09, 9:22 p.m.
Thanks for the pointer - my project has no reports (perhaps because just using 'simple team process'?) and I'm getting a permissions error when I try to add in the Data Matrics template - I'll play for a while and see if I can make it work.

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.