IBM Connections: Criando as Databases Manualmente

From Wiki
Revision as of 14:37, 27 February 2014 by Ebasso (talk | contribs)

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

Copiar o diretório connections.sql do Wizard

Criar o seguinte shell

#!/bin/bash
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
# Os arquivos de profiles, homepage não utilizavam o @ como finalizador do comando
##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
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

Executar o

sh -x criaConnectionsDB.sh | tee resultado.txt


Ver também