Re: Monitoring database at work

In article <8h183j$rgh$1@nnrp1.deja.com>, mars1972@my-deja.com wrote: > 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. > ISA is very nice. Here's a cut from the README: ============================================================= With Informix Server Administrator you can use a browser to perform these common database-sever administration tasks: - Checking dbspaces, database catalogs, logs, and other objects. - Changing configuration parameters temporarily or permanently. - Managing logical and physical logs - Examining memory use and adding and freeing memory segments - Reading the message log - Changing the database server mode between on-line and off-line and its intermediate states - Backing up and restoring dbspaces - Running various onstat commands to monitor performance - Entering SQL statements and examining database schemas - Adding and removing storage spaces, including spaces that are unique to IDS with the UD Option and IDS.2000 database servers - Examining and managing user sessions - Examining and managing Virtual Processors (VPs) - Examining and managing processes and objects that are unique to IDS with AD and XP Options and Informix EDS database servers Dave Sent via Deja.com http://www.deja.com/ Before you buy.