Amit,

These are some options..

0. Use Oracle generic connectivity using ODBC or OLEDB to connect to the DB2
or any other other database(s) which support these interfaces. This should
be the cheapest option.

1.If the new central repository is to setup be in DB2 then using DB2
federated access you could read from Oracle, Sybase,MS SQL etc...
databases.To do this setup the new repository in DB2 with federeated
connections to DB2,Oracle etc. Refer DB2 Federated Systems Guide for further
details. You may have to procure new tools like DB2 relational connect.

2. Oracle Warehouse Builder(Similarly you could have a look at DB2 Warehouse
Center(not DB2 Warehouse Manager) which is part of every DB2 package)
should provide access to other databases for building an Oracle based
central repository.

3.If you need to continue using Oracle as the central repository then
another tool which you could look at is DB2 Information Integrator(ealier
know as DataJoiner). This will provide two way read-write access to all
these databases. This is the most function rich option available which will
enable you to do 2 way replication etc.But this is an expensive option
,probably an overkill in your case! Similar product in Oracle is Oracle
Transparent Gateway.

4. Extract data from DB2 in ASCII DEL format and Import to Oracle.You could
script this up!!


Trust this helps.


Praveen





-----Original Message-----
From: amit b
[mailto:db2udbdba-ezmlmshield-x49384222.[Email address protected]
Sent: 27 May 2004 09:33
To: LazyDBA Discussion
Subject: Querying Data From DB2 database and storing it in some other
database (Oracle,Sybase) in Unix


Hi,

I've a strange requirement. We are trying to keep track of our DB2 instances
running on the Unix machines.

The Scenario is:
---------------------
There are Oracle instances running in the many Unix boxes and whenever there
is a startup or shutdown of any instance we take the instance data and store
it in a centralized repository. Here the repository is an Oracle database
running in a separate unix machine.

Now we have to do the same thing for UDB instances running on those Unix
boxes. The point here is...

1) Can we query those data from the UDB instances and store it in the
centralized repository. Please make note that the centralized repository is
an Oracle database. Can we query data from UDB instance and store it in some
other database. Or do we have to create a separate repository for UDB
databases.

2) Any suggestions as to how I go about making this possible

Any help will be appreciated.

Thanks,
Amit


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]

**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]

This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************



DB2 & UDB email list listserv db2-l LazyDBA home page