AlternateZOSSysSchema IBM data server driver configuration keyword

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

Equivalent CLI keyword
SysSchema
Equivalent IBM® Data Server Provider for .NET connection string keyword
N/A
db2dsdriver.cfg configuration syntax
<parameter name="AlternateZOSSysSchema" value="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. This is done 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 AlternateZOSSysSchema 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 AlternateZOSSysSchema 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 AlternateZOSSysSchema, and about the function of AlternateZOSSysSchema, see the documentation for APAR PK05102 by visiting:

and searching for "PK05102".