Creating a Sybase Database

Edit online

About this task

When using Sybase, create the database data and log devices and then create the Trading Manager database using these devices. The minimum disk space for the database data device is 100 MB. The minimum disk space for the database log device is 20 MB.

Note: If any part of this step needs to be repeated, a file named sybasedropnn.sql can drop all the tables created by sybaseinstnn.sql. Use caution, as the sybasedropnn.sql routine deletes all Partner Manager tables and data and cannot be reversed. It should only be used if these steps need to be repeated.

To create the Sybase Database, perform the following steps:

Procedure

  1. Open the SQL editing tool.
  2. Select File > Open and open the installation script from the default Trading Manager installation directory. If you changed the default directory during installation, use the correct directory for your install. Select the sybaseinst82.sql script.
  3. Execute the sybaseinst82.sql.
  4. Execute the installation script and wait for the last output message to be displayed. The message will read: Install Complete.
    Note: On some versions of Sybase, you will receive the following warning: Row size could exceed row size limit, which is xxxx bytes (where xxxx can vary). Ignore this warning.
  5. Check the output for errors; resolve any errors before proceeding.
  6. Select File > Open and open the file sqlupdate82to821.sql.
  7. Execute sqlupdate82to821.sql and wait for completion.
  8. Select File > Open and open the file sybaseloadnn.sql.
  9. Execute sybaseloadnn.sql and wait for it to complete.
  10. Check the output for any errors.
  11. Select File > Open and open the file sybaseloadnn_2.sql.
  12. Execute sybaseloadnn_2.sql and wait for it to complete.
  13. Check the output for errors.
    Note: These scripts do not contain a COMMIT statement. You must manually issue a commit if your database environment is not set to auto-commit.