RE: SQL Tracing tools?

Colin, You said sqlidebug and sqliprint are "internal tools". Would that be internal as in onstat used to be 'internal'/undocumented feature.... Or are they "internal tools" as in you have to get them from IBM? Thanks, Norma Jean -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Colin Bull Sent: Thursday, November 18, 2004 10:34 AM To: informix-list@iiug.org Subject: RE: SQL Tracing tools? Abdullah Kauchali said > What do informix users use to profile (log) SQL statements hitting the > database server? (In MS lala-land, we have the almighty Profiler > Tool. > Works well.) > There is the SQLIDEBUG and sqliprint which are internal tools that can be used. They eat up a lot of disk if left on for a long time. We are having a demo of SQL Power Tools next week which seems very slick, but with a very expensive price tag. www.sqlpower.com Colin BUll _______________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. _______________________________________________________________________ sending to informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================ sending to informix-list

Sebastian, Norma J. wrote: > > You said sqlidebug and sqliprint are "internal tools". > Would that be internal as in onstat used to be 'internal'/undocumented > feature.... > Or are they "internal tools" as in you have to get them from IBM? > I've checked the SQL syntax and reference manuals, the performance guide, the admin guide and admin reference - and found nothing. A Google search, however, turned up quite a bit. The following links should give you a pretty good idea of what to do. http://tinyurl.com/4y8st (Jonathan Leffler, Dec 1999) http://tinyurl.com/5zdr7 (Superboer, Sept 2004) HTH > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of Colin Bull > Sent: Thursday, November 18, 2004 10:34 AM > To: informix-list@iiug.org > Subject: RE: SQL Tracing tools? > > > Abdullah Kauchali said > > > What do informix users use to profile (log) SQL statements hitting the > > > database server? (In MS lala-land, we have the almighty Profiler > > Tool. > > Works well.) > > > There is the SQLIDEBUG and sqliprint which are internal tools that can > be used. > They eat up a lot of disk if left on for a long time. > > We are having a demo of SQL Power Tools next week which seems very > slick, but with a very expensive price tag. www.sqlpower.com -- June Hunt

Here's the usage file from the NT version of sqliprt.exe. I find the most simple and generally useful option is the -min option. YMMV Usage: sqliprt [-tuple] [-blob] [-min] [-cmd_time] [-nocsc] [-summary] [-stmt_stat [-order_cnt] [-per_thread] [-nogroup]] [-notimestamp] [-platform type] [-o outfile] [-V] inpfile -tuple : hex value of TUPLES in PUT and FETCH -blob : hex value of BLOBS in PUT and FETCH -min : only print the most minimum information -udt : print hex value of Fix/Var Binary -cmd_time : print timing info for each command -nocsc : turn off codeset convertion -summary : print summary information at the end -stmt_stat : print statement statistics grouped by SQL -order_cnt : order statement stats by count (default: time) -per_thread : stmt stats per thread -nogroup : do not group stmt stats by SQL text -notimestamp: don't print the timestamp -platform type: type can be either IEEEI, IEEEM or DECALPHA print the timestamp by the specific platform format in sqlidebug file. This is only useful when you are using the sqlidebug file from different platforms. The following are the three supported timestamp types: IEEEM, IEEEI or DECALPHA. -isprint : only print printable characters(Data) -o outfile : generate the output to outfile -V : print version inpfile : sqlidebug file "June C. Hunt" <june.c.hunt@gmail.com> wrote in message news:304c4rF2s2ii7U1@uni-berlin.de... > Sebastian, Norma J. wrote: >> >> You said sqlidebug and sqliprint are "internal tools". >> Would that be internal as in onstat used to be 'internal'/undocumented >> feature.... >> Or are they "internal tools" as in you have to get them from IBM? >> > > I've checked the SQL syntax and reference manuals, the performance guide, > the admin guide and admin reference - and found nothing. A Google search, > however, turned up quite a bit. The following links should give you a > pretty good idea of what to do. > > http://tinyurl.com/4y8st (Jonathan Leffler, Dec 1999) > > http://tinyurl.com/5zdr7 (Superboer, Sept 2004) > > HTH > > >> -----Original Message----- >> From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] >> On Behalf Of Colin Bull >> Sent: Thursday, November 18, 2004 10:34 AM >> To: informix-list@iiug.org >> Subject: RE: SQL Tracing tools? >> >> >> Abdullah Kauchali said >> >> > What do informix users use to profile (log) SQL statements hitting the >> >> > database server? (In MS lala-land, we have the almighty Profiler >> > Tool. >> > Works well.) >> > >> There is the SQLIDEBUG and sqliprint which are internal tools that can >> be used. >> They eat up a lot of disk if left on for a long time. >> >> We are having a demo of SQL Power Tools next week which seems very >> slick, but with a very expensive price tag. www.sqlpower.com > > -- > June Hunt > > ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =---