It's all about the answers!

Ask a question

RRDI 2.0.3 - DB2 10 - Configure from Command Window


0
1
Chris Hardy (3651619) | asked Aug 14 '13, 2:23 a.m.
DB2 control centerHi,
I am looking to install RRDI 2.0.3 with DB2 v10.
In the install instruction for "Creating the DB2 content store" the steps only refer to using the "DB2 control center"

However the "
DB2 control center" was removed from DB2 v10.

I am not really a DB2 person, so does any one have the instructions for configuring the DB2 store from the DB2 command window (as per the DB set up for the othere CLM products)?

Really apprecaite any help with this

Accepted answer


permanent link
Xuan Jiang (37858) | answered Aug 14 '13, 2:29 a.m.
Enter DB2 command line and run the following commands:

db2 CREATE DATABASE [YOURDBNAME] AUTOMATIC STORAGE YES ON 'C:\' DBPATH ON 'C:\' USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM PAGESIZE 4096
db2 CONNECT TO [YOURDBNAME]
db2 UPDATE DATABASE CONFIGURATION USING LOCKTIMEOUT 240 DEFERRED
db2 UPDATE DB CFG FOR  [YOURDBNAME] USING APPLHEAPSZ 1024
db2 CONNECT RESET
Chris Hardy selected this answer as the correct answer

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.