In theAdministration Guide, under the section Installing the Agent for Databases,I found the following instructions:
DB2
The JDBC driver is part of the DB2 installation. It is
available in the directory SQLLIB/java (under Windows: C:\Program
Files\IBM\SQLLIB\java).
Copy the following two files to the Agent's JDBC directory:
- db2jcc.jar (JDBC Type 4 Driver)
- db2jcc_license_cu.jar (Server license)
The JDBCdrivercan be downloaded from IBM's homepage.
Click on the
entry "DB2 Personal Developers Edition: Re-distributable JDBC Type 4 Driver."
I followed these instructions, and copied the two JAR files into the SQL agent’s jdbc directory. I then restarted the agent.
When I define an SQL job that uses this agent, I can retrieve a list of tables from the DB; so I know that the agent is working, and that the login object contains valid credentials. However, when I attempt to run an SQL query job, I see the following error message:
4/14/2014 9:17:40 AM - U0010002 Include 'HEADER.' not found in object 'UC0.SQL.JOB.1', line '00005'.
I’m guessing this is an internal UC4 error related to the HEADER include object(s). As far as I can tell, there is no user include for SQL jobs — only the standard HEADER.SQL object in client 0.