Error "SQL1005N The database alias "XXXX" already exists in either the local database directory or system database directory." (4229654)

Tchater maintenant avec le support

Error "SQL1005N The database alias "XXXX" already exists in either the local database directory or system database directory." (4229654)

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Error "SQL1005N The database alias "XXXX" already exists in either the local database directory or system database directory."
Description

When trying to create two instances in DB2 with the same name, the following message appears:
"SQL1005N The database alias "MYDB2" already exists in either the local database directory or system database directory."
Cause

The alias "MYDB2" already exists in the catalog.
Résolution

RESOLUTION:
The DB Alias "MYDB2" already exists in the DB2 client catalog. It's not possible to catalog two aliases with identical names; it's a restriction of the DB2 client and all database aliases must have a unique name.
Informations supplémentaires

Here's some additional information about this topic: https://www.toadworld.com/platforms/ibmdb2/w/wiki/7429.database-aliases-ibm-db2-luw "In addition to this, when configuring a database connection from a DB2 UDB client, aliases can also be used to connect to different databases that share the same name. When configuring connections to databases with the same name, you specify the alias in the CATALOG DATABASE command."

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 4/8/2016
Dernière mise à jour le : 5/7/2023

Titre