Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / August 2005

Tip: Looking for answers? Try searching our database.

Configuration Assistant problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Thames - 29 Aug 2005 13:00 GMT
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 - 29 Aug 2005 13:43 GMT
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

> For the Configuration Assistant,
> why gave me such errors when I try to add remote database "sample" on
[quoted text clipped - 56 lines]
>
> Many thanks
Thames - 29 Aug 2005 13:47 GMT
How can I rename remote database "sample"  ?
thanks
Knut Stolze - 29 Aug 2005 15:10 GMT
> How can I rename remote database "sample"  ?

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.

Signature

Knut Stolze
Information Integration Development
IBM Germany / University of Jena

Thames - 31 Aug 2005 06:27 GMT
Hi  Knut:

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

tons of thanks
Larry - 29 Aug 2005 19:29 GMT
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

> How can I rename remote database "sample"  ?
> thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.