Multiple schema support

Create and manage multiple schemas for virtual tables.

With the IBM Data Virtualization Manager for z/OS, you can create and manage multiple schemas. This feature supports the use of multiple virtual schemas for virtual tables in Data Virtualization Manager. You can create schemas in the server using JCL batch files, you can manage the schemas using the JCL batch files and Data Virtualization Manager Studio.

With this feature you can:
  • create multiple virtual tables with the same names in different schemas,
  • create tables with same name for different departments or functions in an organization, and
  • create virtual tables with the same names that references to different data sources.

Enhanced security

Support for multiple schemas enhances the security by giving you granular control and letting you configure the security at a schema level instead of just at the table level.

You can now additionally configure the security at the schema level and at the schema data set level. You can configure a schema such that only specified users can run queries from the Studio, JDBC, ODBC, DSClient on the tables that are part of that schema. You can secure the data set of a schema so that only specified users can create virtual tables or have read access to the virtual tables.

The following diagram illustrates an example where two different schemas have virtual tables with similar names and are used by multiple applications:

Multiple schema support