"Ron VanDerMaarel" <vdm1965> wrote in message
news:1b5085f9.0309151156.3660e773posting.google.c om...You don't need a separate instance, just another database in the same> Hi,
>
> I have two people that will be using the same system to do their DB2
> testing, but I want each of them to have their own database. Can
> anyone step me through setting up two copies of the same database on
> the same system. I am running DB2 V6.1 on Windows 2000.
>
> I have created a second instance using db2icrt, but when I try to
> create the database it gives me the following message:
>
> SQL1005N The database alias "DBNAME" already exists in either the
> local database
> directory or system database directory.
>
> Thanks
> Ron
instance. You can backup one database, and then restore it using another
database name. Then the client program accessing the database can use the
alias to change the name back to the original name (if needed).
But no computer (client or DB2 server) can have the same alias name in their
database directory. Existing database definitions need to be uncatalogued.
Bookmarks