Implementing Db2 schemas

Objects are assigned to schemas when they are created. That is, when certain types of database objects are created, they are given qualified two-part names. The first part is the schema name (or the qualifier), which is either implicitly or explicitly specified. The second part is the name of the object. The default schema is the authorization ID of the owner of the plan or package.

A schema is a collection of named objects that provides a logical classification of objects in the database. The schema name of the object determines the schema that the object belongs to. The objects that a schema can contain include tables, indexes, table spaces, distinct types, functions, stored procedures, and triggers.

For more information, see Db2 schemas and schema qualifiers.