You can export deployment groups to a command line processor
(CLP) script that you can run outside of the workbench to deploy SQL
artifacts to DB2® database servers.
About this task
Restriction: This feature is only supported for
non-external SQL artifacts (not including PL/SQL artifacts) and DB2 servers.
Procedure
- Right-click a deployment group in the Deployment
Manager view.
- Select Export for Batch Deploy.
- In the window that opens, select the SQL artifacts to deploy
and specify a target directory on the file system. You can also specify
whether to create one file that contains all artifacts, or one file
for each artifact.
If you choose to create one file
for each artifact, a shell script is generated to deploy all of the
artifacts in the deployment group order. On Windows operating systems, this script has
a *.bat extension. On Linux operating
systems, this script has a *.sh extension.
- Click Finish.
Results
CLP scripts are generated using the options that you specified
and are saved to the file system in the folder that you specified.
What to do next
- Establish a DB2 command
line processor connection.
- Run the generated aggregated script (or shell script, depending
on your selection above) using the DB2 command
line processor.