• No replies
1 Post

Pinned topic Relating partition number to member id

‏2012-06-22T02:33:49Z |
A MEMBER id is assigned to each member of an instance (eg, "select member, host_name from table(SYSPROC.ENV_GET_SYSTEM_RESOURCES())"). And, when you create a database on an instance with several members, it is distributed and the partition on each member gets a partition number (eg, "select dbpartitionnum from sysibmadm.snapdb"). The question is, how do you relate the partition number to the member id, so that when something goes wrong, your monitoring script can tell which host the bad partition is on?