Which Client component should be installed/used with Javelin to work with DB2 UDB DBMS?
search cancel

Which Client component should be installed/used with Javelin to work with DB2 UDB DBMS?

book

Article ID: 16108

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

This article covers how to obtain DB2 UDB client libraries to work with Javelin (along with TDM and its related components). 

In the documentation, we see the following reference to DB2:
Automating Database Activities (broadcom.com)

DB2 functions let you automate various database operations in Javelin flows.
Execute Query: Executes a query against an IBM DB2 database.
The query can be either Select, Insert, Update, or Delete. 
For Select queries, output rows are assigned to an output variable which is set in the OutDataTable property.

Note: You must have IBM DB2.NET Data Provider version 9.7.4.4 installed for this activity to work.

Where can we get these libraries from IBM?

Environment

TDM
Test Data Manager
javelin

Resolution

The IBM Data Server client should provide the required libraries.
Depending on the DB2 version, you can download the latest pack.
The link given below, provides the full details of all the downloads arranged by DB2 version. 

IBM Download Fix Packs by version for IBM Data Server Client Packages - United States 
http://www-01.ibm.com/support/docview.wss?rs=4020&uid=swg27016878  

You will need to have an IBM account to download it. 
If you are not able to access it, you might have to reach out to your DBA to get the correct libraries,  since these libraries are not openly distributable.