Configuration Assistant problem

[Thames]

For the Configuration Assistant,
why gave me such errors when I try to add remote database "sample" on
linux (DB2 ESE UDB version 8)using "add database wizard" to my local
DB server


*************** *************** *************** *************** *******
SQL1005N The database alias "SAMPLE" already exists in either the
local database directory or system database directory.



Explanation:

The alias name specified has already been used. If no alias is
specified in the catalog database command, the database name is
used as the alias. When a database is created, the alias name is
the same as the database name.

This error may occur on the catalog database command when the
alias already exists in the system database directory.

On the create database command this error may occur in one of
the following situations:

o The alias already exists in the system database directory and
local database directory.

o The alias already exists in the system database directory but
not in the local database directory.

o The alias already exists in the local database directory but
not in the system database directory.



User Response:

For the catalog database command, uncatalog the alias from the
system database directory and resubmit your original command or
catalog the database with a different alias name.

For the create database command, do the following operations
with respect to the above 3 situations:

o Drop the database using the alias name. Resubmit your
original command.

o Uncatalog the alias. Resubmit your original command.

o Catalog the alias into the system database directory. Drop
the database using the same alias. Resubmit your original
command.

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


The problem seems that remote database I tried to connect has the name
conflict with database "sample" on my local DB server



Does anybody experience such a problem?
How can I rename the remote db name?

Any soutions will be appreciated!


Many thanks

[Larry]

Re: Configuration Assistant problem

Probably because you already have a SAMPLE database on your local
machine. You can't have two databases with the exact same alias in your
local db directory. Try using a different name for the remote sample
database.

Larry Edelstein

Thames wrote:[color=blue]
> For the Configuration Assistant,
> why gave me such errors when I try to add remote database "sample" on
> linux (DB2 ESE UDB version 8)using "add database wizard" to my local
> DB server
>
>
> *************** *************** *************** *************** *******
> SQL1005N The database alias "SAMPLE" already exists in either the
> local database directory or system database directory.
>
>
>
> Explanation:
>
> The alias name specified has already been used. If no alias is
> specified in the catalog database command, the database name is
> used as the alias. When a database is created, the alias name is
> the same as the database name.
>
> This error may occur on the catalog database command when the
> alias already exists in the system database directory.
>
> On the create database command this error may occur in one of
> the following situations:
>
> o The alias already exists in the system database directory and
> local database directory.
>
> o The alias already exists in the system database directory but
> not in the local database directory.
>
> o The alias already exists in the local database directory but
> not in the system database directory.
>
>
>
> User Response:
>
> For the catalog database command, uncatalog the alias from the
> system database directory and resubmit your original command or
> catalog the database with a different alias name.
>
> For the create database command, do the following operations
> with respect to the above 3 situations:
>
> o Drop the database using the alias name. Resubmit your
> original command.
>
> o Uncatalog the alias. Resubmit your original command.
>
> o Catalog the alias into the system database directory. Drop
> the database using the same alias. Resubmit your original
> command.
>
> *************** *************** *************** *************** ****
>
>
> The problem seems that remote database I tried to connect has the name
> conflict with database "sample" on my local DB server
>
>
>
> Does anybody experience such a problem?
> How can I rename the remote db name?
>
> Any soutions will be appreciated!
>
>
> Many thanks
>[/color]

[Thames]

Re: Configuration Assistant problem

How can I rename remote database "sample" ?
thanks

[Knut Stolze]

Re: Configuration Assistant problem

Thames wrote:
[color=blue]
> How can I rename remote database "sample" ?[/color]

Just catalog it using a different name. You could also do this:

db2 UNCATALOG DB sample
db2 CATALOG DB sample AS local_s

Then you can catalog the remote SAMPLE database and still talk to the local
SAMPLE database. The latter will only be accessible by connecting to
LOCAL_S, though.

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena

[Larry]

Re: Configuration Assistant problem

I don't think there is a way. You'd need to logon to the remote machine,
drop database sample, and CREATE a new db on that machine calling it
something else. The other option is to leave the remote database named
SAMPLE and create an alias for it that is NOT SAMPLE. You would do this
using the UNCATALOG and CATALOG commands.

Larry Edelstein

Thames wrote:[color=blue]
> How can I rename remote database "sample" ?
> thanks
>[/color]

[Thames]

Re: Configuration Assistant problem

Hi Knut:

it works once I give an alias name for sample as u suggested

tons of thanks