IBM Connections: Criando as Databases Manualmente

Abrir um Shell com o usuário da instância exemplo db2inst1

Copiar o diretório connections.sql do Wizard

Criar o seguinte shell

db2 -c -w -i -td@ -vf connections.sql/activities/db2/createDb.sql db2 -c -w -i -td@ -vf connections.sql/activities/db2/appGrants.sql db2 -c -w -i -td@ -vf connections.sql/blogs/db2/createDb.sql db2 -c -w -i -td@ -vf connections.sql/blogs/db2/appGrants.sql db2 -c -w -i -td@ -vf connections.sql/communities/db2/createDb.sql db2 -c -w -i -td@ -vf connections.sql/communities/db2/appGrants.sql db2 -c -w -i -td@ -vf connections.sql/dogear/db2/createDb.sql db2 -c -w -i -td@ -vf connections.sql/dogear/db2/appGrants.sql db2 -c -w -i -td@ -vf connections.sql/wikis/db2/createDb.sql db2 -c -w -i -td@ -vf connections.sql/wikis/db2/appGrants.sql db2 -c -w -i -td@ -vf connections.sql/files/db2/createDb.sql db2 -c -w -i -td@ -vf connections.sql/files/db2/appGrants.sql db2 -c -w -i -td@ -vf connections.sql/forum/db2/createDb.sql db2 -c -w -i -td@ -vf connections.sql/forum/db2/appGrants.sql db2 -c -w -i -td";" -vf connections.sql/profiles/db2/createDb.sql db2 -c -w -i -td";" -vf connections.sql/profiles/db2/appGrants.sql db2 -c -w -i -td";" -vf connections.sql/homepage/db2/createDb.sql db2 -c -w -i -td";" -vf connections.sql/homepage/db2/appGrants.sql db2 -c -w -i -td";" -vf connections.sql/homepage/db2/initData.sql db2 -c -w -i -td";" -vf connections.sql/homepage/db2/reorg.sql db2 -c -w -i -td";" -vf connections.sql/homepage/db2/updateStats.sql
 * 1) !/bin/bash
 * 1) Os arquivos de profiles, homepage não utilizavam o @ como finalizador do comando
 * 2) db2 -c -w -i -td@ -vf connections.sql/profiles/db2/createDb.sql
 * 3) db2 -c -w -i -td@ -vf connections.sql/profiles/db2/appGrants.sql
 * 4) db2 -c -w -i -td@ -vf connections.sql/homepage/db2/createDb.sql
 * 5) db2 -c -w -i -td@ -vf connections.sql/homepage/db2/appGrants.sql
 * 6) db2 -c -w -i -td@ -vf connections.sql/homepage/db2/initData.sql
 * 7) db2 -c -w -i -td@ -vf connections.sql/homepage/db2/reorg.sql
 * 8) db2 -c -w -i -td@ -vf connections.sql/homepage/db2/updateStats.sql

Executar o

sh -x criaConnectionsDB.sh | tee resultado.txt