IBM Connections: Criando as Databases Manualmente

From Wiki
Revision as of 21:13, 25 April 2012 by Ebasso (talk | contribs) (New page: 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.s...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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
Retrieved from "https://ebasso.net/wiki/index.php?title=IBM_Connections:_Criando_as_Databases_Manualmente&oldid=1344"