DB Monitoring

Hi, What is the best way to monitor the forground and background processing of an application in informix...? Example: I have an application which undergoes for a performance testing, the tester wants to know how to monitor each and every transactions, execution time, etc. Thanks

Hi, The first thing you have to know the session id of the connectio tester... After that you can use the commands to see db activities and sql statements running: Use 'grep' if the OS is Unix or Linux , use 'findstr' if the OS is windows onstat -u | grep <session id> (regard the last 2 columns that has the pagesread and pages written "nreads nwrites")(or use the first column to filter - the 'address' column) onstat -g sql <session id> onstat -g ses <session id> onstat -x (transactions) Best regards R Ferronato > To: ids@iiug.org> From: krishnanbalasubramanian@rediffmail.com> Subject: DB Monitoring [14444]> Date: Tue, 6 Jan 2009 04:10:45 -0500> > Hi, > > What is the best way to monitor the forground and background processing of an > application in informix...? > > Example: I have an application which undergoes for a performance testing, the > tester wants to know how to monitor each and every transactions, execution > time, etc. > > Thanks > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

Thanks for your response, If i wanted to download some data from source and my programis updating that into a database, how can i see the time taken for this, memroy utilized for this, Etc..? I wanted to idenitfy at this level. Thanks

There is not information about the duration 'time' taken in monitoring. You could as for your programmer insert the following statement inside the application before and after the statement to get the time as beggining and at end of statement: select current from systables where tabname = 'systables' If in ONCONFIG file the paramenter USEOSTIME is set to 0 you have not a fraction of seconds. If you want a fraction of seconds in the "current time", change this parameter to 1, restart the IDS. Regards R Ferronato > To: ids@iiug.org> From: krishnanbalasubramanian@rediffmail.com> Subject: Re: RE: DB Monitoring [14451]> Date: Tue, 6 Jan 2009 07:30:00 -0500> > Thanks for your response, > > If i wanted to download some data from source and my programis updating that > into a database, how can i see the time taken for this, memroy utilized for > this, Etc..? > > I wanted to idenitfy at this level. > > Thanks > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx

Krishnan, Take a look at iWatch SQL from Exact Solutions (www.exact-solutions.com) can record and report on all client-server activity between clients and IDS servers (except for shared memory connections) and unlike other solutions includes a detailed time breakdown of each transaction step including sub-steps like query parsing/optimization versus data fetch time. Exact Solutions also has another product, iReplay, that works with iWatch SQL to allow you to consistently replay a set of queries, including timing and pacing, so you can also test how server tuning affects application performance. The Informix specific version of iReplay should be available very soon. Exact Solutions has innovative licensing arrangements available to cover one-time, short-term, and permanent requirements. Oninit (www.oninit.com) is an Exact Solutions partner. If we can help, or if you just have questions, please contact us. Art On Tue, Jan 6, 2009 at 4:10 AM, KRISHNAN BALASUBRAMANIAN < krishnanbalasubramanian@rediffmail.com> wrote: > Hi, > > What is the best way to monitor the forground and background processing of > an > application in informix...? > > Example: I have an application which undergoes for a performance testing, > the > tester wants to know how to monitor each and every transactions, execution > time, etc. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel (art@oninit.com) Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Responses like this are why I do NOT like the current trend to not quote the posting to which you are replying. Many of us use email clients to monitor the lists and we do not keep history so there is no way to thread the replies. PLEASE quote at least enough of the post you are replying to so everyone else, including the poster, know to which post you are replying! Common courtesy. Art On Tue, Jan 6, 2009 at 7:30 AM, KRISHNAN BALASUBRAMANIAN < krishnanbalasubramanian@rediffmail.com> wrote: > Thanks for your response, > > If i wanted to download some data from source and my programis updating > that > into a database, how can i see the time taken for this, memroy utilized for > this, Etc..? > > I wanted to idenitfy at this level. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Version and platform? If you're on IDS 11.10 or later, then you might consider SQL Tracing. Or you might consider the audit facility to audit only those events you care about (begin and end transaction events). I suspect SQL Tracing will alter the test too much, but auditing a small number of events will probably not change things significantly. If you can wait until the test finishes, you might use onlog to find the begin work and commit/rollback records after the test is finished. You might consider SQLIDEBUG/sqliprint, but then you'll have quite a chore to parse out what you want, and that generates a very large file very quickly. During the test, onstat -p or a query on sysmaster:sysprofile will let you watch the number of commits and rollbacks. onstat -pr 10 is what I use to gauge the rate of progress of a performance test. That lets me watch the transaction rate, the latch, lock and buffer waits, and other things all at once. When the test is over, I capture data from sysmaster:sysptprof to ensure the right number of actions were done on each table. Cheers, Dick Snoke IBM Data Management - ChannelWorks dsnoke@us.ibm.com (404) 487-1595 From: "KRISHNAN BALASUBRAMANIAN" <krishnanbalasubramanian@rediffmail.com> To: ids@iiug.org Date: 01/06/2009 04:12 AM Subject: DB Monitoring [14444] Hi, What is the best way to monitor the forground and background processing of an application in informix...? Example: I have an application which undergoes for a performance testing, the tester wants to know how to monitor each and every transactions, execution time, etc. Thanks ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

If you are using version 11 and OAT (OpenAdmin Tool for IDS) the Query Drill down section (under the performance menu) will list all the recent transaction. For each transaction you can view the SQL statements which are part of the transaction. The statistics and resources are shown both aggregated for the transaction and individual by statement. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) = "KRISHNAN = BALASUBRAMANIAN" = <krishnanbalasubr = To amanian@rediffmai ids@iiug.org = l.com> = cc Sent by: = ids-bounces@iiug. Subj= ect org DB Monitoring [14444] = = = 01/06/2009 01:10 = AM = = = Please respond to = ids@iiug.org = = = Hi, What is the best way to monitor the forground and background processing= of an application in informix...? Example: I have an application which undergoes for a performance testin= g, the tester wants to know how to monitor each and every transactions, execut= ion time, etc. Thanks ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Hi Art, When i click Post Response it is coming with empty editor and we are giving our responses in that. Is there any option available to choose to include all the previous responses on each subject..? if so pl. let us know. I would like to thank all the people who responded to my queries. I am not in a position to go for any tool, need the existing 11.50 IDS to get all the informations about each transaction and its details. Basically we are doing preformance test so the info of time taken on downloading a data from one source to informix database, how much of buffer it takes, how many read and how many write and how many lock has been created, etc are required for me. Thanks

If you want the existing 11.50 to do that then turn on SQLTRACE in the onconfig and run onstat -g his or select from the sysmaster database the table called syssqltrace. This will have all the data you have requested. See the following link= to the documentation http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=3D= /com.ibm.adref.doc/ids_adr_0535.htm John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) = "KRISHNAN = BALASUBRAMANIAN" = <krishnanbalasubr = To amanian@rediffmai ids@iiug.org = l.com> = cc Sent by: = ids-bounces@iiug. Subj= ect org Re: RE: DB Monitoring [14466] = = = 01/06/2009 08:35 = PM = = = Please respond to = ids@iiug.org = = = Hi Art, When i click Post Response it is coming with empty editor and we are gi= ving our responses in that. Is there any option available to choose to inclu= de all the previous responses on each subject..? if so pl. let us know. I would like to thank all the people who responded to my queries. I am not in a position to go for any tool, need the existing 11.50 IDS = to get all the informations about each transaction and its details. Basica= lly we are doing preformance test so the info of time taken on downloading a d= ata from one source to informix database, how much of buffer it takes, how = many read and how many write and how many lock has been created, etc are required for me. Thanks ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Don't know what tool you are using for posting, but if it's a mailer like Thunderbird or Outlook go to Options and in there somewhere is a check off something like "Quote original message". Enable that and select whether to begin your reply above or below the quoted text. Most of what you want can be gotten from 11.50's sysmaster database while the session is still alive, and as John Miller pointed out, from the history option you can enable from within OAT after the fact. The only thing you will need a tool like iWatch SQL for (or alternatively to make changes to your application code to record it there) is the timings. Nothing else that I know of keeps track of the runtimes of transactions or their parts, that's why we are partnered with them. Note that AGS's Sentinel, which is delivered with IDS, can also record your running SQL along with some statistics, but again no timings. AGS's Server Studio's basic functionality is delivered with IDS with a free permanent license, and the advanced features as well as Sentinel come with a trial license (IB it's 60 days) that you can use if this is a short term test. AGS Server Studio and Sentinel are very powerful tools to monitor and manage your servers and Oninit is proud to partner with AGS as well. Art On Tue, Jan 6, 2009 at 11:35 PM, KRISHNAN BALASUBRAMANIAN < krishnanbalasubramanian@rediffmail.com> wrote: > Hi Art, > > When i click Post Response it is coming with empty editor and we are giving > our responses in that. Is there any option available to choose to include > all > the previous responses on each subject..? if so pl. let us know. > > I would like to thank all the people who responded to my queries. > > I am not in a position to go for any tool, need the existing 11.50 IDS to > > get all the informations about each transaction and its details. Basically > we > are doing preformance test so the info of time taken on downloading a data > from one source to informix database, how much of buffer it takes, how many > read and how many write and how many lock has been created, etc are > required > for me. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.