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.
- Log in to the server as instance owner (Linux or UNIX), or Administrator (Windows)
- (Windows only) Open "DB2 Command Window - Administrator"
- 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
- ese single partition
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"}]
Was this topic helpful?
Document Information
Modified date:
27 June 2023
UID
ibm10883930