DB2 Version 9.7 for Linux, UNIX, and Windows

SysSchema CLI/ODBC Configuration Keyword

Sets an alternative schema to be searched in place of the SYSIBM schema.

db2cli.ini keyword syntax:

SysSchema = alternative schema

Default setting:

The default table qualifier name used when querying DB2® for z/OS® is SYSIBM.

Usage notes:

This option indicates an alternative schema, or table qualifier, to be searched in place of the SYSIBM schema when the CLI and ODBC Catalog Function calls are issued to obtain system catalog information from DB2 for z/OS.

Using this new schema name, the system administrator can define a set of views, or a copies of the tables, consisting of a subset of the rows for system catalog tables such as:

SYSIBM.SYSCOLAUTH
SYSIBM.SYSCOLUMNS
SYSIBM.SYSDATATYPES
SYSIBM.SYSFOREIGNKEYS
SYSIBM.SYSINDEXES
SYSIBM.SYSKEYS
SYSIBM.SYSKEYCOLUSES
SYSIBM.SYSPARMS
SYSIBM.SYSRELS
SYSIBM.SYSROUTINES
SYSIBM.SYSTABAUTH
SYSIBM.SYSTABCONST
SYSIBM.SYSTABLES
SYSIBM.SYSSYNONYMS

For example, if the set of views, or a copies tables, for the system catalog tables is in the ACME schema, then the view (or copy of the table) for SYSIBM.SYSTABLES is ACME.SYSTABLES; and SysSchema should be set to ACME.

For applications that automatically query the system catalogs for all table names, defining and using limited views of the system catalog tables reduces the number of tables listed by the application. This can reduce the time it takes for the application to query table information since a subset of table names is returned.

Defining and using copies of the system catalog tables, with the same indexes defined on the copy as those defined on the system table, can reduce the time it takes for applications to query the database.

The SchemaList, TableType and DBName keywords can be used in conjunction with the SysSchema keyword to further limit the number of tables for which information is returned.

For more information about which system catalog tables can be used with SysSchema, and about the function of SysSchema, refer to the documentation for APAR PK05102 by visiting:

Support for IBM® mainframes

and searching for "PK05102".