签到成功

知道了

CNDBA社区CNDBA社区

DB2 TSA资源查看

2022-01-09 12:07 2607 0 原创 DB2
作者： hbhe0316
本文链接：http://www.cndba.cn/hbhe0316/article/103916

DB2 TSA创建详见:
https://www.cndba.cn/hbhe0316/article/103915http://www.cndba.cn/hbhe0316/article/103916http://www.cndba.cn/hbhe0316/article/103916

查看tsa集群配置
1.创建完毕后，可以使用db2inst1用户查看资源配置

http://www.cndba.cn/hbhe0316/article/103916
http://www.cndba.cn/hbhe0316/article/103916
http://www.cndba.cn/hbhe0316/article/103916

[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节点执行http://www.cndba.cn/hbhe0316/article/103916http://www.cndba.cn/hbhe0316/article/103916http://www.cndba.cn/hbhe0316/article/103916

http://www.cndba.cn/hbhe0316/article/103916 

[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

http://www.cndba.cn/hbhe0316/article/103916 

[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

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
hbhe0316

hbhe0316

关注

1.只有承认无知，才能装下新的东西； 2.进步来自一点点滴滴的积累； 3.广博让你更优秀，而专业让你无法替代； 4.挫折和失败能够转换为一种财富。

  • 889
    原创
  • 1
    翻译
  • 13
    转载
  • 24
    评论
  • 访问：2588014次
  • 积分：1523
  • 等级：核心会员
  • 排名：第6名
精华文章

    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ