Same Database on Same System - IBM DB2

[Ron VanDerMaarel]

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

[Mark A]

"Ron VanDerMaarel" <vdm1965> wrote in message
news:1b5085f9.0309151156.3660e773posting.google.c om...

> 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

You don't need a separate instance, just another database in the same
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.