Hi Pravin,
Got your suggestion. A small question.
Any idea where I can find information about the instances. To be specific informational data about the starting and stopping of the DB2 instances. I was thinking that DB2 might be supporting Database Level Event Triggers, like Oracle. But till now from all the info that I've gathered it seems that DB2 does not support that.
And from my limited knowledge I am not able to find any system tables where there is information about the instances.
Amit
On Thu, 27 May 2004 Praveen Chengalathu wrote :
>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.
>**********************************************************************
>
>
>
>
>---------------------------------------------------------------------
>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]
>
DB2 & UDB email list listserv db2-l LazyDBA home page