I want to run two ASA 7 Databases on the same server. One
for our timeclock app and the other for our menu system.
I've been warned that it could cause conflicts. Is it
possible to run two DBs on the same server?

In article <3fd8c253.2c27.846930886 (AT) sybase (DOT) com>, aprykhus says...
Quite easy, in fact. The only thing to watch out for is to be sure
you know which one is on which port number, and specify that in the
startup config.




--
Dave Kerber
Fight spam: remove the ns_ from the return address before replying!

REAL programmers write self-modifying code.

If you mean on the same database engine, it is simply adding each database
file name to the command line at startup. For example,

dbsrv7 {server_options} database1.db {database_options}
database2.db {database_options} .... databaseN.db {database_options}


--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** **************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** **************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

************************************************** **************************
*

<aprykhus> wrote

The only thing you will want to watch for is "mismatch" in page size. If
the databases have a different page size then you will have an inefficient
use of cache because cache pages will be allocated at the same size as the
largest page size used by the mounted database.

Example

dbsrv9.exe 2kpage.db 4kpage.db

This server will allocate cache pages at 4K for both db's, but since
2kpage.db has 2K page sizes only have of each cache page is being used.

The engine will still run, but it's something to consider.

You can change page size by rebuilding (using dbunload) a database.


____________
Gerald Gillespie
Technical Support
iAnywhere Solutions

Whitepapers, TechDocs, bug fixes are all available through the
iAnywhere Developer Community at
http://www.ianywhere.com/developer


"Chris Keating (iAnywhere Solutions)" <FightSpam_keating (AT) iAnywhere (DOT) com>
wrote in message news:3fd8cc23$1 (AT) forums-1-dub (DOT) ..