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 a Service to Start and Stop the SQL Anywhere Database

Create a Service to Start and Stop the SQL Anywhere Database

Use the commands that apply to your environment to create a service to start and stop the SQL Anywhere 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 SQL Anywhere service.

   SQLANYWHERE_DIR\dbsvc.exe -t Network -s Automatic -as -i -sn SQLANYWHERE_SERVER -y -w SQLANYWHERE_SERVER SQLANYWHERE_DIR\dbsrv12.exe -n SQLANYWHERE_SERVER -x tcpip(PORT=SQLANYWHERE_PORT) DATABASE_DIR\DATABASE_NAME.db DATABASE_DIR\AUDIT_DATABASE_NAME.db
   

3. (UNIX) Execute the following command to create the SQL Anywhere service.

   $SQLANYWHERE_DIR/dbspawn $SQLANYWHERE_DIR/dbsrv12 -n "$SQLANYWHERE_SERVER" -x \""tcpip(port=$SQLANYWHERE_PORT)"\" "$DATABASE_DIR/$DATABASE_NAME.db" "$DATABASE_DIR/$AUDIT_DATABASE_NAME.db"
   

4. (Windows) Execute the following command to start the new SQL Anywhere service.

   SQLANYWHERE_DIR\dbsvc.exe -u SQLANYWHERE_SERVER