DB2 connection Server Configuration

I believe everyone knows about the DB2 connection server method. The following describes how to configure the DB2 connection server. I hope it will help you learn how to connect to the server.

Check the server configuration as follows:

Verify the existing DB2 database
Db2 list db directory
Db2 list db directory show detail
Verify the communication protocol used by the instance and view the DB2COMM variable.
Db2set-all
View the configuration of the Database Manager and view the SVCENAME, which is specific to the tcpip protocol)
Db2 get dbm cfg
Check whether/etc/services has a port corresponding to the SVCENAME above, for example:
Db2cdb250000/tcp

To check whether the server is listening, use netstat-an to check whether the port is in the LISTEN status.

(From IBM)
Prepare a DB2 server for remote connection

Before the DB2 client can connect to the database, ensure that the server-side communication is correctly configured. Prepare to use the server for TCP/IP and NetBIOS connection:

Set the DB2 profile registry DB2COMM to enable the instance to support specified communication, as shown below:

Db2set DB2COMM = TCPIP, NETBIOS

Set required information for each supported protocol in the Database Manager configuration file.
For TCP/IP, assign a port number to each instance that supports TCP/IP. A file named services contains the service and its port number defined on the system. The location of the file depends on the platform. For example, on UNIX, it is usually stored in/etc.

Since a port number can only be used by one service, we recommend that you use the services file as the central location for maintaining the list of all services and their associated port numbers. To retain TCP port 50000 to a service named db2icdb2, You can append the following lines to the services file:
Db2icdb2 50000/tcp

Update the Database Manager configuration file so that DB2 will use the port number related to the service db2icdb2 for the instance you are using:

Db2 update database manager configuration using svcename db2icdb2

If you choose not to use the services file, you only need to update svcename with the correct port number:

Db2 update database manager configuration using svcename 50000

For NetBIOS, you only need to enter the NetBIOS workstation name nname in the Database Manager Configuration File ):
Db2 update database manager configuration using nname DB2NTSERV

The svcename and nname parameters cannot be configured online. Stop the instance and restart it so that the new value can be used:

Db2stop
Db2start

Learn about the DB2 lock types

Solution to db2 tablespace lock

SQL statement for creating tables in DB2 with Constraints

It is not allowed to set the db2 primary key to solve the problem.

How to Create a tablespace in DB2