View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-40) was last changed on 27-May-2010 11:53 by RaffaelePedrini  

This page was created on 14-Apr-2010 14:30 by RaffaelePedrini

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 1 changed 11 lines
INSTALLAZIONE DB2
#tar -xzvf db2exc_LNX_26x86.tar.gz
#lanciare db2_install (./db2_install)
#al prompt eseguire DB2.EXP (non cambiare percorso di installazione che propone e attendere fine installazione)\\in caso di dipendenze sulle librerie installare quanto richiesto (dipende dalla distribuzione/versione di linux ma in genere è necessario libaio1 e libstdc++5)
#eseguire i seguenti comandi\\
groupadd -g 999 db2adm
groupadd -g 998 db2udf
groupadd -g 997 db2prod
useradd -u 1004 -g db2adm -m -d /home/db2adm db2adm
useradd -u 1003 -g db2udf -m -d /home/db2udf db2udf
useradd -u 1002 -g db2prod -m -d /home/db2prod db2prod
[Installazione|db2installazione]\\
[Backup multi-database e esportazione DDL|db2backup]\\
[Backup singolo database e Restore|db2restore]\\
[Indici e auto_runstats]
At line 13 removed 35 lines
passwd db2adm (settando la tua PASSWORD)
passwd db2udf (settando la tua PASSWORD)
passwd db2prod (settando la tua PASSWORD)
in base alla tua versione... (VX_Y)
/opt/ibm/db2/VX.Y/instance/dascrt -u db2adm
/opt/ibm/db2/VX_Y/instance/db2icrt -a server -u db2udf db2prod
/opt/ibm/db2/VX_Y/cfg/db2ln
. /home/db2prod/sqllib/db2profile
su - db2prod (se non ti fa fare come root i seguenti)
db2set DB2COMM=tcpip
db2licm -a [path dove ho fatto il tar]/exp/db2/license/db2expc_uw.lic
gruppo root membro di db2prod
vi /etc/group
db2prod:x:997:root
-------------------------------------------------------------
db2start
db2stop
db2 update dbm cfg using svcename 50000
db2start
(usare db2set -all per vedere quelle già esistenti)
db2set DB2COMM=tcpip
db2set DB2AUTOSTART=yes
--------------------------------------------------------------
A livello generale vi /etc/profiles
aggiungere
. /home/db2prod/sqllib/db2profile
Version Date Modified Size Author Changes ... Change note
40 27-May-2010 11:53 0.17 kB RaffaelePedrini to previous
39 14-Apr-2010 14:30 0.168 kB RaffaelePedrini to previous | to last
38 14-Apr-2010 14:30 0.142 kB RaffaelePedrini to previous | to last
37 14-Apr-2010 14:30 0.091 kB RaffaelePedrini to previous | to last
36 14-Apr-2010 14:30 0.056 kB RaffaelePedrini to previous | to last
35 14-Apr-2010 14:30 7.65 kB RaffaelePedrini to previous | to last
34 14-Apr-2010 14:30 7.65 kB RaffaelePedrini to previous | to last
33 14-Apr-2010 14:30 7.648 kB RaffaelePedrini to previous | to last
32 14-Apr-2010 14:30 7.592 kB RaffaelePedrini to previous | to last
31 14-Apr-2010 14:30 7.664 kB RaffaelePedrini to previous | to last
30 14-Apr-2010 14:30 7.366 kB RaffaelePedrini to previous | to last
29 14-Apr-2010 14:30 7.356 kB RaffaelePedrini to previous | to last
28 14-Apr-2010 14:30 7.079 kB RaffaelePedrini to previous | to last
27 14-Apr-2010 14:30 5.182 kB RaffaelePedrini to previous | to last
26 14-Apr-2010 14:30 5.05 kB RaffaelePedrini to previous | to last
25 14-Apr-2010 14:30 4.053 kB RaffaelePedrini to previous | to last
24 14-Apr-2010 14:30 3.979 kB RaffaelePedrini to previous | to last
23 14-Apr-2010 14:30 3.97 kB RaffaelePedrini to previous | to last
22 14-Apr-2010 14:30 3.964 kB RaffaelePedrini to previous | to last
21 14-Apr-2010 14:30 3.698 kB RaffaelePedrini to previous | to last
« This page (revision-40) was last changed on 27-May-2010 11:53 by RaffaelePedrini