Unable to upgrade Build Forge to 8.0 (from 7.1.3.4-1-0010)
Downloaded bf_8000_0456-full.zip and startet Installation Manager 'Update'.
'Test connection' button at JAS Database Configuration page comes up with:
Unexpected failure:(32): No tablespace of 16KB (16384 bytes) or greater exists. Please adjust your database tablespace or bufferpools and rerun the installer.
With 'db2cc' I was not able to adjust tablespaces or bufferpools.
Any help welcome.
Regards Andreas
6 answers
$ db2 "alter tablespace USERSPACE1 extend (all 8000)"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL20318N Table space "USERSPACE1" of type "AUTOMATIC STORAGE" cannot be altered using the "EXTEND" operation. SQLSTATE=42858
$ db2 "alter tablespace USERSPACE2 extend (all 8000)"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0281N Table space "USERSPACE2" cannot be altered with additional
containers because it is a system managed table space. SQLSTATE=42921
$ db2 ALTER BUFFERPOOL BUFFP1 SIZE 15000
DB20000I The SQL command completed successfully.
So I was able to alter bufferpool but not the tablespaces due to type "AUTOMATIC STORAGE" (USERSPACE1) and "system managed table space" (USERSPACE2).
Still getting same error.
Any further ideas ?
The Build Forge installation database test uses the following query to test the tablespace sizes.
db2 "select tbspace,pagesize from sysibm.systablespaces"
The requirement for Build Forge is that the tablespace pagesize is 16K (16384 bytes)
At a minimum, the last tablespace listed should be set to 16K pagesize, but it is recommended that all tablespaces for the Build Forge database have 16K pagesize.
For example, the following output displays the tablespace USERSPACE2 with a pagesize of 4K (4096 bytes)
This configuration will produce the error you encountered.
TBSPACE PAGESIZE
-------- -----------
SYSCATSPACE 16384
TEMPSPACE1 16384
USERSPACE1 16384
SYSTOOLSPACE 16384
SYSTOOLSTMPSPACE 16384
USERSPACE2 4096
You will need to update your tablespaces to use a bufferpool with a 16K pagesize.
I am seeing the same error even though all the table spaces used by BF are 16K:
# db2 "select TBSPACE,PAGESIZE from sysibm.systablespaces"
TBSPACE PAGESIZE
---------------------------------------------------------- -----------
SYSCATSPACE 4096
TEMPSPACE1 4096
USERSPACE1 4096
SYSTOOLSPACE 4096
TEMPSPACE2 16384
BFUSE_TEMP 16384
USERSPACE2 16384
SYSTOOLSTMPSPACE 4096
8 record(s) selected.
The 4K table spaces work with default buffer pool 'IBMDEFAULTBP' which I cannot change (it can only be specified when creating the database).
I am trying to upgrade from '7.1.3.3' to '8.0.010.0199'.
Any ideas how I can fix or work around this issue?
Thanks
Jakub
Comments
please enable the install debug by export BF_INSTALLER_DEBUG=1 on linux, then start IM from the terminal or set BF_INSTALLER_DEBUG=1 on Windows, then start IM from the cmd, there will be more debug logs
please execute this sql:select pagesize from sysibm.systablespaces to check whether it is bigger than 16382（16*1204= 16384）
Comments
The error message is seen in "Installation Manager", not in the Java part launched to create all the needed tables in DB2, and the binairies. So I don't know if the BF_* vars are the good vars to set to debug the install.
Jerome,
since SYSTOOLSTMPSPACE is the temporary tablespace for internal DB2 tools I have dropped it and was able to continue with the installation.
It looks like the bug in BF installer.
Anyway my update has failed as DB migration did not completed successfully - I was unable to find the logs later on to have exact error message - and I have rolled back to 7.1.3.3. And for now I am happy..
Thanks, I didn't know I can drop this tablespace safely. I started with a clean database because Installation Manager refused the test database as there was some BF tables already :) Unfortunately, the BF Installer ends with an error :
Which platform do you use? such as RHEL6.4 64bit. which version IM do you use? suchas IM 32bit 1.5.0 or IM 64bit 1.6.3. Which database do you use? when use DB2, please create the database according to the help:http://pic.dhe.ibm.com/infocenter/bldforge/v7r1m3/topic/com.ibm.rational.buildforge.doc/topics/preinst_db__top.html..
if you can create Escalation. please create escalation through support team.
Hi,
@Rauline, Did you get the solution for