Single-member SNA access

Single-member access using SNA is the same method that is used to access Db2 in non-data sharing environments.

With single-member access, a requester specifies the LU name of the specific member of the group as the value of the LINKNAME column of both a SYSIBM.IPNAMES row and a SYSIBM.LOCATIONS row. The requester sends all connection and query requests to that member.

With single-member access, a requester uses the LU name in its TCP/IP configuration to connect to a specific member of the group. The requester sends all connection and query requests to this same member.

Db2 for z/OS®: Configure Db2 for z/OS to use single-member access by creating and using a location alias that represents only one member of the data sharing group. Otherwise, Db2 for z/OS uses DRDA workload balancing by default to allocate requests among the members of the group.

Recommendation: Do not use single-member access for the following reasons:
  • It is dependent on the specified member being operational.
  • It provides no workload balancing for requesters that cannot perform DRDA workload balancing.
Restriction: Version 8 of Db2 Connect does not support single-member access.