It's all about the answers!

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

×10,962

question asked: Feb 07 '10, 9:53 a.m.
question was seen: 7,426 times
last updated: Feb 07 '10, 9:53 a.m.

Related questions

RQM on DB2 create database command

0
Jan Šťastný (121●2●14●7) | asked Feb 07 '10, 9:53 a.m.
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 .

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
David Mehaffy (901●2●33●38) | answered Feb 08 '10, 11:38 a.m.
JAZZ DEVELOPER
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.
0
permanent link
Benjamin Chodroff (898●52●31) | answered Feb 15 '10, 6:02 p.m.
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.
0
permanent link
Jan Šťastný (121●2●14●7) | answered Feb 17 '10, 3:15 a.m.
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.

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.