How to capture the lock wait or dead lock info

Posted in 2011

CHUAN LU — Mon, 07 Mar 2011 03:06:19 — source: IIUG Forums & Mailing Lists

Hi, Do anybody know how to keep the lock wait or dead lock information 9into a file or table? thanks.

↪ replying to CHUAN LU

Art Kagel — Mon, 07 Mar 2011 03:15:59 — source: IIUG Forums & Mailing Lists

You can use AGS Sentinel with AGS Server Studio. You get a free basic Server Studio license with Informix and you can have a 30day trial of full Server Studio Enterprise Edition and Sentinel licenses just for the asking. If you like it, you can purchase a permanent license. It is not expensive. Check out www.serverstudio.com Sentinel lets you set sensors for most performance numbers of the server and saves the data into its own repository (either a built-in repository or you can reconfigure it to use a small Informix instance instead). Server Studio will then allow you to create a dashboard of graphs to display the data live or historically. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Mar 6, 2011 at 10:06 PM, CHUAN LU <luchuan114@sina.com> wrote: > Hi, > Do anybody know how to keep the lock wait or dead lock information 9into a > file or table? thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf303a2c0f855442049ddbe925

↪ replying to CHUAN LU

John Miller — Tue, 08 Mar 2011 00:32:40 — source: IIUG Forums & Mailing Lists

You can use the SQLTRACE facility and enable the task called "Save SQL Trace". This will save the traced sql statements into a table. You can add to the insert statements a where clause to limit the scope to only save statements with lock waits or lock errors. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 03/06/2011 07:06:19 PM: > [image removed] > > How to capture the lock wait or dead lock info [22986] > > CHUAN LU > > to: > > ids > > 03/06/2011 07:07 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hi, > Do anybody know how to keep the lock wait or dead lock information 9into a > file or table? thanks. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >