RRDI 2.0.3 - DB2 10 - Configure from Command Window
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
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
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
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