DB2 Pack.#This Integration is part of the
Supported Cortex XSOAR versions: 6.0.0 and later.
Integration to provide connectivity to IBM DB2 using the python ibm_db2 library. This integration was integrated and tested with version 0.1 of DB2
#Configure DB2 on Cortex XSOAR
Navigate to Settings > Integrations > Servers & Services.
Search for DB2.
Click Add instance to create and configure a new integration instance.
Parameter Required Database host True Port False Database Name False Username True Password True Connection Arguments (ex: arg1=val1&arg2=val2) False Use an SSL connection False Use Persistent Connection False
Click Test to validate the URLs, token, and connection.
You can execute these commands from the Cortex XSOAR CLI, as part of an automation, or in a playbook. After you successfully execute a command, a DBot message appears in the War Room with the command details.
Running a DB2 query command
|query||The DB2 query to run.||Required|
|limit||The maximum number of results. Default is 50.||Optional|
|skip||The offset at which to start the result. Default is 0.||Optional|
|bind_variables_name||A comma separated list of names which will be replaced in query having ':<name>'.||Optional|
|bind_variables_values||A comma separated list of values corresponding to ||Optional|
There is no context output for this command.
!db2-query query="CREATE TABLE publishers(publisher_id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(publisher_id))"