Oninit cdi / Archive
Talk to an expert →

getting space used by indexes

Posted in 2005

Topics: Storage & Space Management

Gita R Maramis — — source: IIUG Forums & Mailing Lists

I have a database with tables and indexes in one dbspace. Is there a way to find out how much space the indexes are taking?

↪ replying to Gita R Maramis
Anup Agrawal — — source: IIUG Forums & Mailing Lists

oncheck -pe | grep <index_name> --- Gita R Maramis <gmaramis@jcpenney.com> wrote: > I have a database with tables and indexes in one > dbspace. > > Is there a way to find out how much space the > indexes are taking? > > > __________________________________ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail

↪ replying to Anup Agrawal
Jack Parker — — source: IIUG Forums & Mailing Lists

> shameless plug < You can also run the entire oncheck -pe output through oncheck.awk which you can download from www.artentech.com/downloads.htm. That will summarize the information a little more clearly cheers j. ----- Original Message ----- From: "Anup Agrawal " <aanup@yahoo.com> To: <ids@iiug.org> Sent: Monday, August 08, 2005 6:26 PM Subject: Re: getting space used by indexes [5578] > oncheck -pe | grep <index_name>> > --- Gita R Maramis <gmaramis@jcpenney.com> wrote: > > > I have a database with tables and indexes in one > > dbspace. > > > > Is there a way to find out how much space the > > indexes are taking? > > > > > > > > > > > __________________________________ > Yahoo! Mail for Mobile > Take Yahoo! Mail with you! Check email on your mobile phone. > http://mobile.yahoo.com/learn/mail >

↪ replying to Jack Parker
Konikoff, Rob \\\\(Contractor\\\\) — — source: IIUG Forums & Mailing Lists

Jack: I just downloaded your awk for IDS7 oncheck... sweet. Rob -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Jack Parker Sent: Monday, August 08, 2005 9:39 PM To: ids@iiug.org Subject: Re: getting space used by indexes [5580] > shameless plug < You can also run the entire oncheck -pe output through oncheck.awk which you can download from www.artentech.com/downloads.htm. That will summarize the information a little more clearly cheers j. ----- Original Message ----- From: "Anup Agrawal " <aanup@yahoo.com> To: <ids@iiug.org> Sent: Monday, August 08, 2005 6:26 PM Subject: Re: getting space used by indexes [5578] > oncheck -pe | grep <index_name>> > --- Gita R Maramis <gmaramis@jcpenney.com> wrote: > > > I have a database with tables and indexes in one > > dbspace. > > > > Is there a way to find out how much space the > > indexes are taking? > > > > > > > > > > > __________________________________ > Yahoo! Mail for Mobile > Take Yahoo! Mail with you! Check email on your mobile phone. > http://mobile.yahoo.com/learn/mail >

↪ replying to Jack Parker
vze2qjg5@verizon.net — — source: IIUG Forums & Mailing Lists

Another satisfied customer. ;-) Although actually, with the IDS versions of the script, each different release has slightly differing formatting for the oncheck -pe output. If you get odd results, let me know and I'll patch it for your release. cheers j. >From: "Konikoff, Rob (Contractor)" <rob.konikoff@us.army.mil> >Date: Tue Aug 09 07:00:07 CDT 2005 >To: Jack Parker <vze2qjg5@verizon.net>, ids@iiug.org >Subject: RE: getting space used by indexes [5580] >Jack: > >I just downloaded your awk for IDS7 oncheck... sweet. > >Rob > >-----Original Message----- >From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On >Behalf Of Jack Parker >Sent: Monday, August 08, 2005 9:39 PM >To: ids@iiug.org >Subject: Re: getting space used by indexes [5580] > >> shameless plug < > >You can also run the entire oncheck -pe output through oncheck.awk which >you >can download from www.artentech.com/downloads.htm. That will summarize >the >information a little more clearly > >cheers >j. >----- Original Message ----- >From: "Anup Agrawal " <aanup@yahoo.com> >To: <ids@iiug.org> >Sent: Monday, August 08, 2005 6:26 PM >Subject: Re: getting space used by indexes [5578] > > >> oncheck -pe | grep <index_name>>> >> --- Gita R Maramis <gmaramis@jcpenney.com> wrote: >> >> > I have a database with tables and indexes in one >> > dbspace. >> > >> > Is there a way to find out how much space the >> > indexes are taking? >> > >> > >> > >> >> >> >> >> __________________________________ >> Yahoo! Mail for Mobile >> Take Yahoo! Mail with you! Check email on your mobile phone. >> http://mobile.yahoo.com/learn/mail >>

Glossary