skip to main content
DataDirect Connect Drivers : DB2 Driver : Connection Properties : CatalogSchema
  
CatalogSchema
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