DB2: Instalando o DB2 no AIX: Difference between revisions

From Wiki
No edit summary
Line 63: Line 63:
  mkgroup id=998 db2fadm1
  mkgroup id=998 db2fadm1
  mkgroup id=997 dasadm1
  mkgroup id=997 dasadm1
 
 
  mkuser id=1004 pgrp=db2iadm1 groups=db2iadm1 home=/home/db2inst1 db2inst1  
  mkuser id=1004 pgrp=db2iadm1 groups=db2iadm1 home=/home/db2inst1 db2inst1  
  mkuser id=1003 pgrp=db2fadm1 groups=db2fadm1 home=/home/db2fenc1 db2fenc1  
  mkuser id=1003 pgrp=db2fadm1 groups=db2fadm1 home=/home/db2fenc1 db2fenc1  
Line 71: Line 71:
  passwd db2fenc1
  passwd db2fenc1
  passwd dasusr1
  passwd dasusr1


== Criando a instância do DB2 ==
== Criando a instância do DB2 ==

Revision as of 12:35, 29 January 2013

Nesta série de artigos estarei mostrando como instalar o IBM DB2 Enterprise Edition no AIX.


Realizando a Instalação

export JAVA_COMPILER=none


Extraindo os arquivos

No diretório onde estão o arquivo .tar.gz, faça o seguinte


Crie um diretório para descompactar

# mkdir -p /root/db2Inst
# cd /root/db2Inst

Extraia os arquivos

> tar -xvzf ../DB2_ESE_97_AIX64.tar.gz

Instalando o DB2

# cd ese

# ./db2_install

Definindo o local de instalação

Default directory for installation of products - /opt/ibm/db2/V9.7

***********************************************************
Do you want to choose a different directory to install [yes/no] ? 

digite no

Informe o produto a ser instalado:

Specify one of the following keywords to install DB2 products.

 ESE
 CLIENT
 RTCL

Enter "help" to redisplay product names.

Enter "quit" to exit.

***********************************************************

Digite

ESE

e aguarde o final da instalação.

Criando os usuários de Administração

mkgroup id=999 db2iadm1
mkgroup id=998 db2fadm1
mkgroup id=997 dasadm1
mkuser id=1004 pgrp=db2iadm1 groups=db2iadm1 home=/home/db2inst1 db2inst1 
mkuser id=1003 pgrp=db2fadm1 groups=db2fadm1 home=/home/db2fenc1 db2fenc1 
mkuser id=1002 pgrp=dasadm1  groups=dasadm1  home=/home/dasusr1 dasusr1   
passwd db2inst1
passwd db2fenc1
passwd dasusr1

Criando a instância do DB2

# cd /opt/ibm/db2/V9.7/instance/
# ./db2icrt -a server -u db2fenc1 db2inst1
DBI1070I Program db2icrt completed successfully. 


Vericando as portas configuradas no arquivo /etc/services do AIX.

# cat /etc/services 

Insira as seguintes linhas:

DB2_db2inst1    60000/tcp
DB2_db2inst1_1  60001/tcp
DB2_db2inst1_2  60002/tcp
DB2_db2inst1_END        60003/tcp

Verificando a licença

# su - db2inst1 

$  db2licm -l
Product name:                     "DB2 Enterprise Server Edition"
License type:                     "License not registered"
Expiry date:                      "License not registered"
Product identifier:               "db2ese"
Version information:              "9.7"


Se for necessário adicionar a licença, o comando é o seguinte:

db2licm -a db2ese_c.lic

Finalizando

# su - db2inst1

$ db2 get dbm cfg
$ db2 update dbm cfg using SVCENAME DB2_db2inst1

$db2set db2comm=tcpip
$db2set DB2AUTOSTART=yes

$db2start

Pronto!!!!