Scenario: Validating data after schema changes have been made

Tight integration between the tools in DB2® Administration Solution Pack allow database administrators to easily create and validate database schema changes.

The database administrator of a large retail chain wants to make a schema change to a table to convert a DATE format column to a CHAR column.

DB2 Configuration Manager easily permits the change to be made, while the DB2 Table Editor allows the DBA to confirm that the change was made and properly applied.

To modify the schema, the database administrator first uses the DB2 Configuration Manager to change the DATE format to a CHAR format column. Next, the DBA uses DB2 Table Editor to view the table data to confirm that the data in the table is in the expected format. The integration of the tools within DB2 Administration Solution Pack allows the DBA to start DB2 Table Editor by using the EDIT command from within DB2 Administration Tool to start DB2 Table Editor to view the data.