Data Design Projects

A Data Design Project is a container for storing the resources that you will use to plan, analyze, archive, and make changes to your databases. Projects are displayed in the Data Project Explorer view, and they correspond to directories in the file system.
The resources that you will use to make database changes include models and scripts. When you create a project, the following virtual subfolders are displayed within the project to organize the following resources:
Data Diagrams folder
Holds the diagram files for your base and target models.
Data Models folder
Holds the models. Models have a file extension of .dbm.
SQL Scripts folder
Holds the types of script files that are shown in the following table:
Table 1. Types of scripts in the SQL scripts folder
Type of script File extension Description
Change command script chx Can contain SQL statements, DB2 commands, and utility invocations. These scripts can be used to make or undo changes to a database, such as change the structure of a database (DDL), change the data in the database (EXPORT, IMPORT, and DML), modify the database packages (REBIND), or run statistics.
Deployment script deployxml Contains a set of changes to make to a database. The deployment script brings together the specification resources (models), change commands, and metadata about the change and organizes them into a coherent form.
SQL script

sql
ddl

Contains SQL statements.
You can select Run SQL by right-clicking a script in the Data Project Explorer. The run options that are available, depend on the file extension of the script. The following list describes the available options:
  • The Run SQL option is available for scripts that contain commands that are specific to DB2® Change Management Expert. Those scripts will have a .chx extension.
  • The Run SQL option never appears for deployment scripts with a .deployxml file extension, as those commands are issued through the Deploy wizard.
  • The Run SQL option is available for other files in the scripts folder that only contain commands that can be deployed through a JDBC. For example, DDL, DCL, and DML commands. These scrpits typically have a .ddl or .sql file extension.
Other Files folder
Holds the files that do not belong in either the SQL Scripts or Data Models folders. For example, the deployment log files with a file extension .log, are placed in this folder.
The following figure shows an example of a project with its resources:
Figure 1. Example of a project in the Data Project Explorer view
This graphic shows an example of a project in the Data Project Explorer view. The project contains models and scripts.

A project must exist before you can use any of the other functionality in DB2 Change Management Expert. Some functions in DB2 Change Management Expert will create a project if one does not already exist. For example, when you create a deployment script, you can specify that a project be created for you. You can also create a project explicitly.

Related concepts
Working with the deployment script


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.