Oninit cdi / Archive
Talk to an expert →

table wise statistics

Posted in 2007

Topics: Platform-Specific Issues

Nandkishor Singare — — 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 — — 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 — — 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 — — 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 — — 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