Revision as of 21:53, 30 July 2014

Preparando o Banco de Dados do Connections 4.5

Criando os Banco de Dados do Connections 4.5 Manualmente

Desempacotar

cd /tmp
mkdir c45
chmod a+rw c45

db2 -td@ -vf activities/db2/createDb.sql -z /tmp/c45/activities_create.log ;
db2 -td@ -vf activities/db2/appGrants.sql -z /tmp/c45/activities_grants.log ;
db2 -td@ -vf blogs/db2/createDb.sql -z /tmp/c45/blogs_create.log ;
db2 -td@ -vf blogs/db2/appGrants.sql -z /tmp/c45/blogs_grants.log ;
db2 -td@ -vf communities/db2/createDb.sql -z /tmp/c45/communities_create.log ;
db2 -td@ -vf communities/db2/appGrants.sql -z /tmp/c45/communities_grants.log ;
db2 -td@ -vf communities/db2/calendar-createDb.sql -z /tmp/c45/communities_createcalendar.log ;
db2 -td@ -vf communities/db2/calendar-appGrants.sql -z /tmp/c45/communities_grantscalendar.log ;
db2 -td@ -vf dogear/db2/createDb.sql -z /tmp/c45/dogear_create.log ;
db2 -td@ -vf dogear/db2/appGrants.sql -z /tmp/c45/dogear_grants.log ;
db2 -td@ -vf files/db2/createDb.sql -z /tmp/c45/files_create.log ;
db2 -td@ -vf files/db2/appGrants.sql -z /tmp/c45/files_grants.log ;
db2 -td@ -vf forum/db2/createDb.sql -z /tmp/c45/forum_create.log ;
db2 -td@ -vf forum/db2/appGrants.sql -z /tmp/c45/forum_grants.log ;
db2 -tvf homepage/db2/createDb.sql -z /tmp/c45/homepage_create.log ;
db2 -tvf homepage/db2/appGrants.sql -z /tmp/c45/homepage_grants.log ;
db2 -tvf profiles/db2/createDb.sql -z /tmp/c45/profiles_create.log ;
db2 -tvf profiles/db2/appGrants.sql -z /tmp/c45/profiles_grants.log ;
db2 -td@ -vf wikis/db2/createDb.sql -z /tmp/c45/wikis_create.log ;
db2 -td@ -vf wikis/db2/appGrants.sql -z /tmp/c45/wikis_grants.log ;

db2 -td@ -vf metrics/db2/createDb.sql -z /tmp/c45/metrics_create.log ;
db2 -td@ -vf metrics/db2/appGrants.sql -z /tmp/c45/metrics_grants.log ;
db2 -td@ -vf cognos/db2/createDb.sql -z /tmp/c45/cognos_create.log ;
db2 -td@ -vf cognos/db2/appGrants.sql -z /tmp/c45/cognos_grants.log ;

db2 -td@ -vf libraries.gcd/db2/createDb.sql -z /tmp/c45/libraries.gcd_create.log ;
db2 -td@ -vf libraries.gcd/db2/appGrants.sql -z /tmp/c45/libraries.gcd_grants.log ;
db2 -td@ -vf libraries.os/db2/createDb.sql -z /tmp/c45/libraries.os_create.log ;
db2 -td@ -vf libraries.os/db2/appGrants.sql -z /tmp/c45/libraries.os_grants.log ;
db2 -td@ -vf mobile/db2/createDb.sql -z /tmp/c45/mobile_create.log ;
db2 -td@ -vf mobile/db2/appGrants.sql -z /tmp/c45/mobile_grants.log ;

Aplicando o CR4

Desempacotar

mkdir /tmp/45-45cr4
chmod a+rwx /tmp/45-45cr4

cd <DIRETORIO_ONDE_ESTAO_OS_FIXES>

db2 -td@ -vf blogs-fixup_referrer_idex-db2.sql -z /tmp/45-45cr4/blogs-fixup_referrer_idex-db2.sql.log
db2 -td@ -vf files-upgrade-45-45cr3-db2.sql -z /tmp/45-45cr4/files-upgrade-45-45cr3-db2.sql.log
db2 -td@ -vf files-appGrants-db2.sql -z /tmp/45-45cr4/files-appGrants-db2.sql.log
db2 -td@ -vf files-reorg-db2.sql -z /tmp/45-45cr4/files-reorg-db2.sql.log
db2 -td@ -vf files-updateStats-db2.sql -z /tmp/45-45cr4/files-updateStats-db2.sql.log
db2 -tvf homepage-upgrade-45-45CR3-db2.sql -z /tmp/45-45cr4/homepage-upgrade-45-45CR3-db2.sql.log
db2 -tvf homepage-upgrade-45CR3-45CR4-db2.sql -z /tmp/45-45cr4/homepage-upgrade-45CR3-45CR4-db2.sql.log
db2 -td@ -vf communities-fixupGroupProfile-db2.sql -z /tmp/45-45cr4/communities-fixupGroupProfile-db2.sql.log
db2 -td@ -vf wikis-upgrade-45-45cr3-db2.sql -z /tmp/45-45cr4/wikis-upgrade-45-45cr3-db2.sql.log
db2 -td@ -vf wikis-appGrants-db2.sql -z /tmp/45-45cr4/wikis-appGrants-db2.sql.log
db2 -td@ -vf wikis-reorg-db2.sql -z /tmp/45-45cr4/wikis-reorg-db2.sql.log
db2 -td@ -vf wikis-updateStats-db2.sql -z /tmp/45-45cr4/wikis-updateStats-db2.sql.log

db2 -td@ -vf MOBILE-db-upgrade-45-45CR4_DB2.sql -z /tmp/45-45cr4/MOBILE-db-upgrade-45-45CR4_DB2.sql.log

db2 -td@ -vf METRICS-db-upgrade-45-45CR2_DB2.sql     -z /tmp/45-45cr4/METRICS-db-upgrade-45-45CR2_DB2.sql.log
db2 -td@ -vf METRICS-db-reorg-45-45CR2_DB2.sql       -z /tmp/45-45cr4/METRICS-db-reorg-45-45CR2_DB2.sql.log
db2 -td@ -vf METRICS-db-updateStats-45-45CR2_DB2.sql -z /tmp/45-45cr4/METRICS-db-updateStats-45-45CR2_DB2.sql.log
db2 -td@ -vf metrics-fixup-LO77552-db2.sql           -z /tmp/45-45cr4/metrics-fixup-LO77552-db2.sql.log

Preparando o ambiente

Extrair os arquivos de instalação

Procedimento:

1) Criar pasta temporária

# mkdir -p /opt/SharedArea/Binarios/IIM

# cd /opt/SharedArea/Binarios/IIM

2) Desempacotar o IBM Installation Manager

# unzip -o agent.installer.linux.gtk.x86_1.5.3000.20120531_1954.zip -d /opt/SharedArea/Binarios/IIM

Instalando o DMGR

Instalar o Installation Manager

Procedimento:

1) Vá para o diretório

# cd  /opt/SharedArea/Binarios/IIM

2) Execute o IBM Installation Manager

# ./tools/imcl install com.ibm.cic.agent -acceptLicense \
-installationDirectory /opt/IBM/InstallationManager \
-repositories /opt/SharedArea/Binarios/IIM/repository.xml -log /opt/iim.log 
Resultado:
com.ibm.cic.agent_1.5.3000.20120531_1954 instalado no diretório /opt/IBM/InstallationManager/eclipse.

Tuning do Installation Manager

Faça um backup do arquivo

# cp /opt/IBM/InstallationManager/eclipse/IBMIM.ini /opt/IBM/InstallationManager/eclipse/IBMIM.ini_orig
# cp /opt/IBM/InstallationManager/eclipse/tools/imcl.ini /opt/IBM/InstallationManager/eclipse/tools/imcl.ini_orig

Edite o arquivo IBMIM.ini

# vi /opt/IBM/InstallationManager/eclipse/IBMIM.ini

No arquivo, altere as entradas Xms e Xmx para:

-Xms1024m	
-Xmx1024m

Salve e Feche o Arquivo

Edite o arquivo imcl.ini

# vi /opt/IBM/InstallationManager/eclipse/tools/imcl.ini

No arquivo, altere as entradas Xms e Xmx para:

-Xms1024m	
-Xmx1024m

Salve e Feche o Arquivo

Instalando o WAS 8.0 FP6

Procedimento:

1) Vá para o diretório

# cd  /opt/SharedArea/Binarios/

2) Faça o Download do arquivo de resposta

Baixe o arquivo de resposta Desenvolvimento: installWAS8.rsp

3) Execute o comando

# /opt/IBM/InstallationManager/eclipse/tools/imcl -acceptLicense -sVP -log /opt/was.log input installWAS8.rsp
Resultado:
Modified com.ibm.websphere.ND.v80_8.0.6.20130328_1645 to the /opt/IBM/WebSphere/AppServer directory.

Instalando o WAS Fixes

Procedimento:

1) Vá para o diretório

# cd  /opt/SharedArea/Binarios/

2) Faça o Download do arquivo de resposta

Baixe o arquivo de resposta Desenvolvimento: installWAS8Fixes.rsp

3) Execute o comando

# /opt/IBM/InstallationManager/eclipse/tools/imcl -acceptLicense -sVP -log /opt/wasfixes.log input installWAS8Fixes.rsp
Resultado:
Installed 8.0.0.5-WS-WASProd-IFPM81521_8.0.5.20131009_1403 to the /opt/IBM/WebSphere/AppServer directory. 
...
Installed 8.0.0.6-WS-WAS-IFPM94437_8.0.6.20131030_0205 to the /opt/IBM/WebSphere/AppServer directory.

Criando o Profile do DMGR

1) Criar um arquivo com os parâmetros para criação da profile DMGR:

vi /tmp/responseFile_dmgr.txt

2) Informar o seguinte conteúdo no arquivo:

create
profileName=Dmgr01
profilePath=/opt/IBM/WebSphere/AppServer/profiles/Dmgr01
templatePath=/opt/IBM/WebSphere/AppServer/profileTemplates/management
nodeName=<HOSTNAME>Node
cellName=connectionsCell
hostName=<DMGRHOSTNAME>.empresa.com.br
serverType=DEPLOYMENT_MANAGER
enableAdminSecurity=true
isDefault
personalCertValidityPeriod=15
signingCertValidityPeriod=15
adminUserName=wsadmin
adminPassword=<INFORMAR_SENHA>

3) Executar o comando para a criação da profile DMGR:

# cd /opt/IBM/WebSphere/AppServer/bin
# ./manageprofiles.sh -response /tmp/responseFile_dmgr.txt

4) Após a criação do Profile, iniciar o DMGR

# /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin/startManager.sh

Criando o profile do Nó

3.2 Criando o Profile dos Nodes

Para cada servidor WAS executar:

1) Connecte no servidore e cri um arquivo com os parâmetros para criação da profile DMGR:

# vi /tmp/responseFile_node.txt

2) Informar o seguinte conteúdo no arquivo, alterando NN para o número do nó:

create
profileName=AppSrv01
profilePath=/opt/IBM/WebSphere/AppServer/profiles/AppSrv01
templatePath=/opt/IBM/WebSphere/AppServer/profileTemplates/default
nodeName=<HOSTNAME>Node
hostName=<HOSTNAME>.empresa.com.br
dmgrHost=<DMGRHOSTNAME>.empresa.com.br
dmgrPort=8879
dmgrAdminUserName=wsadmin
dmgrAdminPassword=<INFORMAR_SENHA>
personalCertValidityPeriod=15
signingCertValidityPeriod=15

3) Executar o comando para a criação da profile de servidor:

# cd /opt/IBM/WebSphere/AppServer/bin
# ./manageprofiles.sh -response /tmp/responseFile_node.txt

Após a criação do Profile,

Configurar o Acesso ao DB2

Obs.: Crie os diretórios se necessário, com o comando:

# mkdir -p /opt/IBM/db2/V9.7/java

Em cada nó do Application, copie os arquivos:

/opt/IBM/db2/V9.7/java/db2jcc.jar
/opt/IBM/db2/V9.7/java/db2jcc_license_cu.jar