Configuring Connections: IBM DB2

Versions: 8.0+

Configuring QuerySurge Connections: DB2

When you create a QuerySurge Connection, the Connection Wizard will guide you through the process. Different types of QuerySurge connections require different types of information.

For a DB2 Connection, you will need the following information (check with a DBA or other knowledgeable resource in your organization):

• Database login credentials (ID and Password)
• Server Name or IP address of the DB2 Server (e.g. db21.myserver.com, or 192.168.0.255)
• The Port for your DB2 database (50000 is the default port)
• The DB2 Database name

Note: QuerySurge DB2 builtin support is for the IBM JCC Universal Driver. If you use a different driver, QuerySurge supports you via the Connection Wizard's Connection Extensibility feature.

Launch the Connection Wizard

1. Log into QuerySurge as an Admin user.
2. To configure a Connection, select Configuration > Connection in the Administrative View tree (at the left).
3. Click on the Add button at the bottom left of the page to launch the Connection Wizard. Click Next.
   
   Note: Check the Advanced Mode checkbox for access to advanced features.
   
   
   
   
4. Provide a name for your connection. Select DB2 as the Data Source. Click Next.
   
   Note: QuerySurge builtin support is for the IBM JCC Universal Driver. If you use a different driver, QuerySurge supports you via the Generic JCBC Connection option.
   
   Note: The JCC Universal JDBC driver is not bundled with QuerySurge, so you will need to obtain and install the driver and any pertinent license files/jars with your Agents. See Adding a JDBC Driver to your QuerySurge Agent for instructions.
   
   
   
   
5. Once you have selected your Data Source, the Wizard will tell you what information you are likely to need in order to create your Connection. Once you have collected this information, you are ready to click Next.
   
   
   
   
6. Provide the connection information to your database. This includes the Server name or IP address, the port (the default port for your database product will automatically populate), the database name and login credentials. Click Next.
   
   Required fields for your Connection Type are marked by an *.
   
   
   
   
7.  Click on Test Connection.
   
   Note: You must have an Agent running with the driver for this Connection deployed in order to test the Connection.
   
   
   
   
8. Save the Connection.
   
   
   
   
9. Congratulations! You’ve created a QuerySurge Connection. Again, make sure that you have deployed the driver for this connection to all your QuerySurge Agents (see the link in #4 above).

Note: If connecting to IBM DB2 for Mainframe (AS400/iSeries) you may find that the header returns the column label rather than the column name.  To address this, there are two options:

• If possible, use a version of the JCC driver that is lower than version 3.5 which default to column name.  Versions 3.5 and greater default to column label.
• If using a lower version of the JCC driver is not possible, you can add a parameter/flag to the connection URL to disable the return of the column label.  However, to do this, you must create the IBM DB2 connection using the Connection Extensibility feature.  When specifying the connection URL, you will need to add the "useJDBC4ColumnNameAndLabelSemantics" parameter/flag.  The connection URL should resemble the following:

jdbc:db2://<hostname or IP address>:<port>/<database name>:useJDBC4ColumnNameAndLabelSemantics=1;

This article provides further detail on the parameter/flag.