Resolution of unqualified object names

Most object names are implicitly or explicitly qualified with a schema name. Synonyms are an exception.

A synonym has a single part name. When DB2® encounters an unqualified name, DB2 must determine which object to process. This process is called name resolution.

When DB2 encounters a single part name in a context where an alias, table, view, or synonym can be specified, DB2 first checks to see if the name refers to a synonym that is defined by the current user.