mesure user activity

Saludos and greatings to everybody >From time to time I have the need of knowing what sessions on IDS ar= e the most process, time, resources, etc. consuming. I have different kind of users and everybody make connections to databases (distinct) via dbaccess or socket connection. I'd like to k= now who is the user which is making more queries, updates, process of sto= red procedures, etc. or when logical logs are been full faster than norma= l, identify the session and user in order to know the query. Can anybody give me a cue to follow Thanks in advance. El jue, 02-02-2006 a las 14:53 -0500, Amit Dandekar escribi=C3=B3: > You need to pass them as connection properties.=20 > for example=20 > "jdbc:informix-sqli://123.45.67.89:1533/testDB:=20 >=20 >=20 > INFORMIXSERVER=3Dmyserver;user=3Drdtest;password=3Dtest;DB_LOCALE==3Dja_jp.sjis;CLIENT_LOCALE=3Dja_jp.ujis"=20 >=20 > Refer to Informix JDBC Programmers guide for further=20 > details.=20 >=20 >=20 > http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.= jdbc.doc/jdbc.htm=20 >=20 > --- OZ SHIMONY <ozs@cbs.gov.il> wrote:=20 >=20 > >=20 > > once we used odbc to connect to ids we where able to=20 > > enter dblocale and client=20 > > locale in the odbc string=20 > >=20 > > now via jdbc the rules are differnt and we can not=20 > > get proper connection to=20 > > the db=20 > > does anyone know where to change it=20 > >=20 > >=20 > >=20 >=20 > *******************************************************************= ************=20 > >=20 > > Forum Note: Use "Reply" to post a response in the=20 > > discussion forum.=20 > >=20 > >=20 >=20 >=20 > *******************************************************************= ************=20 > Forum Note: Use "Reply" to post a response in the discussion foru= m.=20 >=20

You need to monitor syssesprof and syssessions. There are tools that do this for you and maintain an historical database which you can scan, report, and drill down through. One such is CobraTech's CobraSonic (see their link on the IIUG site). Art S. Kagel ----- Original Message ----- From: N•Stor G•Me.... <ids@iiug.org> At: 3/ 8 22:16 Saludos and greatings to everybody >From time to time I have the need of knowing what sessions on IDS ar= e the most process, time, resources, etc. consuming. I have different kind of users and everybody make connections to databases (distinct) via dbaccess or socket connection. I'd like to k= now who is the user which is making more queries, updates, process of sto= red procedures, etc. or when logical logs are been full faster than norma= l, identify the session and user in order to know the query. Can anybody give me a cue to follow Thanks in advance. El jue, 02-02-2006 a las 14:53 -0500, Amit Dandekar escribi=C3=B3: > You need to pass them as connection properties.=20 > for example=20 > "jdbc:informix-sqli://123.45.67.89:1533/testDB:=20 >=20 >=20 > INFORMIXSERVER=3Dmyserver;user=3Drdtest;password=3Dtest;DB_LOCALE==3Dja_jp.sjis;CLIENT_LOCALE=3Dja_jp.ujis"=20 >=20 > Refer to Informix JDBC Programmers guide for further=20 > details.=20 >=20 >=20 > http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.= jdbc.doc/jdbc.htm=20 >=20 > --- OZ SHIMONY <ozs@cbs.gov.il> wrote:=20 >=20 > >=20 > > once we used odbc to connect to ids we where able to=20 > > enter dblocale and client=20 > > locale in the odbc string=20 > >=20 > > now via jdbc the rules are differnt and we can not=20 > > get proper connection to=20 > > the db=20 > > does anyone know where to change it=20 > >=20 > >=20 > >=20 >=20 > *******************************************************************= ************=20 > >=20 > > Forum Note: Use "Reply" to post a response in the=20 > > discussion forum.=20 > >=20 > >=20 >=20 >=20 > *******************************************************************= ************=20 > Forum Note: Use "Reply" to post a response in the discussion foru= m.=20 >=20 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.