Discussion :

[Job]

Bonjour,

Je suis débutant en DB2 et je souhaite faire des jointures entre des bases de données qui sont sur le même serveur DB2 et sur une instance différente ou non.

J'ai découvert qu'il y a la possibilité de créér des object de base de donnée fédérée qui pourais m'aidé mais je n'arrive pas à les configurer correctement.
En effet, à la création par l'interface graphique, je ne peut pas créer d'alias de type nickname.

je ne trouve pas de tutoriel décrivant les étapes de configurations.
Comment peut on lier des bases de données entre elles pour un naviguer via SQL ?

Merci de votre aide

[Oratorio]

Je fais copier/coller d'un texte que j'ai trouvé quelque part :

What you are looking to do can be done by setting up what's called a federated database. DB2 can use the FEDERATED database features to connect to SQL Server, Oracle, etc. I didn't think federation was allowed with Express-C, but since I was able to get it working, I assume that means its allowed and you can only connect to other DB2 databases.

There's a few steps to doing this.

1. Create a wrapper. This is the nuts and bolts that DB2 uses to communucate with the other database.
2. Create a server. This is the server you will be connecting to (which for this tutorial, is the same physical box)
3. Create a nickname. This is the nickname of an object in the federated database.

Follow along with this simple tutorial.

First, enable FEDERATED support in the database manager configuration. From a command prompt, enter:

db2 update dbm cfg using federated yes

Now restart the instance:

db2stop
db2start

We'll use Control Center to set up the rest. I will use two databases for my sample, which happen to be in the same instance, so we can use the same UserID/Password (instance owner) for everything. For the purpose of this tutorial, you'll need to substitute your database names and objects with what I will be using.

MYDB1 - the main database
MYDB2 - the other database
I will set up a nickname for the MYTABLE2 table in MYDB2.

1. Connect to MYDB1 in Control Center.
2. Right-click Nicknames,and click Create...
3. Click Next
4. For Data Source Type, select DB2.
5. Click the Create button.
6. Accept the defaults and click OK.
7. Click Next.
8. Click the Create button.
9. Click Add
10. Enter a name for the server, set the DB type, version, and enter the logon information to connect to this server.
11. Click the Settings tab, enter the database name you want to connect to. Click OK.
12. Click OK again.
13. Click Next.
14. Click Create.
15. Select the local user you will be using (use the instance owner's ID).
16. Click the Settings tab, enter the UserID and password for the instance owner.
17. Click OK.
18. Click Next.
19. Click Add.
20. Select a unique name for this NICKNAME, and enter the schema.table name in the MYDB2 database.
21. Click OK (repeat for other tables if necessary)
22. Click Finish and sit back...

After this, you should be able to use the tablename as you would in any other query.

Ex:
select *
from mytable1, mytable2