IBM Connections: Criando as Databases Manualmente

Versão Atual: IBM Connections 6.0

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

= Criando o usuário LNTUSER =

No meu ambiente, o espaço alocado foi montado no diretório /opt/IBM, então vou criar o diretório db2home neste diretório.

mkdir -p /opt/IBM/db2home

useradd -m -d /opt/IBM/db2home/lcuser lcuser

Trocanco a senha

passwd lcuser

= Criando o Banco de Dados Manualmente =

Entrar com o usuário dono da instância

su - db2inst1

Ir para o diretório onde você extraiu o Wizard

cd /tmp/Wizards/connections.sql

Executar os comandos

db2 -c -w -i -td@ -vf activities/db2/createDb.sql -z /tmp/activities_create.log db2 -c -w -i -td@ -vf activities/db2/appGrants.sql -z /tmp/activities_grants.log db2 -c -w -i -td@ -vf blogs/db2/createDb.sql      -z /tmp/blogs_create.log ; db2 -c -w -i -td@ -vf blogs/db2/appGrants.sql     -z /tmp/blogs_grants.log ; db2 -c -w -i -td@ -vf cognos/db2/createDb.sql     -z /tmp/cognos_create.log ; db2 -c -w -i -td@ -vf cognos/db2/appGrants.sql    -z /tmp/cognos_grants.log ; db2 -c -w -i -td@ -vf communities/db2/createDb.sql -z /tmp/communities_create.log ; db2 -c -w -i -td@ -vf communities/db2/appGrants.sql -z /tmp/communities_grants.log ; db2 -c -w -i -td@ -vf communities/db2/calendar-createDb.sql -z /tmp/communities_createcalendar.log ; db2 -c -w -i -td@ -vf communities/db2/calendar-appGrants.sql -z /tmp/communities_grantscalendar.log ; db2 -c -w -i -td@ -vf dogear/db2/createDb.sql     -z /tmp/dogear_create.log ; db2 -c -w -i -td@ -vf dogear/db2/appGrants.sql    -z /tmp/dogear_grants.log ; db2 -c -w -i -td@ -vf files/db2/createDb.sql      -z /tmp/files_create.log ; db2 -c -w -i -td@ -vf files/db2/appGrants.sql     -z /tmp/files_grants.log ; db2 -c -w -i -td@ -vf forum/db2/createDb.sql      -z /tmp/forum_create.log ; db2 -c -w -i -td@ -vf forum/db2/appGrants.sql     -z /tmp/forum_grants.log ; db2 -c -w -i -td@ -vf homepage/db2/createDb.sql   -z /tmp/homepage_create.log ; db2 -c -w -i -td@ -vf homepage/db2/appGrants.sql  -z /tmp/homepage_grants.log ; db2 -c -w -i -td@ -vf homepage/db2/initData.sql   -z /tmp/homepage_initdata.log ; db2 -c -w -i -td@ -vf homepage/db2/reorg.sql      -z /tmp/homepage_reorg.log ; db2 -c -w -i -td@ -vf homepage/db2/updateStats.sql -z /tmp/homepage_updatestats.log ; db2 -c -w -i -td@ -vf metrics/db2/createDb.sql    -z /tmp/metrics_create.log ; db2 -c -w -i -td@ -vf metrics/db2/appGrants.sql   -z /tmp/metrics_grants.log ; db2 -c -w -i -td@ -vf mobile/db2/createDb.sql     -z /tmp/mobile_create.log ; db2 -c -w -i -td@ -vf mobile/db2/appGrants.sql    -z /tmp/mobile_grants.log ; db2 -c -w -i -td@ -vf profiles/db2/createDb.sql   -z /tmp/profiles_create.log ; db2 -c -w -i -td@ -vf profiles/db2/appGrants.sql  -z /tmp/profiles_grants.log ; db2 -c -w -i -td@ -vf pushnotification/db2/createDb.sql -z /tmp/pushnotification_grants.log ; db2 -c -w -i -td@ -vf pushnotification/db2/createTriggers.sql -z /tmp/pushnotification_grants.log ; db2 -c -w -i -td@ -vf wikis/db2/createDb.sql      -z /tmp/wikis_create.log ; db2 -c -w -i -td@ -vf wikis/db2/appGrants.sql     -z /tmp/wikis_grants.log ;

Se você for instalar o IBM Connections Content Manager

db2 -c -w -i -td@ -vf library.gcd/db2/createDb.sql -z /tmp/libraries.gcd_create.log db2 -c -w -i -td@ -vf library.gcd/db2/appGrants.sql -z /tmp/libraries.gcd_grants.log db2 -c -w -i -td@ -vf library.os/db2/createDb.sql -z /tmp/libraries.os_create.log db2 -c -w -i -td@ -vf library.os/db2/appGrants.sql -z /tmp/libraries.os_grants.log

= Ver também =


 * IBM Connections:Reorg Connections Databases
 * IBM Connections:Limpeza de diretórios


 * Mais Artigos sobre IBM Connections IBM Connections