Skip to Content
avatar image
Former Member

Java_com_sybase_asa_logon_ASAConnect_shutdownEngine

Dear colleagues,
A customer uses SQL Anywhere 9, if they start the database with dbsrv9, the operation on database is very slow(about 20 minutes). And if they start the database with dbeng9,the same operation on database is fast(about 30 seconds.) The total operations are as following,
(1) The app connects to the Application Server to get some data, then disconnect from the Application Server;
(2) The app connects to the SQL Anywhere 9 database to do some operation(including select, update, insert, etc.)

In the past they uses SQL Anywhere 9 as standlone (The app and database on the same compute), now they want to use SQL Anywhere 9 as network(the app and database on the seprate computers).

From the operation system network monitor there is the much following info,
#1  0x40e836e1 in Java_com_sybase_asa_logon_ASAConnect_shutdownEngine () from /smc20/sybase/libdblib9.so


What's the posible reason about this, and is there some configuration to resolve this?

Thanks.

Jun Wang.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 21, 2014 at 06:41 PM

    You haven't supplied enough information to get a good response to your question. You should include information like:

    Is the hardware where the database server is running the same in both cases?

    Is the database the same in both cases?

    Is the network connection fast? How long does it take to copy a file over the network?

    Is the application going through the application server in both cases?

    There are various tools you can use to look at performance.  They are documented here:

    http://dcx.sybase.com/index.html#sa160/en/dbusage/ug-perform.html

    --Jason

    Add comment
    10|10000 characters needed characters exceeded