Sets an alternative schema to be searched in place of the SYSIBM schema.
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:
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:
and searching for "PK05102".