WebSphere

Manually creating a DB2 event database on an iSeries system

Use the cr_event_db2iseries command to manually generate a database configuration script for a DB2® event database on an iSeries® system

About this task

To manually run the generated database configuration script for a DB2 event database on an iSeries system:

Procedure
  1. On the server system, go to the directory containing the generated script. The default location is the profile_root/databases/event/node/server/dbscripts/db2iseries directory; if you specified a value for the outputScriptDir parameter of the database configuration administrative command, the scripts are stored in that location instead.
  2. Using an ASCII text editor, make any required modifications to the cr_event_db2iseries script.
  3. Start the Qshell interpreter.
  4. Run the database creation script using the following syntax:
    cr_event_db2iseries db_user db_password
    The parameters are as follows:
    db_user
    The database user ID. This parameter is required.
    db_password
    The password for the database user. This parameter is required.
    For example, the following command would create the DB2 event database using the user ID db2admin and the password mypassword:
    cr_event_db2iseries db2admin mypassword
  5. Restart the server. For a federated node, you must also stop and restart the node agent using the stopNode and startNode commands.

What to do next

After you finish configuring the database, you can use the administrative console to test the database configuration. To do this, navigate to the appropriate JDBC data source and select the Test Connection option.


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_run_db_script_db2_iseries.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).