Creating the databases (optional)Added by IBM on September 9, 2010 | Version 1 (Original)
|This topic describes how to create the Lotus® Expeditor Server databases needed for a remote database environment.
This topic describes how to create the Lotus® Expeditor Server databases needed for a remote database environment.
Client Management services supports storing data in an Oracle database. The Oracle database needs to be installed and running. See the Oracle documentation for information on installing Oracle and creating a database.
For requirements for creating an Oracle database for use with Client Management services, see Installing prerequisite software
- Log in as DB2 Administrator on Windows® system or if on an AIX® or Linux® system, switch to the DB2 instance using su - db2inst1, for instance.
- Ensure that DB2 starts on the database system.
- On the database server system, insert the product installation CD.
Note: You might need to manually mount the product installation CD on AIX or Linux systems.
If the launchpad starts, click Exit to close it.
- Open a command window using the following:
: Open an XTERM window or console.
: Open a command window.
- In the DB2 command window, change the directory to /scripts/remotedb (UNIX®) or \\scripts\\remotedb (Windows) on the product CD.
- If the Lotus Expeditor Server databases exist from a previous installation and you do not plan on reusing this data, you will need to drop them before you create new databases.
- If you previously configured Client Management services, run the following command to drop the existing database:
- If you previously configured Database Synchronization services, run the following command to drop the existing databases:
- Determine which components will be configured.
- If you are configuring Client Management services, run the following command to create the database:
: ./createClientMgmtDBs.sh database_admin_id database_admin_password
: createClientMgmtDBs.bat database_admin_id database_admin_password
- If you are configuring Database Synchronization services, run the following command to create the databases:
: ./createDB2eDBs.sh database_admin_id database_admin_password
: createDB2eDBs.batdatabase_admin_id database_admin_password
Note: You can copy the script from the CD and run it locally if the script needs to be modified. If you want to create databases in different or separate drive(s) or file systems, you can change the property values in the script to one of the following: DEFAULT_DRIVE and DEFAULT_TABLESPACE_PATH.
- Verify that there are no error messages in the command window.
Parent topic: Installation procedures and scenarios: XPD622