Generating a CLP script from a deployment group for batch deployment on DB2 servers

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.

Before you begin

Create a deployment group.

About this task

Restriction: This feature is only supported for non-external SQL artifacts (not including PL/SQL artifacts) and DB2 servers.

Procedure

  1. Right-click a deployment group in the Deployment Manager view.
  2. Select Export for Batch Deploy.
  3. 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.

  4. 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

  1. Establish a DB2 command line processor connection.
  2. Run the generated aggregated script (or shell script, depending on your selection above) using the DB2 command line processor.

Feedback