IBM DB2 for Common Server

This section describes features specific to the IBM DB2 for Common Server family of databases.

To see the comparison table between DB2 objects and their equivalents in PowerDesigner, see IBM DB2 for z/OS (formerly OS/390).

For information about support for trusted contexts, see Trusted Contexts.

PowerDesigner supports the modeling of event monitors for DB2 for Common Server v9.5 and higher as DBMS triggers (see DBMS Triggers (PDM)).

• Database Partition Groups
  Database partition groups are supported for DB2 v9.x and higher for Common Server.
• Index Extensions
  Index extensions are supported for DB2 for Common Server v9.x and higher, and are used with indexes on tables that have columns of a structured or distinct type.
• Security Policies
  Security policies define criteria that determine who has write and/or read access to individual rows and columns of tables.
• Event Monitors
  Event monitors show activity from start to finish, and often consist of both a start and end event record. The most common uses for event monitors are for connections, locks, and statements. PowerDesigner models event monitors as extended objects with a stereotype of <<EventMonitor>>.
• IBM DB2 for Common Server Extended Attributes
  The following extended attributes are defined by default in the IBM DB2 for Common Server DBMS.