Purpose

Specifies the DB2 schema to use for catalog methods. To improve performance, views of system catalog tables can be created in a schema other than the default catalog schema. Setting this property to a schema that contains views of the catalog tables allows the driver to use those views. To ensure that catalog methods function correctly, views for specific catalog tables must exist in the specified schema. The views that are required depend on your DB2 database. See Non-Default Schemas for Catalog Methods for views for catalog tables that must exist in the specified schema.

Valid Values

string

where:

string
is the name of a valid DB2 schema.

Default

SYSCAT (DB2 for Linux/UNIX/Windows) | SYSIBM (DB2 for z/OS) | QSYS2 (DB2 for i)

Data Type

String

See also

Performance Considerations