Statement event monitor doesnt report statement text

[JS]

I have v8.1 fix5 using Win2k AS on 7 node logical system.
I create event monitor writing to file and turn it on. Using
application, I connect to db and navigate from screen to screen,
generating reports using select sql. I flush the buffer, turn the
event monitor off and format the data with db2evom. But, the output
never contains the statement text. But, if I issue sql from the clp,
these statements appear in the output.

In addition, does anybody know what the on node # <global, local>
clause of the create event monitor statement does? I can't get it to
work, I think there must be an error in the documentation regarding
the correct syntax and use.

Similarly, adding where conditions to the create event monitor
statement doesn't seem to work, the event monitor contains data for
all connections to the db even if appl_name is specified in the create
event monitor statement.

Finally, if i create event monitor from clp, why does it not appear in
Control Center, even if Control Center is refreshed? It seems only
write to table event monitors will appear in Control Center. Is this
the correct behaviour?

I liked the Gui tool in V7 much better, lol. This hardly seems like
improvement.
Thanks

[Serge Rielau]

JS, are you only missing the text or the whole entry?
In DPF monitoring to a table is quite picky.
You need to have that table in a nodegroup which covers all the nodes
you want to monitor (which is logical with 20/20 hindsight).
I know that teh statement event monitor actually has an option to
supress teh text or to limit it to a varchar() to improve performance.
Maybe that's what's kicking in....

Cheers
Serge

[JS]

Serge Rielau <sr*****@ca.eye-bee-em.com> wrote in message news:<tN***************@news04.bloor.is.net.cable. rogers.com>...

JS, are you only missing the text or the whole entry? I am missing the whole query, otherwise the event monitor reports
everything else. In DPF monitoring to a table is quite picky.
You need to have that table in a nodegroup which covers all the nodes
you want to monitor (which is logical with 20/20 hindsight). Yes, that is the case, the table is created in a nodegroup that all
nodes share.
I know that teh statement event monitor actually has an option to
supress teh text or to limit it to a varchar() to improve performance. I know there is a document on passport advantage site (which is
locked) that describes some problem with the ON NODE 1 LOCAL/GLOBAL
statement, unfortunately, I can't get access to it, Can u post the
correct syntax for creating an event monitor, although my
understanding is that with DPF event monitor monitors all nodes by
default and it cant be restricted to a specific node. Is that correct? Maybe that's what's kicking in....

Cheers
Serge