You can configure an external event database using IBM® Informix® Dynamic Server on a Linux®, UNIX®,
or Windows® system.
About this task
To configure an Informix event
database:
Procedure
- Start the wsadmin tool.
- Use the AdminTask object to run the configEventServiceInformixDB administrative
command in batch or interactive mode. The minimum required
parameters of the configEventServiceInformixDB 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.
Privileges: If you specify true for
this parameter, make sure your user ID has sufficient privileges for
creating Informix databases,
dbspaces, tables, views, indexes, and stored procedures.
- 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.
- jdbcClassPath
- The path to the JDBC driver. Specify only the path to the driver
file; do not specify the file name.
- dbInformixDir
- The directory where the Informix database
software is installed. This parameter is required only if you specified true for
the createDB parameter.
- dbHostName
- The host name of the system where the database server is installed.
- dbServerName
- The Informix server
name (for example, ol_servername).
- dbUser
- The Informix database
schema user ID that will own the event database tables. This must
be a user ID with sufficient privileges to create databases and dbspaces.
The WebSphere® data source
uses this user ID to authenticate the Informix database connection.
- dbPassword
- The password of the specified schema user ID.
Other parameters might be required for your environment.
For a complete list of parameters and usage information, refer to
the help for the configEventServiceInformixDB administrative
command.
Results
The administrative command creates the required data source
at the specified scope; if you specified true for
the createDB parameter, the command also runs the generated database
configuration script to create the database.
The generated database
configuration scripts are stored by default in the
profile_root/databases/event/
node/
server/dbscripts/informix
directory. (In a Network Deployment environment, these scripts are
stored under the deployment manager profile 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.
Running the scripts: The database configuration
and removal scripts generated by the configEventServiceInformixDB administrative
command require the dbaccess command in order to run SQL scripts.
This command might be available only on the Informix server. Therefore, if the Informix server is on a different
system from the server, the database configuration scripts might need
to be copied to the Informix server
and run locally.