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-rgResource 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-rgResource 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-rgResource 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-rgResource 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 ~]$ lsrgResource Group names:db2_db2inst1_db2inst1_TESTDB-rg db2_db2inst1_tsa01_0-rg db2_db2inst1_tsa02_0-rg [db2inst1@tsa02 ~]$ lsrgResource Group names:db2_db2inst1_db2inst1_TESTDB-rg db2_db2inst1_tsa01_0-rg db2_db2inst1_tsa02_0-rg

3.也可以使用root查看

[root@tsa01 ~]# lssamOnline 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:tsa02Online 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:tsa01Online 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:tsa02Online IBM.Equivalency:db2_db2inst1_db2inst1_TESTDB-rg_group-equ |- Online IBM.PeerNode:tsa01:tsa01 '- Online IBM.PeerNode:tsa02:tsa02Online IBM.Equivalency:db2_db2inst1_tsa01_0-rg_group-equ '- Online IBM.PeerNode:tsa01:tsa01Online IBM.Equivalency:db2_db2inst1_tsa02_0-rg_group-equ '- Online IBM.PeerNode:tsa02:tsa02Online IBM.Equivalency:db2_public_network_0 |- Online IBM.NetworkInterface:enp0s3:tsa01 '- Online IBM.NetworkInterface:enp0s3:tsa02[root@tsa02 ~]# lssamOnline 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:tsa02Online 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:tsa01Online 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:tsa02Online IBM.Equivalency:db2_db2inst1_db2inst1_TESTDB-rg_group-equ |- Online IBM.PeerNode:tsa01:tsa01 '- Online IBM.PeerNode:tsa02:tsa02Online IBM.Equivalency:db2_db2inst1_tsa01_0-rg_group-equ '- Online IBM.PeerNode:tsa01:tsa01Online IBM.Equivalency:db2_db2inst1_tsa02_0-rg_group-equ '- Online IBM.PeerNode:tsa02:tsa02Online 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 ~]# lsrpnodeName OpState RSCTVersion tsa02 Online 3.2.5.3 tsa01 Online 3.2.5.3 [root@tsa01 ~]# lsrgResource Group names:db2_db2inst1_db2inst1_TESTDB-rg db2_db2inst1_tsa01_0-rg db2_db2inst1_tsa02_0-rg [root@tsa02 ~]# lsrpdomainName OpState RSCTActiveVersion MixedVersions TSPort GSPort db2ha Online 3.2.5.3 No 12347 12348 [root@tsa02 ~]# lsrpnodeName OpState RSCTVersion tsa02 Online 3.2.5.3 tsa01 Online 3.2.5.3 [root@tsa02 ~]# lsrgResource Group names:db2_db2inst1_db2inst1_TESTDB-rg db2_db2inst1_tsa01_0-rg db2_db2inst1_tsa02_0-rg

DB2

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。