Fully Qualified Table Names

A fully qualified (or three-part) table name consists of three distinct elements separated by periods:

location-name.authid.table-identifier

The first qualifier, location-name, indicates which location should be searched for the table. On an XDB Server, there can be multiple locations per server, while in DB2 the location name designates the DBMS (or subsystem) at which the table is stored. The SYSTEM.SYSIBM.SYSLOCATIONS table catalogs all locations accessible to the XDB Server.

The second qualifier, authid, is the Authorization ID (AuthID) that designates the owner of the table.