Querying Data From DB2 database and storing it in some other database (Oracle,Sybase) in Unix

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

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