Best option would be to use the Control center. In the "Object View",
expand the database entry and at the bottom you'll find "Federated
Objects". You can use that. Or, modify the following script. You'll also
have to update the dbm parameter FEDERATED (set to YES) of the server
from where you'll be accessing the other database.
CREATE WRAPPER "Rahul_DB" LIBRARY 'db2drda.dll' OPTIONS( ADD DB2_FENCED
'N');
CREATE SERVER RAHUL TYPE DB2/UDB VERSION '8.2' WRAPPER "RAHUL_WRAPPER"
OPTIONS( ADD DBNAME 'RAHUL', PASSWORD 'Y');
CREATE SERVER RAHUL TYPE DB2/UDB VERSION '8.2' WRAPPER "RAHUL_WRAPPER"
AUTHID "db2admin" PASSWORD "*****" OPTIONS( ADD DBNAME 'RAHUL', PASSWORD
'Y');
CREATE USER MAPPING FOR "PROCUSER" SERVER "RAHUL" OPTIONS ( ADD
REMOTE_AUTHID '', ADD REMOTE_PASSWORD '*****') ;
CREATE USER MAPPING FOR "PROCUSER" SERVER "RAHUL" OPTIONS ( ADD
REMOTE_AUTHID 'db2admin', ADD REMOTE_PASSWORD '*****') ;
CREATE NICKNAME DB2ADMIN.MY_ATT FOR RAHUL.EONE.tablename;
CREATE NICKNAME schema.MY_ATT FOR RAHUL.schema.tablename;
This is what we used. Please modify the fields. These had been generated
using Control Center. The password was entered for the password fields.
Regards,
-----Original Message-----
From: Jitendra Kumar Prajapati
[mailto:db2udbdba-ezmlmshield-x92852148.[Email address protected]
Sent: Monday, July 31, 2006 12:47 PM
To: LazyDBA Discussion
Subject: Required steps for creating federated database!
Hi all,
Can anybody please tell me what are the steps I need to take for create
a federated database.
Thanks and regards,
Jitendra Kumar Prajapati.
========================================================================
====================================================
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
========================================================================
====================================================
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page