Modify Your CA Business Intelligence r3.2 Installation to CA Business Intelligence Release 03.3.00 › Migration from MySQL to SQL Anywhere Database › SQL Anywhere Database Preparation Using Manual Procedures › Create CMS Repository and Audit Databases

Create CMS Repository and Audit Databases

Use the commands that apply to your environment to create CMS Repository and Audit databases.

Note: The command line syntax in this procedure contains the variables that are defined in Command Line Syntax Variables. Replace these variables (in italics) with the values that are appropriate for your environment.

Follow these steps:

1. Open a command prompt window.
2. (Windows) Execute the following command to create the database for the CMS Repository.

   SQLANYWHERE_DIR\dbinit.exe -o DATABASE_DIR\DATABASE_NAME_check.log 
   -dba ADMIN_UID,ADMIN_PWD DATABASE_DIR\DATABASE_NAME.db
   

3. (UNIX) Execute the following command to create the database for the CMS Repository.

   $SQLANYWHERE_DIR/dbinit -o $DATABASE_DIR/$DATABASE_NAME_check.log 
   -dba $ADMIN_UID,$ADMIN_PWD $DATABASE_DIR/$DATABASE_NAME.db
   

4. (Windows) Execute the following command to create the Audit database.

   SQLANYWHERE_DIR\dbinit.exe -o DATABASE_DIR\AUDIT_DATABASE_NAME_check.log 
   -dba ADMIN_UID,ADMIN_PWD DATABASE_DIR\AUDIT_DATABASE_NAME.db
   

5. (UNIX) Execute the following command to create the Audit database.

   $SQLANYWHERE_DIR/dbinit -o $DATABASE_DIR/$AUDIT_DATABASE_NAME_check.log 
   -dba $ADMIN_UID,$ADMIN_PWD $DATABASE_DIR/$AUDIT_DATABASE_NAME.db