DB2 TSA資源檢視

DB2 TSA建立詳見:​

檢視tsa叢集配置

1.建立完畢後，可以使用db2inst1使用者檢視資源配置​​

[db2inst1@tsa01 ~]$ db2pd -ha
           DB2 HA Status 
Instance Information:
Instance Name                  = db2inst1          
Number Of Domains              = 1         
Number Of RGs for instance     = 2         

Domain Information:
Domain Name                    = db2ha                   
Cluster Version                = 3.2.5.3   
Cluster State                  = Online    
Number of nodes                = 2         

Node Information:
Node Name                     State                         
---------------------         -------------------           
tsa02                         Online                        
tsa01                         Online                        

Resource Group Information:
Resource Group Name            = db2_db2inst1_db2inst1_TESTDB-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                 
   -------------                 
   tsa01                         
   tsa02                         
Member Resource Information:
   Resource Name                  = db2_db2inst1_db2inst1_TESTDB-rs
   Resource State                 = Online    
   Resource Type                  = HADR      
   HADR Primary Instance          = db2inst1                      
   HADR Secondary Instance        = db2inst1                      
   HADR DB Name                   = TESTDB                        
   HADR Primary Node              = tsa01                         
   HADR Secondary Node            = tsa02                         

Resource Group Name            = db2_db2inst1_tsa01_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                 
   -------------                 
   tsa01                         
Member Resource Information:
   Resource Name                  = db2_db2inst1_tsa01_0-rs
   Resource State                 = Online    
   Resource Type                  = DB2 Member
   DB2 Member Number              = 0         
   Number of Allowed Nodes        = 1         
      Allowed Nodes                 
      -------------                 
      tsa01                         

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

   Node Name                     Adapter Name             
   -----------------------       ------------------       
   tsa02                         enp0s3                   
   tsa01                         enp0s3                   

Quorum Information:
Quorum Name                                  Quorum State                       
------------------------------------         --------------------               
db2_Quorum_Network_192_168_56_1:11_48_50     Online                             
Success                                      Offline                            
Fail                                         Offline                            
Operator                                     Offline   


[db2inst1@tsa02 ~]$ db2pd -ha
           DB2 HA Status 
Instance Information:
Instance Name                  = db2inst1          
Number Of Domains              = 1         
Number Of RGs for instance     = 2         

Domain Information:
Domain Name                    = db2ha                   
Cluster Version                = 3.2.5.3   
Cluster State                  = Online    
Number of nodes                = 2         

Node Information:
Node Name                     State                         
---------------------         -------------------           
tsa02                         Online                        
tsa01                         Online                        

Resource Group Information:
Resource Group Name            = db2_db2inst1_db2inst1_TESTDB-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                 
   -------------                 
   tsa01                         
   tsa02                         
Member Resource Information:
   Resource Name                  = db2_db2inst1_db2inst1_TESTDB-rs
   Resource State                 = Online    
   Resource Type                  = HADR      
   HADR Primary Instance          = db2inst1                      
   HADR Secondary Instance        = db2inst1                      
   HADR DB Name                   = TESTDB                        
   HADR Primary Node              = tsa01                         
   HADR Secondary Node            = tsa02                         

Resource Group Name            = db2_db2inst1_tsa02_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                 
   -------------                 
   tsa02                         
Member Resource Information:
   Resource Name                  = db2_db2inst1_tsa02_0-rs
   Resource State                 = Online    
   Resource Type                  = DB2 Member
   DB2 Member Number              = 0         
   Number of Allowed Nodes        = 1         
      Allowed Nodes                 
      -------------                 
      tsa02                         

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

   Node Name                     Adapter Name             
   -----------------------       ------------------       
   tsa02                         enp0s3                   
   tsa01                         enp0s3                   

Quorum Information:
Quorum Name                                  Quorum State                       
------------------------------------         --------------------               
db2_Quorum_Network_192_168_56_1:11_48_50     Online                             
Success                                      Offline                            
Fail                                         Offline                            
Operator                                     Offline      

2.在tsa01和tsa02節點執行

[db2inst1@tsa01 ~]$ lsrg
Resource Group names:
db2_db2inst1_db2inst1_TESTDB-rg  
db2_db2inst1_tsa01_0-rg          
db2_db2inst1_tsa02_0-rg 

[db2inst1@tsa02 ~]$  lsrg
Resource Group names:
db2_db2inst1_db2inst1_TESTDB-rg  
db2_db2inst1_tsa01_0-rg          
db2_db2inst1_tsa02_0-rg      

3.也可以使用root檢視

[root@tsa01 ~]# lssam
Online IBM.ResourceGroup:db2_db2inst1_db2inst1_TESTDB-rg Nominal=Online
        '- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs
                |- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:tsa01
                '- Offline IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:tsa02
Online IBM.ResourceGroup:db2_db2inst1_tsa01_0-rg Nominal=Online
        '- Online IBM.Application:db2_db2inst1_tsa01_0-rs
                '- Online IBM.Application:db2_db2inst1_tsa01_0-rs:tsa01
Online IBM.ResourceGroup:db2_db2inst1_tsa02_0-rg Nominal=Online
        '- Online IBM.Application:db2_db2inst1_tsa02_0-rs
                '- Online IBM.Application:db2_db2inst1_tsa02_0-rs:tsa02
Online IBM.Equivalency:db2_db2inst1_db2inst1_TESTDB-rg_group-equ
        |- Online IBM.PeerNode:tsa01:tsa01
        '- Online IBM.PeerNode:tsa02:tsa02
Online IBM.Equivalency:db2_db2inst1_tsa01_0-rg_group-equ
        '- Online IBM.PeerNode:tsa01:tsa01
Online IBM.Equivalency:db2_db2inst1_tsa02_0-rg_group-equ
        '- Online IBM.PeerNode:tsa02:tsa02
Online IBM.Equivalency:db2_public_network_0
        |- Online IBM.NetworkInterface:enp0s3:tsa01
        '- Online IBM.NetworkInterface:enp0s3:tsa02

[root@tsa02 ~]# lssam
Online IBM.ResourceGroup:db2_db2inst1_db2inst1_TESTDB-rg Nominal=Online
        '- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs
                |- Online IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:tsa01
                '- Offline IBM.Application:db2_db2inst1_db2inst1_TESTDB-rs:tsa02
Online IBM.ResourceGroup:db2_db2inst1_tsa01_0-rg Nominal=Online
        '- Online IBM.Application:db2_db2inst1_tsa01_0-rs
                '- Online IBM.Application:db2_db2inst1_tsa01_0-rs:tsa01
Online IBM.ResourceGroup:db2_db2inst1_tsa02_0-rg Nominal=Online
        '- Online IBM.Application:db2_db2inst1_tsa02_0-rs
                '- Online IBM.Application:db2_db2inst1_tsa02_0-rs:tsa02
Online IBM.Equivalency:db2_db2inst1_db2inst1_TESTDB-rg_group-equ
        |- Online IBM.PeerNode:tsa01:tsa01
        '- Online IBM.PeerNode:tsa02:tsa02
Online IBM.Equivalency:db2_db2inst1_tsa01_0-rg_group-equ
        '- Online IBM.PeerNode:tsa01:tsa01
Online IBM.Equivalency:db2_db2inst1_tsa02_0-rg_group-equ
        '- Online IBM.PeerNode:tsa02:tsa02
Online IBM.Equivalency:db2_public_network_0
        |- Online IBM.NetworkInterface:enp0s3:tsa01
        '- Online IBM.NetworkInterface:enp0s3:tsa02      

4.檢視domain和node

[root@tsa01 ~]# lsrpdomain 
Name  OpState RSCTActiveVersion MixedVersions TSPort GSPort 
db2ha Online  3.2.5.3           No            12347  12348  
[root@tsa01 ~]#  lsrpnode
Name  OpState RSCTVersion 
tsa02 Online  3.2.5.3     
tsa01 Online  3.2.5.3     
[root@tsa01 ~]# lsrg
Resource Group names:
db2_db2inst1_db2inst1_TESTDB-rg  
db2_db2inst1_tsa01_0-rg          
db2_db2inst1_tsa02_0-rg       

[root@tsa02 ~]# lsrpdomain
Name  OpState RSCTActiveVersion MixedVersions TSPort GSPort 
db2ha Online  3.2.5.3           No            12347  12348  
[root@tsa02 ~]# lsrpnode
Name  OpState RSCTVersion 
tsa02 Online  3.2.5.3     
tsa01 Online  3.2.5.3     
[root@tsa02 ~]# lsrg
Resource Group names:
db2_db2inst1_db2inst1_TESTDB-rg  
db2_db2inst1_tsa01_0-rg          
db2_db2inst1_tsa02_0-rg