Re: Two databases, same name, same machine

brinama@compans.com wrote: : Hi, I hope someone can help, : What I would like to know is can I run two seperate databases with the : same name on the same machine under Online 5 : Both databases will have exactly the same tables, applications, stored : procs etc, but will hold two distinct sets of data - 2 different : companies. : I wish users to be able to use one database at a time, eg 50 users : using one and 50 using the other at the same time, but no one user : using both at the same time. : Also, any ideas as to how system performance might be affected by : this? : Any suggestions most welcome. In the tbconfig file for each database(each tbconfig must be named differently) set the SERVERNUM and DBSERVERNAME to different values in each file. For each user the TBCONFIG environment variable must be set to point at the tbconfig file for the database they wish to use. i.e. setenv TBCONFIG tbconfigA oR setenv TBCONFIG tbconfigB