DB2 UDB Cluster Discovery to have types HADR, Client, Enterprise Server Edition, Database Server.

Idea ID 1685463

Re: DB2 UDB Cluster Discovery

DB2 dsicovery of databases does not show capture database clusters. One will enable when Failover occurs the app will have the Standby Cluster to be able to see it otherwise we will not be know the inactive CI.

It should not connect to those but it needs to have the database kept alive and identified as in standby  mode

The command is

db2 get db cfg for $dbname | grep "HADR database role" |  cut -d'=' -f2 |cut -d' ' -f2

 

Then if = STANDBY then …. 

 

One way to identify if it is Client or database or connect gateway is by running the below command.

 

db2 get dbm cfg | grep "Node type"

 

For Clients ->

 

Node type = Client

 

For Databases ->

 

Node type = Enterprise Server Edition with local and remote clients

 

For Db2 Connect Gateway  ->

 

Node type = Database Server with local and remote clients

Tags (4)
3 Comments
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes

The idea has received an initial review to ensure adherence to our idea submission and community guidelines. More information may be needed at this stage and we expect the community to help prioritize the idea with comments and voting

Makhosonkek Trusted Contributor.
Trusted Contributor.

I have the same issue in my environment, trying to discover DB2 clusters. Would like to have this as we use this information for billing.

Super Contributor.. LeeWidman Super Contributor..
Super Contributor..

The command is

 

db2 get db cfg for $dbname | grep "HADR database role" |  cut -d'=' -f2 |cut -d' ' -f2

 

Then if = STANDBY then …. 

 

 

One way to identify if it is Client or database or connect gateway is by running the below command.

 

db2 get dbm cfg | grep "Node type"

 

For Clients ->

 

Node type = Client

 

For Databases ->

 

Node type = Enterprise Server Edition with local and remote clients

 

For Db2 Connect Gateway ->

 

Node type = Database Server with local and remote clients

 

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.