Skip to main content

DB2

The JDBC 4 driver for DB2 contains a reference to pdq.jar. This casuses a FileNotFoundException to be thrown when loading the driver in Apache Tomcat. The solutions offered by IBM Support are to either:

  1. Manually modify the MANIFEST.MF file in the JAR to remove the Class-Path: pdq.jar line
  2. Update Tomcat’s context.xml to include the following:
<Context>
  <!-- ... -->
  <JarScanner scanClassPath="false" />
  <!-- ... -->
</Context>

Note that this is not a surgical change and will impact all class path scanning.

Open Connections​

A few options:

  • From the command line: 
    db2 list applications
  • As a query: 
    SELECT * FROM sysibmadm.applications;
    The schema changed from sysibm to sysibmadm in DB2 v8.

Useful links:

Gotchas​

  • DB2’s isolation level is set through the whole query. When doing a UNION or subselect, you cannot specify WITH UR within the middle of the statement; it must be put at the end.

    Wrong:

    SELECT * FROM foo WITH UR
     UNION
    SELECT * FROM bar WITH UR
     ORDER BY id

    Correct:

    SELECT * FROM foo
     UNION
    SELECT * FROM bar
     ORDER BY id
      WITH UR