You can configure an event database on an iSeries® system using DB2® database software.
About this task
If you are using a local iSeries server
to configure a remote iSeries server,
you must specify a remote database entry on your local server as an
alias to the target database. To configure the event database:
Procedure
- Start the wsadmin tool.
- Use the AdminTask object to run the configEventServiceDB2iSeriesDB administrative
command in batch or interactive mode. The minimum required
parameters of the configEventServiceDB2iSeriesDB command are
as follows:
- createDB
- Indicates whether the administrative command should create and
run the database configuration scripts. Specify true or false.
If this parameter is set to false, the scripts are
created but are not run. You must then run the database configuration
scripts to complete the database configuration.
Limitation: The administrative command can
automatically run the database configuration script only on the iSeries system. If you are running
the command on a client system, an error will be returned.
- nodeName
- The name of the node that contains the server where the event
service data source should be created. If you specify a node name,
you must also specify a server name. You must specify one of the following:
- Node name and server name
- Cluster name
- serverName
- The name of the server where the event service data source should
be created.
- clusterName
- The name of the cluster where the event service data source should
be created. If you specify a cluster name, do not specify node and
server names.
- toolboxJdbcClassPath
- The path to the IBM® Toolbox
for Java™ DB2 JDBC driver. Use this parameter only if you
want to use the Toolbox for Java driver
instead of the native JDBC driver. Specify only the path to the driver
file; do not include the file name.
- nativeJdbcClassPath
- The path to the DB2 for iSeries native JDBC driver.
Use this parameter only if you want to use the native JDBC driver
instead of the Toolbox for Java driver.
Specify only the path to the driver file; do not include the file
name.
- dbHostName
- The host name of the server where the database is installed. This
parameter is required if you are using the Toolbox for Java JDBC driver.
- dbUser
- The DB2 user ID to use when
creating the event database. The specified user ID must have sufficient
privileges to create and drop databases.
- dbPassword
- The DB2 password to use.
Other parameters might be required for your environment.
For a complete list of parameters and usage information, refer to
the help for the configEventServiceDB2iSeriesDB administrative
command.
Results
The administrative command generates scripts to create
the required database and data source at the specified scope. These
scripts are stored by default in the profile_root/databases/event/node/server/dbscripts/db2iseries
directory. If you specified a value for the optional outputScriptDir
parameter, the scripts are stored in that location instead. You can
use these scripts to manually configure the event database at any
time.
What to do next
If you ran the database configuration administrative command
on a client system, you must transfer the generated scripts to the iSeries system and run them
to create the required resources.
After you have finished configuring
the database, you can use the server administrative console to test
the database configuration. To do this, navigate to the appropriate
JDBC data source and select the Test Connection option.