IBM Connections: Criando as Databases Manualmente: Difference between revisions

From Wiki
No edit summary
 
(One intermediate revision by the same user not shown)
Line 24: Line 24:


  cd /tmp/Wizards/
  cd /tmp/Wizards/
== Extraindo os arquivos ==
tar -xvf CNCTNS_V6.0_IFR1WLNX,_AIX_ML.tar
unzip 60cr4-database-updates.zip
mv 60cr4-database-updates 60cr4


=== Criação do ACTIVITIES ===
=== Criação do ACTIVITIES ===


  # Criacao do ACTIVITIES  6.0 CR3
  # Criacao do ACTIVITIES  6.0 CR4
  db2 -td@ -vf ./connections.sql/activities/db2/createDb.sql -z ./logs/activities_createDb.sql.log
  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 ./60cr4/From-60/db2/60-60CR1-activities-db2.sql -z ./logs/activities_60-60CR1-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/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/reorg.sql  -z ./logs/activities_reorg.sql.log
Line 39: Line 47:
=== Criação do BLOGS ===
=== Criação do BLOGS ===


  # Criacao do BLOGS  6.0 CR3
  # Criacao do BLOGS  6.0 CR4
  db2 -td@ -vf ./connections.sql/blogs/db2/createDb.sql -z ./logs/blogs_createDb.sql.log
  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/appGrants.sql -z ./logs/blogs_appGrants.sql.log
Line 49: Line 57:
=== Criação do COMMUNITIES ===
=== Criação do COMMUNITIES ===


  # Criacao do COMMUNITIES  6.0 CR3
  # Criacao do COMMUNITIES  6.0 CR4
  db2 -td@ -vf ./connections.sql/communities/db2/createDb.sql -z ./logs/communities_createDb.sql.log
  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 ./60cr4/From-60/db2/60CR1-60CR2-communities-db2.sql -z ./logs/communities_60CR1-60CR2-communities-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR3-60CR4-communities-db2.sql -z ./logs/communities_60CR3-60CR4-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/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/reorg.sql -z ./logs/communities_reorg.sql.log
Line 64: Line 73:
=== Criação do DOGEAR ===
=== Criação do DOGEAR ===


  # Criacao do DOGEAR  6.0 CR3
  # Criacao do DOGEAR  6.0 CR4
  db2 -td@ -vf ./connections.sql/dogear/db2/createDb.sql -z ./logs/dogear_createDb.sql.log
  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/appGrants.sql -z ./logs/dogear_appGrants.sql.log
Line 74: Line 83:
=== Criação do FILES ===
=== Criação do FILES ===


  # Criacao do FILES 6.0 CR3
  # Criacao do FILES 6.0 CR4
  db2 -td@ -vf ./connections.sql/files/db2/createDb.sql -z ./logs/files_createDb.sql.log
  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 ./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 ./60cr4/From-60/db2/60CR1-60CR2-files-db2.sql -z ./logs/files_60CR1-60CR2-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 ./60cr4/From-60/db2/60CR3-60CR4-Files-db2.sql -z ./logs/files_60CR3-60CR4-Files-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR1-60CR2-files_appGrants-db2.sql -z ./logs/60CR1-60CR2-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/reorg.sql -z ./logs/files_reorg.sql.log
  db2 -td@ -vf ./connections.sql/files/db2/updateStats.sql -z ./logs/files_updateStats.sql.log
  db2 -td@ -vf ./connections.sql/files/db2/updateStats.sql -z ./logs/files_updateStats.sql.log
Line 86: Line 96:
=== Criação do FORUM ===
=== Criação do FORUM ===


  # Criacao do FORUM 60CR3
  # Criacao do FORUM 60CR4
  db2 -td@ -vf ./connections.sql/forum/db2/createDb.sql -z ./logs/forum_createDb.sql.log
  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/appGrants.sql -z ./logs/forum_appGrants.sql.log
Line 95: Line 105:
=== Criação do HOMEPAGE ===
=== Criação do HOMEPAGE ===


  # Criacao do HOMEPAGE 6.0 CR3
  # Criacao do HOMEPAGE 6.0 CR4
  db2 -td@ -vf ./connections.sql/homepage/db2/createDb.sql -z ./logs/homepage_createDb.sql.log
  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/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 ./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 ./60cr4/From-60/db2/60-60CR1-homepage-db2.sql -z ./logs/homepage_60-60CR1-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 ./60cr4/From-60/db2/60CR1-60CR2-homepage-db2.sql -z ./logs/homepage_60CR1-60CR2-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 ./60cr4/From-60/db2/60CR2-60CR3-homepage-db2.sql -z ./logs/homepage_60CR2-60CR3-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 ./60cr4/From-60/db2/60CR2-60CR3-homepage_appGrants-db2.sql -z ./logs/homepage_60CR2-60CR3-homepage_appGrants-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR3-60CR4-homepage-db2.sql -z ./logs/homepage_60CR3-60CR4-homepage-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/reorg.sql -z ./logs/homepage_reorg.sql.log
  db2 -td@ -vf ./connections.sql/homepage/db2/runstats.sql -z ./logs/homepage_runstats.sql.log
  db2 -td@ -vf ./connections.sql/homepage/db2/runstats.sql -z ./logs/homepage_runstats.sql.log
  db2 terminate
  db2 terminate


=== Criação do METRICS ===
=== Criação do METRICS ===


  # Criacao do METRICS 6.0 CR3
  # Criacao do METRICS 6.0 CR4
  db2 -td@ -vf ./connections.sql/metrics/db2/createDb.sql -z ./logs/metrics_createDb.sql.log
  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 ./60cr4/From-60/db2/60CR1-60CR2-metrics-db2.sql -z ./logs/metrics_60CR1-60CR2-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/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/reorg.sql  -z ./logs/metrics_reorg.sql.log
Line 117: Line 129:
  db2 terminate
  db2 terminate


=== Criação do MOBILE 6.0 CR3 ===
=== Criação do MOBILE 6.0 CR4 ===


  # Criacao do MOBILE 6.0 CR3
  # Criacao do MOBILE 6.0 CR4
  db2 -td@ -vf ./connections.sql/mobile/db2/createDb.sql -z ./logs/mobile_createDb.sql.log
  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/appGrants.sql    -z ./logs/mobile_appGrants.sql.log
Line 130: Line 142:
=== Criação do PROFILES ===
=== Criação do PROFILES ===


  # Criacao do PROFILES  6.0 CR3
  # Criacao do PROFILES  6.0 CR4
  db2 -td@ -vf ./connections.sql/profiles/db2/createDb.sql -z ./logs/profiles_createDb.sql.log
  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/appGrants.sql  -z ./logs/profiles_appGrants.sql.log
Line 139: Line 151:
=== Criação do PUSHNOTIFICATIONS ===
=== Criação do PUSHNOTIFICATIONS ===


  # Criacao do PUSHNOTIFICATIONS  6.0 CR3
  # Criacao do PUSHNOTIFICATIONS  6.0 CR4
  db2 -td@ -vf ./connections.sql/pushnotification/db2/createDb.sql -z ./logs/profiles_createDb.sql.log
  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/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/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/reorg.sql  -z ./logs/profiles_reorg.sql.log
  db2 -td@ -vf ./connections.sql/pushnotification/db2/runstats.sql  -z ./logs/profiles_runstats.sql.log
  db2 -td@ -vf ./connections.sql/pushnotification/db2/updateStats.sql  -z ./logs/profiles_updateStats.sql.log
  db2 terminate
  db2 terminate


=== Criação do WIKIS ===
=== Criação do WIKIS ===


  # Criacao do WIKIS 6.0 CR3
  # Criacao do WIKIS 6.0 CR4
  db2 -td@ -vf ./connections.sql/wikis/db2/createDb.sql -z ./logs/wikis_createDb.sql.log
  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 ./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 ./60cr4/From-60/db2/60CR1-60CR2-wikis-db2.sql -z ./logs/wikis_60CR1-60CR2-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 ./60cr4/From-60/db2/60CR3-60CR4-wikis-db2.sql -z ./logs/wikis_60CR3-60CR4-wikis-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR1-60CR2-wikis_appGrants-db2.sql -z ./logs/60CR1-60CR2-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/reorg.sql  -z ./logs/wikis_reorg.sql.log
  db2 -td@ -vf ./connections.sql/wikis/db2/updateStats.sql  -z ./logs/wikis_updateStats.sql.log
  db2 -td@ -vf ./connections.sql/wikis/db2/updateStats.sql  -z ./logs/wikis_updateStats.sql.log
Line 162: Line 175:
  # Criação da database 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  
  db2 -tvf ./60cr4/From-60/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


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


= Ver também =
= Ver também =

Latest revision as of 01:12, 8 March 2019

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/

Extraindo os arquivos

tar -xvf CNCTNS_V6.0_IFR1WLNX,_AIX_ML.tar 
unzip 60cr4-database-updates.zip

mv 60cr4-database-updates 60cr4

Criação do ACTIVITIES

# Criacao do ACTIVITIES  6.0 CR4
db2 -td@ -vf ./connections.sql/activities/db2/createDb.sql -z ./logs/activities_createDb.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60-60CR1-activities-db2.sql -z ./logs/activities_60-60CR1-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 CR4
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 CR4
db2 -td@ -vf ./connections.sql/communities/db2/createDb.sql -z ./logs/communities_createDb.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR1-60CR2-communities-db2.sql -z ./logs/communities_60CR1-60CR2-communities-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR3-60CR4-communities-db2.sql -z ./logs/communities_60CR3-60CR4-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 CR4
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 CR4
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 ./60cr4/From-60/db2/60CR1-60CR2-files-db2.sql -z ./logs/files_60CR1-60CR2-files-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR3-60CR4-Files-db2.sql -z ./logs/files_60CR3-60CR4-Files-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR1-60CR2-files_appGrants-db2.sql -z ./logs/60CR1-60CR2-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 60CR4
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 CR4
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 ./60cr4/From-60/db2/60-60CR1-homepage-db2.sql -z ./logs/homepage_60-60CR1-homepage-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR1-60CR2-homepage-db2.sql -z ./logs/homepage_60CR1-60CR2-homepage-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR2-60CR3-homepage-db2.sql -z ./logs/homepage_60CR2-60CR3-homepage-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR2-60CR3-homepage_appGrants-db2.sql -z ./logs/homepage_60CR2-60CR3-homepage_appGrants-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR3-60CR4-homepage-db2.sql -z ./logs/homepage_60CR3-60CR4-homepage-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 CR4
db2 -td@ -vf ./connections.sql/metrics/db2/createDb.sql -z ./logs/metrics_createDb.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR1-60CR2-metrics-db2.sql -z ./logs/metrics_60CR1-60CR2-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 CR4

# Criacao do MOBILE 6.0 CR4
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 CR4
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 CR4
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/updateStats.sql  -z ./logs/profiles_updateStats.sql.log
db2 terminate

Criação do WIKIS

# Criacao do WIKIS 6.0 CR4
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 ./60cr4/From-60/db2/60CR1-60CR2-wikis-db2.sql -z ./logs/wikis_60CR1-60CR2-wikis-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR3-60CR4-wikis-db2.sql -z ./logs/wikis_60CR3-60CR4-wikis-db2.sql.log
db2 -td@ -vf ./60cr4/From-60/db2/60CR1-60CR2-wikis_appGrants-db2.sql -z ./logs/60CR1-60CR2-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 ./60cr4/From-60/Highlights_DB_Creation/db2/Create_XCC_DB2_Database.sql -z ./logs/xcc_Create_XCC_DB2_Database.sql.log 

Se você for instalar o IBM Connections Content Manager

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

Ver também