WebSphere

Configuring an Informix event database

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
  1. Start the wsadmin tool.
  2. 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.

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.620.doc/doc/tcei_configure_informix.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).