New Features › CA Chorus for DB2 Database Management

CA Chorus for DB2 Database Management

Show Full SQL Text

This new action shows the full SQL text displayed as a single row in the grid and in the Details at the bottom of the display. When the text is displayed, you can use the Explain action to explain the statement or view and execute it using the DBA Command Manager.

Note: This support was added as a post-GA PTF.

Consolidated Security Jobs

New consolidated security jobs are now provided. The security jobs simplify how you meet many security requirements for the installer, user, secondary authorization IDs, started task permissions, PassTicket configuration, and RRSAF authorizations. The following jobs reside on the CA Chorus for DB2 Database Management product page under Content Type, Recommended Reading:

• E3KI095A for CA ACF2
• E3KI095T for CA Top Secret
• E3KI095R for IBM RACF

Note: This support was added as a post-GA PTF.

The following improvements have been made to CA Chorus for DB2 Database Management since the GA release:

• Reduced loading time for the DB2 for DBA Investigator tree.
• Resolved issues that could lead the CA Chorus JBoss server to encounter out of memory conditions.
• Reduced the overall heap usage of the discipline within the CA Chorus JBoss server.
• Enhanced the display and formatting of timestamps in the DB2 for DBA Investigator.
• Improved info/error messages.

Note: This support was added as a post-GA PTF.

This release adds the Object Relationship Report feature:

The Object Relationship report identifies objects that will be removed, need to be removed, or will be invalidated due to the dropping of a selected object. The report displays the objects that are affected directly and indirectly. You can perform the following actions:

• Show parent objects (ancestors)
• Show child objects (descendants)
• Show all related objects

Version 3.0 includes the following enhancements:

DDL Generation Commands for Catalog Objects in the Investigator

Object DDL

Generates DDL for a DB2 object and all related objects. An object DDL action places the DDL of a selected object in the input window of the DBA Command Manager. This feature lets the user edit and submit the altered DDL to DB2. The DDL can be generated with or without OBID (OBID clause) information. A DDL generation is supported for the primary object types (storage group, database, tablespace, and so on). Multiple objects can be selected.

Hierarchical DDL

Places the DDL of a selected object and its related objects in the input window of the DBA Command Manager for DB2. This feature lets the user edit and submit the altered DDL to DB2. The DDL can be generated with or without OBID information. A DDL generation is supported for the primary object types (storage group, database, tablespace, and so on).

DBA Command Manager for DB2 Performance Enhancements

The DBA Command Manager for DB2 has been enhanced to process a single SELECT statement without using temporary z/OS data sets. This enhancement improves performance and reduces the extra complexities that are introduced by having work data sets created. The results are displayed in a grid (table) format under the results tab in the Investigator.