4.12 Oracle Data Dictionary Emulation on a DRDA Server

The gateway optionally augments the DRDA database catalogs with data dictionary views modeled on the Oracle data dictionary.

These views are based on the dictionary tables in the DRDA database, presenting that catalog information in views familiar to Oracle users. The views created during the installation of the gateway automatically limit the data dictionary information presented to each user based on the privileges of that user.

• Using the Gateway Data Dictionary
  The gateway data dictionary views provide users with an Oracle-like interface to the contents and use of the DRDA database.
• Using the DRDA Catalog
  Each DRDA database has its own catalog tables and views.

4.12.1 Using the Gateway Data Dictionary

The gateway data dictionary views provide users with an Oracle-like interface to the contents and use of the DRDA database.

The gateway data dictionary views provide users with an Oracle-like interface to the contents and use of the DRDA database. Oracle products require some of these views. The gateway supports the DB2 UDB for z/OS, DB2 UDB for iSeries, and DB2/UDB catalog views.

You can query the gateway data dictionary views to see the objects in the DRDA database and to determine the authorized users of the DRDA database. The Oracle Database Gateway for DRDA supports many Oracle catalog views. Refer to Oracle DB2 Data Dictionary Views for descriptions of Oracle DB2 catalog views. These views are completely compatible with the gateway.

4.12.2 Using the DRDA Catalog

Each DRDA database has its own catalog tables and views.

Refer to the appropriate IBM documentation for descriptions of these catalogs.