Updating a database from a host or System i client

Applications executing on host or System i clients can access data residing on Db2® database servers. TCP/IP is the only protocol used for this access.

About this task

Db2 allows TCP/IP two-phase commit access from host or System i clients. There is no need to use the Syncpoint Manager (SPM) when using TCP/IP two-phase commit access.

The Db2 TCP/IP listener must be active on the server to be accessed by the host or System i client.

Procedure

To verify that the TCP/IP listener is active on the server:

  1. Use the db2set command to validate that the registry variable DB2COMM has a value of tcpip.
  2. Use the GET DBM CFG command to check that the database manager configuration parameter svcename is set to the service name .

Results

If the listener is not active, it can be made active by using the db2set command and the UPDATE DBM CFG command.