IBM DB2 is the database of choice for enterprise-wide solutions. Optimized to deliver industry-leading performance while lowering costs, IBM DB2 offers extreme performance, flexibility, scalability and reliability for any size organization.
The DB2 plugin for CloudBees CD/RO allows you to drive the deployment of DB2 database components as part of multi-tier web application releases. Using the integration, you can run any SQL commands to perform database deployment and management tasks such as creating, dropping or backing up tables, or updating schema and content.
This plugin was developed and tested against following IBM DB2 server:
- IBM DB2 V11.1
List of supported platforms:
-
Linux
-
IBM AIX
-
IBM zOS
-
Windows
-
The JDBC Driver jar for IBM DB2 should be copied to the ElectricFlow agent Machine.
-
In addition, if the database on which DB2 is installed is zOS the license jar required to connect to IBM DB2 should be copied to the ElectricFlow agent machine. Refer to IBM documentation for more details on using the right license.
This plugin was tested with db2jcc\_license\_cisuz.jar.
Plugin configurations are sets of parameters that can be applied across some, or all, of the plugin procedures. They can reduce the repetition of common values, create predefined parameter sets, and securely store credentials. Each configuration is given a unique name that is entered in the designated parameter for the plugin procedures that use them.
| Parameter | Description |
|---|---|
Configuration Name |
Name of the plugin configuration. |
Description |
Description for the plugin configuration. |
DB2 server address |
Address of DB2 server. Example: db2-local |
DB2 server port |
Port of DB2 server. By default 50000. |
Database name |
Name of DB2 database to connect. |
Driver path |
Absolute path to the DB2 jdbc driver jar. For example /opt/ibm/drivers/db2jcc.jar |
License path |
Refer to the pre-requisites section to determine if this license is required. Absolute path to the DB2 jdbc license jar. For example /opt/ibm/licenses/db2jcc_license_cisuz.jar |
Credential |
|
The DB2 Configurations page now shows the new configuration.
You can also manage your DB2 configurations in this page. Click Edit to modify an existing configuration or Delete to remove an existing configuration.
This procedure executes SQL query against IBM DB2 server.
-
In the Main Menu, click Admin > Plugins to open the Plugin Manager.
-
Got to the EC-DB2 plugin.
-
Go to the ExecuteSQL procedure.
-
Enter the following parameters:
| Parameter | Description |
|---|---|
Configuration name |
Name of the configuration to be used. URL and credentials are retrieved from the given configuration. A Configuration defines connection details and can be created by going to plugin configuration page. |
SQL statement |
SQL query to execute. |
Path to SQL file |
Path to file that contains SQL request. |
Output properties path |
Path for result properties. If query is select, all information will be stored as JSON array, otherwise affected rows count will be stored as JSON object. |
Output:
After the job runs, you can view the results on the Job Details page in ElectricFlow. The status of the page was checked successfully.
In the ExecuteSQL step, select the Log button to see the diagnostic information.
Output:
After the job runs, you can view the results on the Job Details page in ElectricFlow. The status of the page was checked successfully.
In the ExecuteSQL step, select the Log button to see the diagnostic information.
- The documentation has been migrated to the main documentation site.
- The plugin icon has been updated.
- Fixed non-ascii characters in help.
-
Initial plugin release with following procedures:
- ExecuteSQL.