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
- 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.
- Using an ASCII text editor, make any required modifications
to the cr_event_db2iseries script.
- Start the Qshell interpreter.
- 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
- 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.