table wise statistics

Posted in 2007

Summary

Nandkishor Singare, on Informix 9.4 AIX 5.3, asked how to get per-table statistics such as lock requests, sequential reads and writes rather than onstat -p totals. Art Kagel suggested onstat -g ppf and onstat -f iof; Jack Parker and Mouhamadou Dia pointed to the sysmaster sysptprof table. Nandkishor confirmed that was what he wanted. Solved.

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

Topics: Platform-Specific Issues

Nandkishor Singare — Tue, 31 Jul 2007 14:27:34 — source: IIUG Forums & Mailing Lists

Hi, Informix 9.4 on AIX 5.3 I want to get the statistics like lockrequests, sequential reads, writes for individual tables. onstat -p gives me overall statistics but How do get it for individualtables? Regards, Nandkishor

↪ replying to Nandkishor Singare

ART KAGEL, BLOOMBERG/ 731 LEXIN — Tue, 31 Jul 2007 14:31:32 — source: IIUG Forums & Mailing Lists

onstat -g ppf and onstat -f iof ----- Original Message ----- From: Nandkishor Singare <ids@iiug.org> At: 7/31 10:27:53 Hi, Informix 9.4 on AIX 5.3 I want to get the statistics like lockrequests, sequential reads, writes for individual tables. onstat -p gives me overall statistics but How do get it for individualtables? Regards, Nandkishor ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Nandkishor Singare

Jack Parker — Tue, 31 Jul 2007 14:36:51 — source: IIUG Forums & Mailing Lists

check out the sysmaster:sysptprof table. j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of Nandkishor Singare Sent: Tuesday, July 31, 2007 10:28 AM To: ids@iiug.org Subject: table wise statistics [9660] Hi, Informix 9.4 on AIX 5.3 I want to get the statistics like lockrequests, sequential reads, writes for individual tables. onstat -p gives me overall statistics but How do get it for individualtables? Regards, Nandkishor **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Nandkishor Singare

Mouhamadou Dia — Tue, 31 Jul 2007 14:43:27 — source: IIUG Forums & Mailing Lists

Look at sysptprof table from sysmaster database -----Message d'origine----- De : ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] De la part de Nandkishor Singare Envoyé : 31 juillet 2007 10:28 À : ids@iiug.org Objet : table wise statistics [9660] Hi, Informix 9.4 on AIX 5.3 I want to get the statistics like lockrequests, sequential reads, writes for individual tables. onstat -p gives me overall statistics but How do get it for individualtables? Regards, Nandkishor ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Jack Parker

Nandkishor Singare — Tue, 31 Jul 2007 14:45:14 — source: IIUG Forums & Mailing Lists

Thanks Jack and Dia. That's exactly what i wanted.... :) Regards Nandkishor On 7/31/07, Jack Parker <jack.parker4@verizon.net> wrote: > > check out the sysmaster:sysptprof table. > > j. > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of > Nandkishor Singare > Sent: Tuesday, July 31, 2007 10:28 AM > To: ids@iiug.org > Subject: table wise statistics [9660] > > Hi, > > Informix 9.4 on AIX 5.3 > > I want to get the statistics like lockrequests, sequential reads, writes > for > individual tables. > > onstat -p gives me overall statistics but How do get it for individual> tables? > > Regards, > Nandkishor > > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Related threads

Glossary

onstat