Select the installation version:
Select keyword Installation
DB2 Products,
V10.5 version, select Input Server (server) here
Server Edition
CONSV Linked Server Edition
EXP Simple Version
Client Data Server Clients
RTCL data Server run-time client
/opt/ibm/db2/v10.5/adm/db2licm-a/tmp/db2/db2ese_10.5_c.lic
[Email protected] ~]#/opt/ibm/db2/v10.5/instance/dascrt-u db2fenc1
/opt/ibm/db2/v10.5/instance/dascrt-u db2fenc1
Das is a DB2 Management Server (DB2 administrative server) and is used only to assist tasks on DB2S DB instances
A simple understanding is that DAS enables remote DB2 clients to connect to the database server in a graphical manner.
The instance provides an independent database and a running environment for the program.
Linux: the instance name remains the same as one of the Linux user names. You need to add the appropriate user before creating the instance.
/opt/ibm/db2/v10.5/instance/db2icrt-u Db2inst1 Db2inst1
if [-f/home/db2inst1/sqllib/db2profile]; Then
. /home/db2inst1/sqllib/db2profile
Fi
Configuring TCP/IP communication for the DB2 server
Db2set-all
Db2set Db2comm=tcpip
[Email protected] ~]$ cat/etc/services |grep DB2
Db2_db2inst1
More/etc/services |grep Db2inst1
[[Email protected] ~]$ DB2 update dbm CFG using SVCENAME db2_db2inst1 60000
[[Email protected] ~]$ DB2 get dbm CFG |grep SVCENAME
Initializing the database
/home/db2inst1/sqllib/bin/db2sampl
The basic steps for connecting to a remote database server are as follows.
The remote node is cataloged on the client computer. The remote database is cataloged on the client computer. Connect to the remote database.
1. First step: The remote node is cataloged on the client computer, where the user needs to confirm the name, IP address and port number of the remote host on the client.
The following basic commands are involved:
C:\Documents and SETTINGS\ADMINISTRATOR>DB2 Catalog tcpip node Serv remote 172.16.227.3 server 50000
2.TERMINATE----------------//Refresh directory Cache
3.LIST node Directory----------------//view Client directory nodes
2. Second step: Cataloging the Cataloged node database, where the user needs to confirm the remote connection database name, the database alias on the local computer, the first step to confirm the remote host on the client alias is the node name and set authentication mode.
The following commands are involved:
C:\Documents and SETTINGS\ADMINISTRATOR>DB2 Catalog db TESTDB2 as CC at node serv
2.TERMINATE--------//Refresh directory Cache
3.LIST DB Directory--------------//view Local database directories
3. Step Three:
Connect to the remote database, where the user uses the second step to confirm the connection to the database by using an alias on the local machine. The following commands are involved:
CONNECT to serv USER db2inst1 USING 123456
V10 later version of the website download!
DB2 8.2
Windows 32-bit: ftp://public.dhe.ibm.com/ps/products/db2/fixes2/english-us/db2winIA32v8/fixpak/FP18_WR21443/FP18_ Wr21443_ese.exe
DB2 9.1
Windows 32-bit: Http://delivery04.dhe.ibm.com/sar/CMA/IMA/00vcl/0/v9fp9_win_ese.exe
Windows 64-bit: Http://delivery04.dhe.ibm.com/sar/CMA/IMA/00vcw/0/v9fp9_winx64_ese.exe
Windows 64-bit Itanium:http://delivery04.dhe.ibm.com/sar/cma/ima/00vj9/0/v9fp9_win64_ese.exe
Linux 32-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/00vem/0/v9fp9_linux_ese.tar.gz
Linux 64-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/00vft/0/v9fp9_linuxx64_universal_fixpack.tar.gz
HP Unix 64-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/00ve6/0/v9fp9_hppa_universal_fixpack.tar.gz
DB2 9.5
Windows 32-bit: Http://delivery04.dhe.ibm.com/sar/CMA/IMA/02bok/1/v9.5fp7_nt32_server.exe
Windows 64-bit: Http://delivery04.dhe.ibm.com/sar/CMA/IMA/02box/1/v9.5fp7_ntx64_server.exe
Linux 32-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/02bnv/0/v9.5fp7_linuxia32_universal_fixpack.tar.gz
Linux 64-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/02bni/0/v9.5fp7_linuxx64_universal_fixpack.tar.gz
Aix 64-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/02bmd/0/v9.5fp7_aix64_universal_fixpack.tar.gz
HP Unix 64-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/02bmr/0/v9.5fp7_hpipf64_universal_fixpack.tar.gz
DB2 9.7
Windows 32-bit: Http://delivery04.dhe.ibm.com/sar/CMA/IMA/0152u/1/v9.7fp3a_nt32_universal_fixpack.exe
Windows 64-bit: Http://delivery04.dhe.ibm.com/sar/CMA/IMA/01534/1/v9.7fp3a_ntx64_universal_fixpack.exe
Linux 32-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/0152j/1/v9.7fp3a_linuxia32_universal_fixpack.tar.gz
Linux 64-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/01523/1/v9.7fp3a_linuxx64_universal_fixpack.tar.gz
Aix 64-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/0150o/1/v9.7fp3a_aix64_universal_fixpack.tar.gz
HP Unix 64-bit: http://delivery04.dhe.ibm.com/sar/CMA/IMA/01512/1/v9.7fp3a_hpipf64_universal_fixpack.tar.gz
DB2 V10 installation
