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)) as st
when I run this from DB2 Control Center I get all ok except where I have non-english letters - get "???" or something else.
When I get the snapshot locally on the server using the api :
db2 get snapshot for application agent it XXX
I can see it ok.
the STMT_TEXT column is CLOB an It looks to me there is some kind of problem converting it on the way...
I tried changing a lot of parameters around the client side.. but I think I am unaware to all the options.
Please assist. this is very important to me.
best regards,
elimeli
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)) as st
when I run this from DB2 Control Center I get all ok except where I have non-english letters - get "???" or something else.
When I get the snapshot locally on the server using the api :
db2 get snapshot for application agent it XXX
I can see it ok.
the STMT_TEXT column is CLOB an It looks to me there is some kind of problem converting it on the way...
I tried changing a lot of parameters around the client side.. but I think I am unaware to all the options.
Please assist. this is very important to me.
best regards,
elimeli