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

DB2 database size - what is normal?

Questions
Tags
Users
Badges
Alex Mulholland
(71●21●11) 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.

0 votes

4 answers
5,099 views
0 votes

4 answers

Permanent link
Matt Lavin
FORUM MODERATOR / JAZZ DEVELOPER (2.7k●2) Mar 30 '09, 4:33 p.m.
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.

0 votes

Permanent link
Alex Mulholland
(71●21●11) 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?

0 votes

Permanent link
Rafik Jaouani
JAZZ DEVELOPER (5.0k●1●6) Mar 30 '09, 8:02 p.m.
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.

0 votes

Permanent link
Alex Mulholland
(71●21●11) 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.

0 votes

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

Question asked: Mar 30 '09, 2:55 p.m.

Question was seen: 5,099 times

Last updated: Mar 30 '09, 2:55 p.m.

Confirmation Cancel Confirm