A schema is a collection of named objects such as tables, views, triggers, functions, procedures, or indexes. It provides a way to group those objects logically via a naming convention. It also provides a way to use the same natural name for several objects, and to prevent ambiguous references to those objects.
For example, the schema names 'APP1' and 'APP2' make it easy to distinguish two different SALES tables, APP1.SALES and APP2.SALES, which do not need to have the same structure.
A DB2 schema is distinct from, and should not be confused with, an XML schema, which is a standard that describes the structure and validates the content of XML documents.
If an object is specifically qualified with a schema name when created,
the object is assigned to that schema. If no schema name is specified
when the object is created, the default schema name is used, as
specified in the CURRENT SCHEMA special register.
SET CURRENT SCHEMA='MYSCHEMA';