Sunday, 17 February 2019

DB2 - VIP instance list and Primary Node

Run the following command to get the Database name.






db2 get db cfg for DB2|grep HADR

output would something like

 HADR database role                                      = PRIMARY
 HADR local host name                  (HADR_LOCAL_HOST) = NameOfPrimaryNode
 HADR local service name                (HADR_LOCAL_SVC) = hadr01
 HADR remote host name                (HADR_REMOTE_HOST) = NameOfSecondyNode
 HADR remote service name              (HADR_REMOTE_SVC) = hadr01


No comments:

Post a Comment