Take charge of your DB2 data

fa C t s h e e t : f i l e - a i d f o r d b 2

Compuware File-AID for DB2 is a DB2 data

management and testing tool that helps IT

organizations meet the challenges of working

with data in a DB2 environment.

With File-AID for DB2, developers can create, populate, customize, refresh and, where appropriate, authorize DB2 objects. In short, File-AID for DB2 creates an effective DB2 environment—without coding SQL.

Its ISPF-like format is designed to follow the logical workflow of building a test data environment, making it familiar to the developer.

File-AID for DB2 gets into the test cycle faster, letting developers validate and explain program SQL before beginning the compile and bind process.

Compuware’s product integration enables developers to use hot keys from Compuware Abend-AID to quickly diagnose and resolve DB2 data problems.

QuiCkly browse and edit db2 data

File-AID for DB2 makes browsing and editing table data as simple as working with data under ISPF. Developers can edit an entire table or build selection criteria that can be saved and reused to:

select specific columns•

determine the order in which columns are displayed•

specify the sort order of the data in each column•

select rows based on WHERE clauses•

select data using pre-existing SQL statements.•

File-AID for DB2 always maintains the integrity of your database. Changes are logged to the System Management Facility or to a user-defined audit trail according to your site’s requirements.

The File-AID for DB2 Edit function lets developers view data in either row or table mode.

Compuware.Com | Compuware Corporation: we make i.t. roCk around the world

edit multiple tables simultaneously

Edit or browse multiple unrelated or related tables in a single session. With Related EDIT and BROWSE, developers can toggle from table to table with a simple command or dynamically change from a multiple-table display to a full-screen view of one table. Synchronized scrolling of data is provided for all related dependent tables. Dynamically create application relationships during EDIT or BROWSE sessions.

Cut and paste where you want

Copy rows of table data into the same or different tables during a File-AID for DB2 session with the CUT and PASTE commands. All “cut” rows are copied into another table where column type, length and nullability match—even on another DB2 subsystem and/or between locations. It’s also possible to paste the cut rows into a data set, in delimited format, for use outside of File-AID for DB2.

Create and populate tables effiCiently

The CREATE/DROP/ALTER DB2 OBJECTS function creates a table using ISPF-like screens instead of coding DDL statements. By modeling the table after one created by a DBA, developers can quickly set up their own test tables. With File-AID for DB2, tables are populated by:

copying data from an existing table•

cutting and pasting data •

entering data using Rapid Data Generation techniques.•

Related EDIT and BROWSE functions enable synchronized scrolling among related objects.

fa C t s h e e t : f i l e - a i d f o r d b 2

The GRAPHIC command displays a graph of the tables related to the table you are currently browsing or editing.

The graph displays referential integrity and application relationships as well as parent and dependent tables for

any table involved in the relationship.

Benefits of File-AID for DB2

Higher-quality testing•

Reduced DB2 learning curve•

Immediate reduction in test time•

Self-sufficiency for developers•

Fewer compiles and binds•

Optimized SQL code•

Quick resolution to production problems•

Compuware Corporation: we make i.t. roCk around the world | Compuware.Com

proteCt sensitive data

Compuware offers powerful integration between its File-AID/RDX, File-AID/Data Solutions, File-AID for IMS, File-AID for DB2 and File-AID/EX products to help companies address data privacy requirements in the test environment. Our unique solution spans both zSeries mainframe and distributed platforms, and uses consistent data disguise techniques across all environments.

objeCt list utility enhanCed for additional db2 features

File-AID for DB2 supports new features incorporated into recent DB2 releases. These include: Distinct Type, Stored Procedures, Triggers, Identity Column, ROWID and User Defined Functions. In Option 3.4, the Object List Utility provides access to this functionality.

explain sQl statements

Explain a single statement or a set of statements grouped by DBRM, plan, collection or package—online or in batch. Rules-based EXPLAIN analysis is displayed in plain language, combined with object attributes and catalog statistics. The text provides conditions, consequences and recommendations relating to the performance of the SQL statement. Additionally, any SQL that can be executed dynamically can execute in File-AID for DB2 batch.

analyze prediCates loGiCally

The Predicate Analysis function uses rules-based logic to analyze SQL. Predicates are analyzed to determine if they are indexable, stage 1 or both. Rules are highlighted according to their severity. Tab to any rule and press ENTER to receive detailed recommendation information.

fa C t s h e e t : f i l e - a i d f o r d b 2

The File-AID for DB2 Object List Utility now provides greater flexibility.

Founded in 1973, Compuware provides software, experts and best practices to ensure applications work well and deliver business value. Compuware solutions optimize application performance across the Enterprise and the Internet for leading organizations around the world, including 46 of the top 50 Fortune 500 companies and 12 of the top 20 most-visited U.S. web sites. Learn more at compuware.com.

Compuware Corporation Corporate Headquarters One Campus Martius Detroit, MI 48226-5099 © 2010 Compuware Corporation

All Compuware products and services listed within are trademarks or registered trademarks of Compuware Corporation. Java and all Java-based marks are trademarks or registered trademarks of Sun Microsystems Inc. in the United States and other countries. All other company or product names are trademarks of their respective owners.

04.10

GauGe impaCt of Column ChanGes

The Column Impact Analysis produces a report that identifies the impact of column changes on other tables. With this analysis, developers can see the extent of changes before activating them.

maintain foCus in interaCtive testinG environments

Within Compuware File-AID for DB2, you can maintain focus on your data and test new logic. The Compuware Xpediter for DB2 interface customizes DB2 test data to exercise all logic paths in the program while the Xpediter/TSO test session remains active. SQL prototyping enters SQL statements during a debugging session, “test driving” the new logic prior to recompile and rebind.

fa C t s h e e t : f i l e - a i d f o r d b 2

resolve data-related abends faster

When developers must deal with data-related DB2 abends, they want quick access to the data that requires investigation. Hence, File-AID for DB2 is integrated with Abend-AID for DB2. As a result of this synergy, when an abend occurs, developers can jump from the Abend-AID report directly to the DB2 object where the suspect data resides. When they are finished, a single keystroke returns them to Abend-AID for DB2. That kind of practical integration saves developers time and their companies money every day.

When fully integrated with other Compuware products, such as File-AID/Related Data XPERT (RDX), DBA-XPERT for DB2 and Xpediter for DB2, File-AID for DB2 and Abend-AID for DB2 provide complete functionality for all DB2 testing requirements.

To learn more about Compuware File-AID, visit: www.compuware.com/file-aid