Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    4

    Question Unanswered: Starting Two database using SQL Anywhere Studio 9.0.2 on one Linux Server

    Hi good people,
    I need to start two databases with different names on one server but after starting the first one, Linux displays the following msg

    [root@eqchange sqlanywhere]# service SQLAnywhereService start
    Attempting to start Adaptive Server Anywhere
    Adaptive Server Anywhere Start Server In Background Utility Version 9.0.2.2452
    Database server already running
    Adaptive Server Anywhere Start Server In Background Utility Version 9.0.2.2452
    Database server already running

    My init file is as follows:-

    ./opt/sybase/SYBSsa9/bin/asa_config.sh > /dev/null
    # The following command must be entered all on one line.
    dbspawn "dbsrv9 -c 300M -n BRalex -gd all -ud -o /var/log/BRalex.log /data/BRalex.db"
    dbspawn "dbsrv9 -c 300M -n BRGonza -gd all -ud -o /var/log/BRGonza.log /data/BRGonza.db"



    Am able to start the two databases on one server in a windows environment. Does any one have an idea on haw to archive this using Linux
    Last edited by aleale; 07-30-07 at 05:40.

  2. #2
    Join Date
    Jul 2007
    Posts
    6
    You can start both databases on the same server:
    dbspawn "dbsrv9 -c 300M -n BRalex -gd all -ud -o /var/log/BRalex.log /data/BRalex.db /var/log/BRGonza.log /data/BRGonza.db"

    If the server is already running, you can start another database on it using the START DATABASE command from a dbisql session.

    If you want to have two separate servers running, you can use the dbspawn -f switch:
    dbspawn -f "dbsrv9 -c 300M -n BRalex -gd all -ud -o /var/log/BRalex.log /data/BRalex.db"
    dbspawn -f "dbsrv9 -c 300M -n BRGonza -gd all -ud -o /var/log/BRGonza.log /data/BRGonza.db"

  3. #3
    Join Date
    May 2007
    Posts
    4
    Thanks man,
    I will try this out as see tell you the outcome

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •