Use this topic to manually create the database, tablespace, tables, and populate the data required for WebSphere® Sensor Events. If you are using the WebSphere Sensor Events installer to install and create the database, you do not need to follow these steps.
If you choose to install WebSphere Business Events remotely, then you will need to manually create the DB2® or Oracle database. See the WebSphere Business Events Information Center for more information.
Use these instructions when a Database Administrator creates the database and tablespace manually, and then the tables and data are created during the installation of WebSphere Sensor Events.
If you are using Oracle, you should have been prompted to create the SID when you installed the product. If not, refer to the Oracle documentation to set up a SID.
Run the scripts provided in the db_script directory on the WebSphere Sensor Events CD to create the database, tablespace, tables and populate data.
Before running the scripts be aware of the following restrictions and take the appropriate action:
For DB2:
createIBMRFID_db2.bat dbName longTablespaceFile longTempTablespaceFile
createIBMRFID_db2.sh dbName longTablespaceFile longTempTablespaceFile
For Oracle:
createIBMRFID_oracle.bat dbUser dbPassword dbSpec longTablespaceFile
createIBMRFID_oracle.sh dbUser dbPassword dbSpec longTablespaceFile
The database, tablespace, table and data are created under dbSpec.