DB2 z/OS - Admin notes

Foreign Keys

Information on these is difficult to retrieve from the catalog tables. At this stage we only display the columns in the referencing table. The columns in the referenced table cannot be displayed.

Primary Keys

You can only create a Primary Key if you already have a unique index on the columns (unlike with other databases, creating a Primary Key does not create an index).

Stored Procedures

AQT can build and manage Native SQL Stored Procedures for DB2 z/OS. These were introduced in DB2 for z/OS v9.