Monitoring database at work

Hello, Does anybody know of a comprehensive tool or utility that enables us to monitor several aspects of a running Informix database. We know about the capabilities of onstat, but that tool is not very convenient for close to novice users. Especially we want to get insight in the tables that have locked rows, which processes/users hold the locks. Any advise or tip is apreciated. Thanks, Henk

Have you looked at ISM? It comes with current versions of the engine, or you can download it for free from www/intraware.com/informix. In article <393415A3.6B49A6E6@hccnet.nl>, Henk van der Geld <henk.van.der.geld@hccnet.nl> wrote: > This is a multi-part message in MIME format. > --------------BEA1EE2273D3ADF2DF6B7CF8 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Hello, > > Does anybody know of a comprehensive tool or utility that enables us to > monitor several aspects of a running Informix database. We know about > the capabilities of onstat, but that tool is not very convenient for > close to novice users. Especially we want to get insight in the tables > that have locked rows, which processes/users hold the locks. Any advise > or tip is apreciated. > > Thanks, > Henk > > --------------BEA1EE2273D3ADF2DF6B7CF8 > Content-Type: text/x-vcard; charset=us-ascii; > name="henk.van.der.geld.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Henk van der Geld > Content-Disposition: attachment; > filename="henk.van.der.geld.vcf" > > begin:vcard > n:van der Geld;Henk > tel;home:+31 (0)73 513 01 02 > x-mozilla-html:FALSE > adr:;;;;;; > version:2.1 > email;internet:henk.van.der.geld@hccnet.nl > fn:Henk van der Geld > end:vcard > > --------------BEA1EE2273D3ADF2DF6B7CF8-- > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

Hi Henk, The problems you´ve described could not be easy resolved with isa, because the output is the same as in onstat. We have a tool (ISR-perform Monitoring Option) where you can drill through the informix-data. Navigate through problem-areas like locks,- which user held the lock,- on which table, -who is waiting for it , etc. With this navigation you can get your information most quickly and more detailled than it´s possible with the on-tools. Maybe it should usable for you to know detailled things about the Performance-Aspects. Here´re some examples: -Shared Memory: Cache, Segmente, Usage by user with detailled source informations -Disks: DBSpaces (free space, usage etc ) , Chunks, tables (space, profiles etc), etc -Locks, Logs, expensive sessions (with detailled resource-informations used by the session) -etc Sure this tool is not for free, but really usefull for troubleshooting. You can get quickly information of bottlenecks and critical performance issues on a running Informix Database. If your´re interessted in, please let me know. I can send you some more informations. Greeting, Erik Stahlhut ISR Software-Consulting GmbH www.isr.de Henk van der Geld <henk.van.der.geld@hccnet.nl> schrieb in im Newsbeitrag: 393415A3.6B49A6E6@hccnet.nl... > Hello, > > Does anybody know of a comprehensive tool or utility that enables us to > monitor several aspects of a running Informix database. We know about > the capabilities of onstat, but that tool is not very convenient for > close to novice users. Especially we want to get insight in the tables > that have locked rows, which processes/users hold the locks. Any advise > or tip is apreciated. > > Thanks, > Henk >