You can use several different methods to copy a database, some of which
are performed by using
DB2 Change Management Expert and
some of which are performed by using other DB2 tools. The methods that are
supported by
DB2 Change Management Expert include:

- Copying a database by using a Deployment Script
- Copying a database by using a script file

The method that you choose depends on the database environment and what
needs to be copied. In some cases, it might be appropriate to use another
DB2 tool, such as DB2 Control Center, DB2 utilities, or the DB2 Command Line
Processor, to perform all or part of the database copy. The method that you
choose depends on the database environment and on what needs to be copied.
The following table compares each method:

Table 1. Methods for
copying databases and the behavior in DB2 Change Management ExpertMethod |
Description |
Creates database |
Copies database structure |
Copies data |
Copying by using a Deployment Script |
Copy the database by migrating database objects and
data. |
No. Performing a copy using a Deployment Script requires
you to create the new database manually. |
Yes |
Yes |
Manually creating script files |
Manually create scripts with DB2 Change Management Expert to
copy the database. |
Yes |
Yes |
Yes |
Copying a database outside of DB2 Change Management Expert |
Use techniques outside DB2 Change Management Expert to
copy the database. |
Yes |
Yes |
Yes |
