In the CLP, the CONNECT TO statement refers to the database or alias in
the database directory. In
DB2 Change Management Expert,
the CONNECT TO statement refers to the connection name in the Database Explorer,
which has the following implications:
- When you run a change command file, you can connect to and execute commands
against different databases. The ability to connect to and run commands against
different databases is particularly useful when migrating data between database
environments.
- When you use the Run SQL action to run a change command file, you are
not prompted for a connection if a CONNECT TO statement is the first command
in the file.
- Visual Explain takes advantage of the CONNECT TO statement to launch itself.
- Connection metadata is stored in the workspace and not in the project.
If a project is used in a different workspace than which it was created or
if the connection names in the Database Explorer are changed, carefully check
the change command files and connections. For example, the same database might
exist in several environments, for example, development, test, and production.
If projects are shared by multiple users, establish standardized connection
names to assure that the change commands are deployed to the correct database.