How EXPLAIN works in a data sharing group

EXPLAIN informs you about access paths that Db2 chooses.

Because EXPLAIN can be run on one member and a plan can be bound and executed on other members in a data sharing group, it is important to know which member performed the EXPLAIN. The PLAN_TABLE's GROUP_MEMBER column contains the name of the member that performed the EXPLAIN. The column is blank if the member was not in a data sharing environment when the EXPLAIN was performed.