This topic has been locked.
Pinned topic Relating partition number to member id
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
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?