IBM Support

[Db2] How to identify the instance type.

Question & Answer


Question

How can I identify the instance type for given Db2 instance?

Cause

Db2 supports the following instance type:
  • client: default instance type for Data Server Client.
  • wse: default instance type for Workgroup Server Edition (v10.1 or earlier), Express Editions, Db2 Connect Servers.
    NOTE wse instance is no longer supported in Db2 11.5 or later.
  • ese: default instance type for Workgroup Server Edition (v10.5 or later), Enterprise Server Edition, Standard Edition, Advanced Editions.
  • dsf: instance type for pureScale.
Some of configuration parameters, files, or paths are different among the instance types, so you might want to identify your current instance type.

Answer

The current instance type is printed in your database manager configuration.
So, run GET DBM CFG command to identify the instance type.
  1. Log in to the server as instance owner (Linux or UNIX), or Administrator (Windows)
  2. (Windows only) Open "DB2 Command Window - Administrator"
  3. Run GET DBM CFG command, then see "Node Type" 
    db2 get dbm cfg
    Possible Node type and corresponding instance types are:
    Possible instance types
    Node Type in dbm cfg Instance type
    Enterprise Server Edition with local and remote clients ese or dsf
    Database Server with local and remote clients wse
    Client client
    You need to examine db2nodes.cfg file to identify the following instance type.
    db2nodes.cfg file is located at $HOME/sqllib/db2nodes.cfg in Linux and Unix, %ProgramData%\IBM\DB2\<COPY_NAME>\<INSTANCE_NAME>\db2nodes.cfg in Windows.
    • ese single partition
      db2nodes.cfg contains only one line like as followings:
      0 server1 0 server1
    • ese multi-nodes (DPF)
      db2nodes.cfg contains more than one line like as followings:
      0 server1 0 server1
1 server2 0 server2
    • dsf (pureScale)
      db2nodes.cfg contains more than one line, and ends with MEMBER or CF like as followings:
      0 server1 0 server1 - MEMBER
1 server2 0 server2 - MEMBER
2 server3 0 server3 - MEMBER
128 server4 0 server4 - CF
129 server5 0 server5 - CF
See the manual page for details of db2nodes.cfg file.
Note: Db2 11.5 does not support wse instance, but db2iupgrade might fail to upgrade instance type for an existing wse instance. See the following APAR for details.

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PlUAAU","label":"Database Objects-\u003EInstance"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]

Document Information

Modified date:
27 June 2023

UID

ibm10883930

Page Feedback