Hi all

I have a monitoring application that running outside the DB server that every 1 minutes queries the snapshot tables and logs it into an internal repository of it. for later tuning.

I have a problem with getting SQL statements from it that has non-english letters inside.

here is small sample test I did from control center to simulate the problem :

select stmt_text from
table(snapshot_ statement('DBNA ME',-1))...

Hi. I am writing a small monitoring tool for our operators that can monitor our DB2 databases in the organization. I know there are plenty of tools out there but I need something very customized that will be plugged into one of our main monitoring systems.

What I need is actually a query that returns all the active sessions, and for each of them I am mostly interested in :

* Agent id (to locate the process in the Os)...