Thursday, November 15, 2012

db2 load Over JDBC Connection

Yesterday I needed to run the db2 load over a JDBC connection. Given the "connection", I was not local to the server. With the help of a colleague, I found this page:

LOAD command using the ADMIN_CMD procedure

The resulting call in ANT is:

Note that the load file needs to be on the remote server, verses being called locally. So you'll need a step to move your load file to the remote machine.

No comments:

Share on Twitter