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 60 lines
!!INSTALLAZIONE DB2
#tar -xzvf db2XXXXX.tar.gz (XXX dipende dalla versione db2 che vuoi installare...ad esempio db2exc_950_LNX_x86.tar.gz)
#lanciare db2_install (./db2_install)
#al prompt eseguire DB2.EXP o 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 TUONOMEISTANZADB2\\
useradd -u 1004 -g db2adm -m -d /home/db2adm db2adm\\
useradd -u 1003 -g db2udf -m -d /home/db2udf db2udf\\
useradd -u 1002 -g TUONOMEISTANZADB2 -m -d /home/TUONOMEISTANZADB2 TUONOMEISTANZADB2\\
\\
passwd db2adm (settando la tua PASSWORD)\\
passwd db2udf (settando la tua PASSWORD)\\
passwd TUONOMEISTANZADB2 (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 TUONOMEISTANZADB2\\
/opt/ibm/db2/VX_Y/cfg/db2ln\\
. /home/TUONOMEISTANZADB2/sqllib/db2profile\\
\\
su - TUONOMEISTANZADB2 (se non ti fa fare come root i seguenti)\\
%%prettyif
{{{
db2set DB2COMM=tcpip\\
db2licm -a 'path_dove_ho_fatto_il_tar'/exp/db2/license/db2expc_uw.lic\\
exit
}}}
Assegno il gruppo root come membro di TUONOMEISTANZADB2(faccio girare db2 come utente root)\\
\\
vi /etc/group\\
TUONOMEISTANZADB2: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/TUONOMEISTANZADB2/sqllib/db2profile
----
! DB2 EXPRESS RESTRICTION
What are the restrictions for DB2 Express-C? \\
The following restrictions apply:\\
DB2 Express-C Version 9.5, Fixed Term License (FTL):\\
Two processor cores with a total of maximum of four cores \\
No more than 4 GB of memory \\
DB2 Express-C Version 9.5 (no charge, non-warranted):\\
Up to two processor cores \\
No more than 2 GB of memory \\
[http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.licensing.doc/doc/r0053243.html]
[Installazione|db2installazione]\\
[Backup multi-database e esportazione DDL|db2backup]\\
[Backup singolo database e Restore|db2restore]\\
[Indici e auto_runstats]
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