Re: Error info in Informix?

Urich Ann wrote: > > As a former DB2 DBA, I was able to use a master/console "log" that > identified information(users/resources) on deadlocks, timeouts, etc.. > > Since I am new to Informix, I was wondering if there is a log that would > give me that type of information... > or > ...a way to find out the user and/or resource involved in an error > situation, such as a deadlock? You'd need to look at the sysmaster database, which has all that info in pseudo tables that you can access using SQL. Alternatively, you can use the command line utility onstat. However, this is all 'live' data that disappears once the session is terminated. In that case, you might find some detail in the message log, but not much. If you are tracking a particular issue, then you may need to maintain your own 'log' my periodically extracting data using sysmaster or onstat. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list