Re: Identifying problem sql's via onstat

We are currently evaulating tools from Platinum's DBvision and BMC's Patrol. Hoping they give us some more info on it. But both product seems to have very little on Informix SQL drilldown in their tools. Anybody can share experience? Thanks. Chris Steve Gould (sg@leaderflush.co.uk) wrote: : Has anyone written a unix or awk script : to identify the link between a running unix : processes and sql statements which are : effecting performance. I can manually run : onstat -u to give me the session id and : then onstat -g ses sessid to give me that : specific sql. But I can't identify the sessions : that are causing the greatest drag on : performance as they occur. Read/write : statistics from onstat -u don't show me : indexing/lock contention problems. : Thanks : Steve Gould -- Chris Lo mailto: cklo@hk.super.net System Administrator/Informix DBA mailto: cklo@cklo.hk.super.net The Prudential Assurance (HK) Co. Ltd mailto: paclck@hk.net ============================================================================== -- Linux + FreeBSD + HPUX + Solaris + AIX ============================================================================== #include <std/disclaimer.h>