Extensions of DB2 engine

[knurgb]

Hi.

Is there something like Extension Manager in Lotus Domino
for DB2 database? This means ability to add plugin to
database engine that will receive message when any command
is issued.
E.g.: I would like to filter database INSERT commands
and add some action then.

I know this is possible with triggers however I would
like to achieve this only via adding this plugin.

Thanks in advance,
Grzegorz

[Larry]

Re: Extensions of DB2 engine

Only things I can think of that might be like this are the audit
facility and possibly use of SNMP alerts. Not sure if Tivoli database
monitoring might be able to do something like this also.

Larry E.

knurgb wrote:[color=blue]
> Hi.
>
> Is there something like Extension Manager in Lotus Domino
> for DB2 database? This means ability to add plugin to
> database engine that will receive message when any command
> is issued.
> E.g.: I would like to filter database INSERT commands
> and add some action then.
>
> I know this is possible with triggers however I would
> like to achieve this only via adding this plugin.
>
> Thanks in advance,
> Grzegorz
>[/color]

[Knut Stolze]

Re: Extensions of DB2 engine

knurgb wrote:
[color=blue]
> Is there something like Extension Manager in Lotus Domino
> for DB2 database? This means ability to add plugin to
> database engine that will receive message when any command
> is issued.
> E.g.: I would like to filter database INSERT commands
> and add some action then.
>
> I know this is possible with triggers however I would
> like to achieve this only via adding this plugin.[/color]

Could you explain a bit why you don't want to use triggers?

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena

[knurgb]

Re: Extensions of DB2 engine


Knut Stolze napisal(a):[color=blue]
> knurgb wrote:
>[color=green]
> > Is there something like Extension Manager in Lotus Domino
> > for DB2 database? This means ability to add plugin to
> > database engine that will receive message when any command
> > is issued.
> > E.g.: I would like to filter database INSERT commands
> > and add some action then.
> >
> > I know this is possible with triggers however I would
> > like to achieve this only via adding this plugin.[/color]
>
> Could you explain a bit why you don't want to use triggers?
>[/color]

I want to apply it for existing database.
I do not want to interfere with schema.

Regards,
Grzegorz