It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,876

question asked: Aug 14 '08, 11:57 p.m.
question was seen: 4,718 times
last updated: Aug 14 '08, 11:57 p.m.

Related questions

Server question: how to get a larger DB2 table size

0
Tom Frauenhofer (1.3k●5●84●35) | asked Aug 14 '08, 11:57 p.m.
Hi

What's the correct way to increase the size of the DB2 tables used by
Jazz ??

In teamserver.properties, the attribute
"com.ibm.team.repository.db.db2.content.tablespace.numpages" defines the
size of the DB2 tablespace but I had understood that its value can't be
altered after the table is created.

Do I need to export and re-import the data to increase the size ?

Cheers

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Matt Lavin (2.7k●2) | answered Aug 15 '08, 7:59 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
You are right about the
"com.ibm.team.repository.db.db2.content.tablespace.numpages" property.
That is used only for the initial creation of the tablespace.

You can change the size of the tablespace after the initial creation by
using the DB2 commands to increase the size. You should be able to
administer the Jazz DB just as you would another DB2 database. Here is
some documentation about how to resize the tablespace in DB2:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0012277.htm

One option is to turn on the tablespace auto-resize function, which can
be enabled through the DB2 command

ALTER TABLESPACE CONTENTTS AUTORESIZE YES

Matt Lavin
Jazz Server Team


David Ward wrote:
Hi

What's the correct way to increase the size of the DB2 tables used by
Jazz ??

In teamserver.properties, the attribute
"com.ibm.team.repository.db.db2.content.tablespace.numpages" defines the
size of the DB2 tablespace but I had understood that its value can't be
altered after the table is created.

Do I need to export and re-import the data to increase the size ?

Cheers
0
permanent link
Tom Frauenhofer (1.3k●5●84●35) | answered Aug 15 '08, 8:03 a.m.
Got it Thanks Matt

Matt Lavin wrote:
You are right about the
"com.ibm.team.repository.db.db2.content.tablespace.numpages" property.
That is used only for the initial creation of the tablespace.

You can change the size of the tablespace after the initial creation by
using the DB2 commands to increase the size. You should be able to
administer the Jazz DB just as you would another DB2 database. Here is
some documentation about how to resize the tablespace in DB2:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0012277.htm


One option is to turn on the tablespace auto-resize function, which can
be enabled through the DB2 command

ALTER TABLESPACE CONTENTTS AUTORESIZE YES

Matt Lavin
Jazz Server Team


David Ward wrote:
Hi

What's the correct way to increase the size of the DB2 tables used by
Jazz ??

In teamserver.properties, the attribute
"com.ibm.team.repository.db.db2.content.tablespace.numpages" defines
the size of the DB2 tablespace but I had understood that its value
can't be altered after the table is created.

Do I need to export and re-import the data to increase the size ?

Cheers

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.