New Features and Enhancements › Full Support for DB2 z/OS 8.1 and 9.1

Full Support for DB2 z/OS 8.1 and 9.1

Support for DB2 z/OS has been enhanced to include full relationship syntax. The property editors have also been upgraded to use the new editor design.

Enhanced editors and features supported include:

• Auxiliary Tables
• Database Roles
• Databases
• Data Types (all supported data types including Geospatial)
• Files
• Functions
• Materialized Query Tables
• Permissions
• Schemas
• Sequences
• Storage Groups
• Synonyms
• Tables
• Tablespaces
• Triggers (Table and View)
• Trusted Contexts
• User IDs

In CA ERwin Data Modeler r7.x the DB2 z/OS target server was listed as either DB2 z/OS 8/9 or DB2 z/OS 7. In r8, the distinction between the 8.1 and 9.1 version has been introduced, and support for version 7 has been dropped. When you open a DB2 z/OS model created in CA ERwin Data Modeler r7.x, it is converted to a DB2 z/OS 9.1 model. To convert the model to DB2 z/OS 8.1, click Target Database on the Actions menu in the physical model. In the Target Server dialog, select DB2 z/OS 8.1 and click OK.

Note: You can use the Save As feature to save an r8 model in r7.x format. If you save an r8 DB2 z/OS 8.1 or 9.1 model as an r7.x model, unsupported model data in CA ERwin Data Modeler r7.x is not saved.