IBM WebSphere Multichannel Bank Transformation Toolkit, Version 7.1
Setting up DB2 for database services
About this task
To use any of the database services with DB2 Universal Database™,
complete the following steps:
Procedure
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.