How to shrink jazzdata (DB2 jazz database) ?
Normally, RTC user deploy test database and production database. When DB2 is selected as back end database server for Jazz based products, it
create "jazzdata" or "content_tablespace" table space which as 4Gbyte disk size as follows:
2010/12/13 14:44 4,096,000,000 jazzdata
This is just too much for test environment. Also this tablespace looks like DMS. Question is
- Is there any option in repotools-X.bat so that tablespace is created by SMS ?
I'd like to setup this tablespace as SMS so that it just grow as size increase, good enough for just testing.
create "jazzdata" or "content_tablespace" table space which as 4Gbyte disk size as follows:
2010/12/13 14:44 4,096,000,000 jazzdata
This is just too much for test environment. Also this tablespace looks like DMS. Question is
- Is there any option in repotools-X.bat so that tablespace is created by SMS ?
I'd like to setup this tablespace as SMS so that it just grow as size increase, good enough for just testing.
One answer
I am not providing an answer, I am just linking the article https://jazz.net/library/article/1459 Reducing the size of the Rational Team Concert repository database by the original question author Takehiko Amano for others searching for this within the forum.