Page History

...

• Install DB2 9.74 Express C.
• Download and place the JDBC driver in the third-party lib directory that you created earlier.
• The location of DB2 server is specified in the build.properties file by the value for the property sqoop.test.db2.connectstring.host_url. This property defaults to jdbc:db2://db2host:50000 which assumes installation on a host called db2host and port 50000 setup. If however your DB2 server is installed on a different host or on a different port you should specify it explicitly as follows:

  Code Block
  sqoop.test.db2.connectstring.host_url=jdbc:db2://<db2host>:<port>

• In order to run DB2 server manual tests, you would need to configure the database as follows:
  • Create a database called SQOOP.
  • Create a login username sqoop with password PASSWORD.
  • Grant all access for database SQOOP to login sqoop.

The default username, password and database can be also overridden using following properties:

• sqoop.test.db2.connectstring.database for database
• sqoop.test.db2.connectstring.username for username
• sqoop.test.db2.connectstring.password for password

Running manual tests

Once you have installed and configured all the above databases - SQL Server and DB2, you are now ready to run the manual tests. To run them, issue the following command:

...