DB2: db2haicu how to check if enabled

 If not enabled:

$ db2pd -ha

           DB2 HA Status

No valid HA environment detected.

[prd1ins1@db2prd603  ~]






If enabled:
$ db2pd -ha
           DB2 HA Status
Instance Information:
Instance Name                  = prd1ins1
Number Of Domains              = 1
Number Of RGs for instance     = 2

Domain Information:
Domain Name                    = prdtsa
Cluster Version                = 3.2.4.4
Cluster State                  = Online
Number of nodes                = 2

Node Information:
Node Name                     State
---------------------         -------------------
db2prd601                     Online
db2prd602                     Online

Resource Group Information:
Resource Group Name            = db2_prd1ins1_prd1ins1_WCPRD1-rg
Resource Group LockState       = Unlocked
Resource Group OpState         = Online
Resource Group Nominal OpState = Online
Number of Group Resources      = 1
Number of Allowed Nodes        = 2
   Allowed Nodes
   -------------
   db2prd601
   db2prd602
Member Resource Information:
   Resource Name                  = db2_prd1ins1_prd1ins1_WCPRD1-rs
   Resource State                 = Online
   Resource Type                  = HADR
   HADR Primary Instance          = prd1ins1
   HADR Secondary Instance        = prd1ins1
   HADR DB Name                   = WCPRD1
   HADR Primary Node              = db2prd601
   HADR Secondary Node            = db2prd602

Resource Group Name            = db2_prd1ins1_db2prd602_0-rg
Resource Group LockState       = Unlocked
Resource Group OpState         = Online
Resource Group Nominal OpState = Online
Number of Group Resources      = 1
Number of Allowed Nodes        = 1
   Allowed Nodes
   -------------
   db2prd602
Member Resource Information:
   Resource Name                  = db2_prd1ins1_db2prd602_0-rs
   Resource State                 = Online
   Resource Type                  = DB2 Member
   DB2 Member Number              = 0
   Number of Allowed Nodes        = 1
      Allowed Nodes
      -------------
      db2prd602

Network Information:
Network Name                  Number of Adapters
-----------------------       ------------------
db2_public_network_0          2

   Node Name                     Adapter Name
   -----------------------       ------------------
   db2prd602.c.prod-db2-1-b34c.internaleth0
   db2prd601.c.prod-db2-1-b34c.internaleth0

Quorum Information:
Quorum Name                                  Quorum State
------------------------------------         --------------------
Operator                                     Offline
Success                                      Offline
db2_Quorum_Network_169_254_169_254:13_15_51  Online
Fail                                         Offline
[prd1ins1@db2prd602  ~]

Comments

Post a Comment

Popular posts from this blog

Postgres: Clean up stopped replication slot

Image
  When a slot is inactive, that means that Murty and his team have stopped the replication on their side. The SQL below will identify inactive slots. We should schedule this script in a job , running every hour.    (1) SELECT  slot_name,  pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(),restart_lsn)) AS size,  active,  slot_type  FROM pg_replication_slots;       (2) Once you identify the replication slot, the job should drop it with the following command:     SELECT pg_drop_replication_slot ('pg_replication_slot_name_from_above');         (3) Restart the database instance to clean up unwanted disk space.   Notes from Google:- Thank you for contacting Google Cloud Support. My name is Jagadeesh and I will be assisting you with this issue.   I understand that WAL logs are expanding to over 1.5TB and you want to know what is causing WAL logs to grow and you want to reduce it. Please confirm if ...
Read more