Revision as of 11:32, 29 August 2018

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 libraries.gcd/db2/createDb.sql -z /tmp/c50/libraries.gcd_create.log 
db2 -c -w -i -td@ -vf libraries.gcd/db2/appGrants.sql -z /tmp/c50/libraries.gcd_grants.log 
db2 -c -w -i -td@ -vf libraries.os/db2/createDb.sql -z /tmp/c50/libraries.os_create.log 
db2 -c -w -i -td@ -vf libraries.os/db2/appGrants.sql -z /tmp/c50/libraries.os_grants.log

Ver também

Mais Artigos sobre IBM Connections IBM Connections