Last parsed SQL statement

Posted in 1999

Summary

Paul Howard asked how to get the Last parsed SQL statement shown by onstat -g sql from the sysmaster database. Christian Brauer suggested syssqlstat; another poster guessed syssessions, and Christian reaffirmed syssqlstat and asked for documentation of the system tables. Red Valsen pointed to Lester Knutsen's sysmaster article and the sysmaster.sql file in INFORMIXDIR/etc.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Howard, Paul — Tue, 9 Nov 1999 11:30:38 -0500 — source: Informix-list mailing list archive (1991-1998)

When onstat -g sql <sessionid> is executed is gives the Last parsed SQL statement. Is there anyway of querying the sysmaster database to get this statement?

↪ replying to Howard, Paul

Christian Brauer — Tue, 09 Nov 1999 18:37:06 +0100 — source: Informix-list mailing list archive (1991-1998)

> > When onstat -g sql <sessionid> is executed is gives the Last parsed > SQL statement. Is there anyway of querying the sysmaster database to get > this statement? Hi Paul, what about querying sysmaster:informix.syssqlstat using your session id ? Hth, Chris

↪ replying to Howard, Paul

mars1972@my-deja.com — Tue, 09 Nov 1999 18:43:56 GMT — source: Informix-list mailing list archive (1991-1998)

In article <809j4f$11b$1@news.xmission.com>, "Howard, Paul" <PaulHow@medcmp.com> wrote: > > When onstat -g sql <sessionid> is executed is gives the Last parsed > SQL statement. Is there anyway of querying the sysmaster database to get > this statement? > I don't have an online engine to test this with, but I believe it's stored in the syssessions table. -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to mars1972@my-deja.com

Christian Brauer — Wed, 10 Nov 1999 09:34:54 +0100 — source: Informix-list mailing list archive (1991-1998)

> I don't have an online engine to test this with, but I believe it's > stored in the syssessions table. I think it IS informix.syssqlstat ! Anyway, does anyone has a detailed description of ALL system tables and their meanings ? I didn't find complete information in the online documentation, so I figured out most of it for myself. If there is no useful documentation, does anyone know a website with some useful information about that topic ? Chris

↪ replying to Christian Brauer

Red Valsen — Wed, 10 Nov 1999 08:29:46 -0500 — source: Informix-list mailing list archive (1991-1998)

See Lester Knutsen's article on sysmaster: http://www.advancedatatools.com/articles.htm Also, examine file $INFORMIXDIR/etc/sysmaster.sql. Christian Brauer wrote: > > I don't have an online engine to test this with, but I believe it's > > stored in the syssessions table. > > I think it IS informix.syssqlstat ! > > Anyway, does anyone has a detailed description of ALL system tables > and their meanings ? I didn't find complete information in the online > documentation, so I figured out most of it for myself. > > If there is no useful documentation, does anyone know a website with > some useful information about that topic ? > > Chris

Related threads

Glossary

onstat