Skip to content

Instantly share code, notes, and snippets.

@yasu47b

yasu47b/DB2_EXPRESS.md

Last active November 25, 2016 02:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yasu47b/9174fd34328ade26f0fede95185de3cd to your computer and use it in GitHub Desktop.
Save yasu47b/9174fd34328ade26f0fede95185de3cd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DB2_EXPRESS.md

Environment

  • CentOS 6.7
  • DB2 Express v10.5

Connection Setting

DB2 connection setting to allow external connection using TCP/IP.

# edit service file
$ sudo vi /etc/services
# add bellow
db2c_db2inst1  50000/tcp # DB2 connection service port

# update configuration to enable tcp/ip
$ db2 update database manager configuration using svcename 50000
$ db2set DB2COMM=tcpip 

# restart db2
$ db2stop (or db2stop force)
$ db2start

reference

DB2 サーバー通信の構成 (TCP/IP)

TCP/IP 通信のためのサーバー上のサービス・ファイルの更新

TCP/IP 通信のためのサーバー上のデータベース・マネージャー構成ファイルの更新

DB2 インスタンスの通信プロトコルの設定

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment