Server question: how to get a larger DB2 table size
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
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
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:
"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
Got it Thanks Matt
Matt Lavin wrote:
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