Thursday, 2 August 2012

IBM Connections - Preparing the DB2 Databases Manually ( of course )

Am writing this down, because I *know* I'll need it again at some point, but will update for Connections 4 when it ships in 2H 2012.

Preparing the Wizard

$ cd /tmp/
mkdir Wizards
cd Wizards/
tar xvf ~/IBM_Connection301_Wzd_zLinux_CZVR1ML.tar 

Creating the databases

cd /tmp/Wizards/Wizards/connections.sql/

Activites

db2 -td@ -vf activities/db2/createDb.sql 
db2 -td@ -vf activities/db2/appGrants.sql 

Blogs

db2 -td@ -vf blogs/db2/createDb.sql 
db2 -td@ -vf blogs/db2/appGrants.sql 

Communities

db2 -td@ -vf communities/db2/createDb.sql 
db2 -td@ -vf communities/db2/appGrants.sql 

Bookmarks ( Dogear )

db2 -td@ -vf dogear/db2/createDb.sql 
db2 -td@ -vf dogear/db2/appGrants.sql 

Files

db2 -td@ -vf files/db2/createDb.sql 
db2 -td@ -vf files/db2/appGrants.sql 

Forums

db2 -td@ -vf forum/db2/createDb.sql 
db2 -td@ -vf forum/db2/appGrants.sql 

Homepage

db2 -tvf homepage/db2/createDb.sql 
db2 -tvf homepage/db2/appGrants.sql 
db2 -tvf homepage/db2/initData.sql 
db2 -tvf homepage/db2/reorg.sql 
db2 -tvf homepage/db2/updateStats.sql 

Profiles

db2 -tvf profiles/db2/createDb.sql 
db2 -tvf profiles/db2/appGrants.sql 

Wikis

db2 -td@ -vf wikis/db2/createDb.sql 
db2 -td@ -vf wikis/db2/appGrants.sql 

Thanks to the Wiki for the assist

No comments: