IBM DB2 for z/OS (formerly OS/390)

This section describes features specific to the IBM DB2 for z/OS family of databases.

Note:

The DBMSs for IBM DB2 v5.x are deprecated.

The following table lists DB2 objects and their equivalents in PowerDesigner:

DB2	PowerDesigner
Bufferpool	Storage
Database Partition Group	Extended Object <<DatabasePartitionGroup>>
Distinct Type	Domain
Function	Procedure of "Function" type
Index Extension	Extended Object <<IndexExtension>>
Method	Abstract Data Type Procedure
Type	Abstract Data Type
SuperView	SubView of a View

Trusted Contexts
Using a trusted context in an application can improve security by placing accountability at the middle-tier, reducing over granting of privileges, and auditing of end-user's activities.
Auxiliary Tables
Auxiliary tables are used to store large object (LOB) data, such as graphics, video, etc, or to store rarely-accessed data in order to improve the performance of the base table.
Tablespace Prefix
In IBM databases for z/OS, the physical options for a table can specify the tablespace in which a table resides, as well as the database name.
IBM DB2 Extended Attributes for z/OS
The following extended attributes are defined by default in the IBM DB2 for z/OS DBMS.

Parent topic: Data Model Target Reference