Shulou(Shulou.com)06/01 Report--

Select the installation version:

Select keyword installation

DB2 products

V10.5 version, where you choose to enter SERVER (server)

SERVER server version

CONSV Link Server Edition

EXP simplified version

CLIENT data server client

RTCL data server runtime client

/ opt/ibm/db2/V10.5/adm/db2licm-a / tmp/db2/db2ese_10.5_c.lic

[root@oracle-45] # / opt/ibm/db2/V10.5/instance/dascrt-u db2fenc1

/ opt/ibm/db2/V10.5/instance/dascrt-u db2fenc1

DAS, the DB2 Management Server (DB2 Administrative Server), is only used to assist tasks on the DB2s database instance

The simple understanding is that DAS enables remote DB2 clients to connect to the database server in a graphical interface.

The instance provides a separate database and running environment for the program.

Under Linux: the instance name should be the same as one of the Linux usernames. 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

Configure TCP/IP communication for the DB2 server

Db2set-all

Db2set DB2COMM=tcpip

[db2inst1@xuhz ~] $cat / etc/services | grep DB2

DB2_db2inst1

More / etc/services | grep db2inst1

[db2inst1@xuhz ~] $db2 update dbm cfg using SVCENAME DB2_db2inst1 60000

[db2inst1@xuhz ~] $db2 get dbm cfg | grep SVCENAME

Initialize the database

/ home/db2inst1/sqllib/bin/db2sampl

The basic steps for connecting to a remote database server are as follows.

Cataloging remote nodes on the client. Cataloging the remote database on the client. Connect to the remote database.

1. The first step: the first step is to catalog the remote node on the client, where the user needs to confirm the name, IP address and port number of the remote host on the client.

The basic commands involved are as follows:

C:\ Documents and Settings\ Administrator > db2 catalog tcpip node serv remote 172.16.227.3 server 50000

2.TERMINATE-// flushes the directory cache

3.LIST NODE DIRECTORY-/ / View client directory node

two。 The second step: cataloging the cataloged node database, here the user needs to confirm the database name of the remote connection, the alias of the database on the local machine, the alias of the remote host on the client confirmed in the first step, that is, the node name and set the authentication method.

The commands involved are as follows:

C:\ Documents and Settings\ Administrator > db2 catalog db testdb2 as cc at node serv

2.TERMINATE-/ / refresh the directory cache

3.LIST DB DIRECTORY- / / View the local database directory

3. Step 3:

Connect to the remote database, where the user uses the alias on the local machine of the database that needs to be connected as confirmed in step 2. The commands involved are as follows:

CONNECT TO serv USER db2inst1 USING 123456

The version after V10 can be downloaded from the official website!

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.