To use any of the database services with DB2 Universal Database™,
complete the following steps:
- Ensure that IBM® DB2 Universal Database is installed
and that your database is created.
- If you want to set up a development environment, then before you
can use the JDBC support within Rational® Application Developer or WebSphere® Integration
Developer, you must first either import the JDBC drivers or confirm that they
are accessible to the service invoker. Since you will be using DB2®,
import or make a reference to the DB2 Universal Database (UDB)
drivers. These JDBC drivers are in the file SQLLIB\java\db2java.zip, on the
disk where DB2 is
installed.
- Start the database manager. This step applies for either
a development or a runtime environment with a local IBM DB2 database. You can do this either from
the Services folder (service DB2-DB2), or by entering the following at a command
prompt:
DB2START
- The following steps apply for either a development or a runtime
environment with IBM DB2 on a server:
- Start the Security Service either from the Services folder (service
named DB2 Security
Server) or by entering the following at a command prompt:
net
start DB2NTSECSERVER
- Start the database manager. This can be done either from the
Services folder (service DB2-DB2) or by entering the following at a command
prompt:
DB2START
- Start the DB2 JDBC applet server. Enter the following command only
in the case of a remote database being accessed from a Java™ applet
with no IBM DB2 client
component code running in the client:
DB2JSTRT 8888
where
8888 is the port the applet server is listening on.
- Start your application from Rational Application Developer or WebSphere Integration
Developer like any other application. The loaded DB2 JDBC driver handles the JDBC API calls
from your application through the JDBC services provided by the toolkit.