LSF Version 7.3 - Administering Platform LSF

Move to a Production Database
652 Administering Platform LSF
2 Run the script to create the EGO database schema.
sqlplus user_name/password@connect_string @egodata.sql data_tablespace
index_tablespace
where
◆ user_name is the user name on the database server.
◆ password is the password for this user name on the database server.
◆ connect_string is the named SQLNet connection for this database.
◆ data_tablespace is the name of the tablespace where you intend to store the
table schema.
◆ index_tablespace is the name of the tablespace where you intend to store the
index.
3 In the command console, open the LSF database schema directory.
◆ UNIX: cd $PERF_TOP/lsf/version/DBschema/Oracle
◆ Windows: cd %PERF_TOP%\lsf\version\DBschema\Oracle
4 Run the script to create the LSF database schema.
sqlplus user_name/password@connect_string @lsfdata.sql data_tablespace
index_tablespace
where
◆ user_name is the user name on the database server.
◆ password is the password for this user name on the database server.
◆ connect_string is the named SQLNet connection for this database.
◆ data_tablespace is the name of the tablespace where you intend to store the
table schema.
◆ index_tablespace is the name of the tablespace where you intend to store the
index.
Create a MySQL database schema
Prerequisites: The MySQL database is properly configured and running:
◆ You have a user name, password, and URL to access the database server.
◆ You installed the latest JDBC driver
(
mysql-connector-java-3.1.12-bin.jar or newer) for the MySQL
database. This driver is available from the following URL:
http://dev.mysql.com/downloads/
1 In the command console, open the EGO database schema directory.
◆ UNIX: cd $PERF_TOP/ego/version/DBschema/MySQL
◆ Windows: cd %PERF_TOP%\ego\version\DBschema\MySQL
2 Run the scripts to create the EGO database schema.
mysql --user=user_name --password=password --database=report_database < egodata.sql
where