Information about the instance is outside the database. Run the command
"db2cfimp xxxxx" where xxxxx is a file name and you will have the
information
about the instance.

If you want an event based trigger use the apply program that comes with
db2 distributed and define a subscription to be driven on some sql event or
have a shell as part of your startup do an insert to fire the trigger.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"amit b "
<db2udbdba-ezmlms
hield-x79430113.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
05/27/2004 07:37
AM Subject
Re: RE: Querying Data From DB2
database and storing it in some
other database (Oracle,Sybase)
in Un










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]
>



---------------------------------------------------------------------
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