RQM on DB2 create database command

honza.stastny wrote:

Since RQM official documentation only gives the database creation
procedure for GUI DB2 Control Center and does not give the equivalent
command line command so I post it here:
db2 create database RQM using codeset UTF-8
territory en PAGESIZE 8192


If you use the command from RTC repotools -createTables will fail.
This is caused by the PAGESIZE being too low.

More about RQM installation on 64bit Ubuntu at
my
blog .

I believe the recommended pagesize for RQM is 16384 not 8192.

The documentation is not sufficient, but your command did not work as well. This did:
db2 create database RQM2 using codeset UTF-8 territory en PAGESIZE 16384

You must have 16384 as the pagesize because the default value for any bufferpools and tablespaces is set to the pagesize. The documentation indicates bufferpools need to be set to 16K.

The documentation is not sufficient, but your command did not work as well. This did:
db2 create database RQM2 using codeset UTF-8 territory en PAGESIZE 16384

You must have 16384 as the pagesize because the default value for any bufferpools and tablespaces is set to the pagesize. The documentation indicates bufferpools need to be set to 16K.

Thanks a lot for the correction. My mistake.