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

Creating IBM DB2 databases manually