It's all about the answers!

Ask a question

Any issues using 32767 for the pagesize of the CCM and JAZZ?


Jeff Ong (14113947) | asked May 02 '11, 5:24 p.m.
Would there be any issue if we created the jts and ccm tables using 32767 for their pagesize in DB2 ?

db2 create database JTS on <path> using codeset UTF-8 territory en PAGESIZE 32767


db2 create database CCM on <path> using codeset UTF-8 territory en PAGESIZE 32767

One answer



permanent link
Sean G Wilbur (87222421) | answered Jun 18 '12, 6:08 p.m.
JAZZ DEVELOPER
 No issues, just note that you need to be wary of your teamserver.properties value for com.ibm.team.repository.db.db2.content.tablespace.numpages your initial dbs will be 8GB if you leave the defaults.

# Configure the size of the tablespace to be created, in 4K pages.
# This is a hard limit and will need to be raised for a production database.
# Your DB2 DBA will need to monitor the utilization of the CONTENTS tablespace and grow it as needed.
# Defaulting to 250,000 pages, or 1GB.
#com.ibm.team.repository.db.db2.content.tablespace.numpages=250000

  -Sean

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.