IBM Connections: Criando as Databases Manualmente: Difference between revisions
| Line 23: | Line 23: | ||
Ir para o diretório onde você extraiu o Wizard | Ir para o diretório onde você extraiu o Wizard | ||
cd /tmp/Wizards/ | cd /tmp/Wizards/ | ||
=== Criação do ACTIVITIES === | |||
# Criacao do ACTIVITIES 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/activities/db2/createDb.sql -z ./logs/activities_createDb.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR1-activities-db2.sql -z ./logs/activities_60-CR1-activities-db2.sql.log | |||
db2 -td@ -vf ./connections.sql/activities/db2/appGrants.sql -z ./logs/activities_appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/activities/db2/reorg.sql -z ./logs/activities_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/activities/db2/runstats.sql -z ./logs/activities_runstats.sql.log | |||
db2 -td@ -vf ./connections.sql/activities/db2/clearScheduler.sql -z ./logs/activities_clearScheduler.sql.log | |||
db2 terminate | |||
=== Criação do BLOGS === | |||
# Criacao do BLOGS 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/blogs/db2/createDb.sql -z ./logs/blogs_createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/blogs/db2/appGrants.sql -z ./logs/blogs_appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/blogs/db2/reorg.sql -z ./logs/blogs_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/blogs/db2/runstats.sql -z ./logs/blogs_runstats.sql.log | |||
db2 terminate | |||
=== Criação do COMMUNITIES === | |||
# Criacao do COMMUNITIES 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/communities/db2/createDb.sql -z ./logs/communities_createDb.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR2-communities-db2.sql -z ./logs/communities_60-CR2-communities-db2.sql.log | |||
db2 -td@ -vf ./connections.sql/communities/db2/appGrants.sql -z ./logs/communities_appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/communities/db2/reorg.sql -z ./logs/communities_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/communities/db2/runstats.sql -z ./logs/communities_runstats.sql.log | |||
db2 -td@ -vf ./connections.sql/communities/db2/calendar-createDb.sql -z ./logs/communities_calendar-createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/communities/db2/calendar-appGrants.sql -z ./logs/communities_calendar-appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/communities/db2/calendar-reorg.sql -z ./logs/communities_calendar-reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/communities/db2/calendar-runstats.sql -z ./logs/communities_calendar-runstats.sql.log | |||
db2 terminate | |||
=== Criação do DOGEAR === | |||
# Criacao do DOGEAR 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/dogear/db2/createDb.sql -z ./logs/dogear_createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/dogear/db2/appGrants.sql -z ./logs/dogear_appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/dogear/db2/reorg.sql -z ./logs/dogear_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/dogear/db2/runstats.sql -z ./logs/dogear_runstats.sql.log | |||
db2 terminate | |||
=== Criação do FILES === | |||
# Criacao do FILES 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/files/db2/createDb.sql -z ./logs/files_createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/files/db2/appGrants.sql -z ./logs/files_appGrants.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR2-files-db2.sql -z ./logs/files_60-CR2-files-db2.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR2-files_appGrants-db2.sql -z ./logs/60-CR2-files_appGrants-db2.sql.log | |||
db2 -td@ -vf ./connections.sql/files/db2/reorg.sql -z ./logs/files_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/files/db2/updateStats.sql -z ./logs/files_updateStats.sql.log | |||
db2 terminate | |||
=== Criação do FORUM === | |||
# Criacao do FORUM 60CR3 | |||
db2 -td@ -vf ./connections.sql/forum/db2/createDb.sql -z ./logs/forum_createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/forum/db2/appGrants.sql -z ./logs/forum_appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/forum/db2/reorg.sql -z ./logs/forum_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/forum/db2/runstats.sql -z ./logs/forum_runstats.sql.log | |||
db2 terminate | |||
=== Criação do HOMEPAGE === | |||
# Criacao do HOMEPAGE 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/homepage/db2/createDb.sql -z ./logs/homepage_createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/homepage/db2/initData.sql -z ./logs/homepage_initData.sql.log | |||
db2 -td@ -vf ./connections.sql/homepage/db2/appGrants.sql -z ./logs/homepage_appGrants.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR1-homepage-db2.sql -z ./logs/homepage_60-CR1-homepage-db2.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR2-homepage-db2.sql -z ./logs/homepage_60-CR2-homepage-db2.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR3-homepage-db2.sql -z ./logs/homepage_60-CR3-homepage-db2.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR3-homepage_appGrants-db2.sql -z ./logs/homepage_60-CR3-homepage_appGrants-db2.sql.log | |||
db2 -td@ -vf ./connections.sql/homepage/db2/reorg.sql -z ./logs/homepage_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/homepage/db2/runstats.sql -z ./logs/homepage_runstats.sql.log | |||
db2 terminate | |||
=== Criação do METRICS === | |||
# Criacao do METRICS 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/metrics/db2/createDb.sql -z ./logs/metrics_createDb.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR2-metrics-db2.sql -z ./logs/metrics_60-CR2-metrics-db2.sql.log | |||
db2 -td@ -vf ./connections.sql/metrics/db2/appGrants.sql -z ./logs/metrics_appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/metrics/db2/reorg.sql -z ./logs/metrics_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/metrics/db2/updateStats.sql -z ./logs/metrics_updateStats.sql.log | |||
db2 terminate | |||
=== Criação do MOBILE 6.0 CR3 === | |||
# Criacao do MOBILE 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/mobile/db2/createDb.sql -z ./logs/mobile_createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/mobile/db2/appGrants.sql -z ./logs/mobile_appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/mobile/db2/reorg.sql -z ./logs/mobile_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/mobile/db2/runstats.sql -z ./logs/mobile_runstats.sql.log | |||
db2 terminate | |||
'''Importante''': Desconsidere '''WARNINGS''' sobre entradas duplicadas | |||
=== Criação do PROFILES === | |||
# Criacao do PROFILES 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/profiles/db2/createDb.sql -z ./logs/profiles_createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/profiles/db2/appGrants.sql -z ./logs/profiles_appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/profiles/db2/reorg.sql -z ./logs/profiles_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/profiles/db2/runstats.sql -z ./logs/profiles_runstats.sql.log | |||
db2 terminate | |||
=== Criação do PUSHNOTIFICATIONS === | |||
# Criacao do PUSHNOTIFICATIONS 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/pushnotification/db2/createDb.sql -z ./logs/profiles_createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/pushnotification/db2/createTriggers.sql -z ./logs/pushnotification_grants.log ; | |||
db2 -td@ -vf ./connections.sql/pushnotification/db2/appGrants.sql -z ./logs/profiles_appGrants.sql.log | |||
db2 -td@ -vf ./connections.sql/pushnotification/db2/reorg.sql -z ./logs/profiles_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/pushnotification/db2/runstats.sql -z ./logs/profiles_runstats.sql.log | |||
db2 terminate | |||
=== Criação do WIKIS === | |||
# Criacao do WIKIS 6.0 CR3 | |||
db2 -td@ -vf ./connections.sql/wikis/db2/createDb.sql -z ./logs/wikis_createDb.sql.log | |||
db2 -td@ -vf ./connections.sql/wikis/db2/appGrants.sql -z ./logs/wikis_appGrants.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR2-wikis-db2.sql -z ./logs/wikis_60-CR2-wikis-db2.sql.log | |||
db2 -td@ -vf ./60cr3/60-CR2-wikis_appGrants-db2.sql -z ./logs/60-CR2-wikis_appGrants-db2.sql.log | |||
db2 -td@ -vf ./connections.sql/wikis/db2/reorg.sql -z ./logs/wikis_reorg.sql.log | |||
db2 -td@ -vf ./connections.sql/wikis/db2/updateStats.sql -z ./logs/wikis_updateStats.sql.log | |||
db2 terminate | |||
=== Criação do XCC === | |||
# Criação da database XCC | |||
db2 -tvf ./Highlights_DB_Creation/db2/Create_XCC_DB2_Database.sql -z ./logs/xcc_Create_XCC_DB2_Database.sql.log | |||
Fim | |||
[[Category:Programa Colaboração|Programa_Colaboração]]<br/>[[Category:Colaboração]]<br/>[[Category:Comuniçação Unificada|Comuniçação_Unificada]]<br/>[[Category:Comuniçação]]<br/>[[Category:Redes Sociais|Redes_Sociais]]<br/>[[Category:Connections 6.0|Connections_6.0]]<br/>[[Category:IBM Connections|IBM_Connections]]<br/>[[Category:ConnecteBB]] | |||
Se você for instalar o IBM Connections Content Manager | Se você for instalar o IBM Connections Content Manager | ||
Revision as of 20:35, 3 December 2018
Versão Atual: IBM Connections 6.0
Abrir um Shell com o usuário da instância exemplo db2inst1
Criando o usuário LCUSER
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/
Criação do ACTIVITIES
# Criacao do ACTIVITIES 6.0 CR3 db2 -td@ -vf ./connections.sql/activities/db2/createDb.sql -z ./logs/activities_createDb.sql.log db2 -td@ -vf ./60cr3/60-CR1-activities-db2.sql -z ./logs/activities_60-CR1-activities-db2.sql.log db2 -td@ -vf ./connections.sql/activities/db2/appGrants.sql -z ./logs/activities_appGrants.sql.log db2 -td@ -vf ./connections.sql/activities/db2/reorg.sql -z ./logs/activities_reorg.sql.log db2 -td@ -vf ./connections.sql/activities/db2/runstats.sql -z ./logs/activities_runstats.sql.log db2 -td@ -vf ./connections.sql/activities/db2/clearScheduler.sql -z ./logs/activities_clearScheduler.sql.log db2 terminate
Criação do BLOGS
# Criacao do BLOGS 6.0 CR3 db2 -td@ -vf ./connections.sql/blogs/db2/createDb.sql -z ./logs/blogs_createDb.sql.log db2 -td@ -vf ./connections.sql/blogs/db2/appGrants.sql -z ./logs/blogs_appGrants.sql.log db2 -td@ -vf ./connections.sql/blogs/db2/reorg.sql -z ./logs/blogs_reorg.sql.log db2 -td@ -vf ./connections.sql/blogs/db2/runstats.sql -z ./logs/blogs_runstats.sql.log db2 terminate
Criação do COMMUNITIES
# Criacao do COMMUNITIES 6.0 CR3 db2 -td@ -vf ./connections.sql/communities/db2/createDb.sql -z ./logs/communities_createDb.sql.log db2 -td@ -vf ./60cr3/60-CR2-communities-db2.sql -z ./logs/communities_60-CR2-communities-db2.sql.log db2 -td@ -vf ./connections.sql/communities/db2/appGrants.sql -z ./logs/communities_appGrants.sql.log db2 -td@ -vf ./connections.sql/communities/db2/reorg.sql -z ./logs/communities_reorg.sql.log db2 -td@ -vf ./connections.sql/communities/db2/runstats.sql -z ./logs/communities_runstats.sql.log db2 -td@ -vf ./connections.sql/communities/db2/calendar-createDb.sql -z ./logs/communities_calendar-createDb.sql.log db2 -td@ -vf ./connections.sql/communities/db2/calendar-appGrants.sql -z ./logs/communities_calendar-appGrants.sql.log db2 -td@ -vf ./connections.sql/communities/db2/calendar-reorg.sql -z ./logs/communities_calendar-reorg.sql.log db2 -td@ -vf ./connections.sql/communities/db2/calendar-runstats.sql -z ./logs/communities_calendar-runstats.sql.log db2 terminate
Criação do DOGEAR
# Criacao do DOGEAR 6.0 CR3 db2 -td@ -vf ./connections.sql/dogear/db2/createDb.sql -z ./logs/dogear_createDb.sql.log db2 -td@ -vf ./connections.sql/dogear/db2/appGrants.sql -z ./logs/dogear_appGrants.sql.log db2 -td@ -vf ./connections.sql/dogear/db2/reorg.sql -z ./logs/dogear_reorg.sql.log db2 -td@ -vf ./connections.sql/dogear/db2/runstats.sql -z ./logs/dogear_runstats.sql.log db2 terminate
Criação do FILES
# Criacao do FILES 6.0 CR3 db2 -td@ -vf ./connections.sql/files/db2/createDb.sql -z ./logs/files_createDb.sql.log db2 -td@ -vf ./connections.sql/files/db2/appGrants.sql -z ./logs/files_appGrants.sql.log db2 -td@ -vf ./60cr3/60-CR2-files-db2.sql -z ./logs/files_60-CR2-files-db2.sql.log db2 -td@ -vf ./60cr3/60-CR2-files_appGrants-db2.sql -z ./logs/60-CR2-files_appGrants-db2.sql.log db2 -td@ -vf ./connections.sql/files/db2/reorg.sql -z ./logs/files_reorg.sql.log db2 -td@ -vf ./connections.sql/files/db2/updateStats.sql -z ./logs/files_updateStats.sql.log db2 terminate
Criação do FORUM
# Criacao do FORUM 60CR3 db2 -td@ -vf ./connections.sql/forum/db2/createDb.sql -z ./logs/forum_createDb.sql.log db2 -td@ -vf ./connections.sql/forum/db2/appGrants.sql -z ./logs/forum_appGrants.sql.log db2 -td@ -vf ./connections.sql/forum/db2/reorg.sql -z ./logs/forum_reorg.sql.log db2 -td@ -vf ./connections.sql/forum/db2/runstats.sql -z ./logs/forum_runstats.sql.log db2 terminate
Criação do HOMEPAGE
# Criacao do HOMEPAGE 6.0 CR3 db2 -td@ -vf ./connections.sql/homepage/db2/createDb.sql -z ./logs/homepage_createDb.sql.log db2 -td@ -vf ./connections.sql/homepage/db2/initData.sql -z ./logs/homepage_initData.sql.log db2 -td@ -vf ./connections.sql/homepage/db2/appGrants.sql -z ./logs/homepage_appGrants.sql.log db2 -td@ -vf ./60cr3/60-CR1-homepage-db2.sql -z ./logs/homepage_60-CR1-homepage-db2.sql.log db2 -td@ -vf ./60cr3/60-CR2-homepage-db2.sql -z ./logs/homepage_60-CR2-homepage-db2.sql.log db2 -td@ -vf ./60cr3/60-CR3-homepage-db2.sql -z ./logs/homepage_60-CR3-homepage-db2.sql.log db2 -td@ -vf ./60cr3/60-CR3-homepage_appGrants-db2.sql -z ./logs/homepage_60-CR3-homepage_appGrants-db2.sql.log db2 -td@ -vf ./connections.sql/homepage/db2/reorg.sql -z ./logs/homepage_reorg.sql.log db2 -td@ -vf ./connections.sql/homepage/db2/runstats.sql -z ./logs/homepage_runstats.sql.log db2 terminate
Criação do METRICS
# Criacao do METRICS 6.0 CR3 db2 -td@ -vf ./connections.sql/metrics/db2/createDb.sql -z ./logs/metrics_createDb.sql.log db2 -td@ -vf ./60cr3/60-CR2-metrics-db2.sql -z ./logs/metrics_60-CR2-metrics-db2.sql.log db2 -td@ -vf ./connections.sql/metrics/db2/appGrants.sql -z ./logs/metrics_appGrants.sql.log db2 -td@ -vf ./connections.sql/metrics/db2/reorg.sql -z ./logs/metrics_reorg.sql.log db2 -td@ -vf ./connections.sql/metrics/db2/updateStats.sql -z ./logs/metrics_updateStats.sql.log db2 terminate
Criação do MOBILE 6.0 CR3
# Criacao do MOBILE 6.0 CR3 db2 -td@ -vf ./connections.sql/mobile/db2/createDb.sql -z ./logs/mobile_createDb.sql.log db2 -td@ -vf ./connections.sql/mobile/db2/appGrants.sql -z ./logs/mobile_appGrants.sql.log db2 -td@ -vf ./connections.sql/mobile/db2/reorg.sql -z ./logs/mobile_reorg.sql.log db2 -td@ -vf ./connections.sql/mobile/db2/runstats.sql -z ./logs/mobile_runstats.sql.log db2 terminate
Importante: Desconsidere WARNINGS sobre entradas duplicadas
Criação do PROFILES
# Criacao do PROFILES 6.0 CR3 db2 -td@ -vf ./connections.sql/profiles/db2/createDb.sql -z ./logs/profiles_createDb.sql.log db2 -td@ -vf ./connections.sql/profiles/db2/appGrants.sql -z ./logs/profiles_appGrants.sql.log db2 -td@ -vf ./connections.sql/profiles/db2/reorg.sql -z ./logs/profiles_reorg.sql.log db2 -td@ -vf ./connections.sql/profiles/db2/runstats.sql -z ./logs/profiles_runstats.sql.log db2 terminate
Criação do PUSHNOTIFICATIONS
# Criacao do PUSHNOTIFICATIONS 6.0 CR3 db2 -td@ -vf ./connections.sql/pushnotification/db2/createDb.sql -z ./logs/profiles_createDb.sql.log db2 -td@ -vf ./connections.sql/pushnotification/db2/createTriggers.sql -z ./logs/pushnotification_grants.log ; db2 -td@ -vf ./connections.sql/pushnotification/db2/appGrants.sql -z ./logs/profiles_appGrants.sql.log db2 -td@ -vf ./connections.sql/pushnotification/db2/reorg.sql -z ./logs/profiles_reorg.sql.log db2 -td@ -vf ./connections.sql/pushnotification/db2/runstats.sql -z ./logs/profiles_runstats.sql.log db2 terminate
Criação do WIKIS
# Criacao do WIKIS 6.0 CR3 db2 -td@ -vf ./connections.sql/wikis/db2/createDb.sql -z ./logs/wikis_createDb.sql.log db2 -td@ -vf ./connections.sql/wikis/db2/appGrants.sql -z ./logs/wikis_appGrants.sql.log db2 -td@ -vf ./60cr3/60-CR2-wikis-db2.sql -z ./logs/wikis_60-CR2-wikis-db2.sql.log db2 -td@ -vf ./60cr3/60-CR2-wikis_appGrants-db2.sql -z ./logs/60-CR2-wikis_appGrants-db2.sql.log db2 -td@ -vf ./connections.sql/wikis/db2/reorg.sql -z ./logs/wikis_reorg.sql.log db2 -td@ -vf ./connections.sql/wikis/db2/updateStats.sql -z ./logs/wikis_updateStats.sql.log db2 terminate
Criação do XCC
# Criação da database XCC db2 -tvf ./Highlights_DB_Creation/db2/Create_XCC_DB2_Database.sql -z ./logs/xcc_Create_XCC_DB2_Database.sql.log
Fim
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
- Mais Artigos sobre IBM Connections IBM Connections