Oninit cdi / Archive
Talk to an expert →

Non related emails

Posted in 2012

Topics: High Availability & Replication, Stored Procedures & SPL, Server Administration, Platform-Specific Issues

Anil Soni — — source: IIUG Forums & Mailing Lists

Good Morning ! Its been while, I am receving these massages, in one day about 30 massa= ges. I have no idea, what is these emails talk about, and I don't think the= se are related to me at all, If they are, please explain me how so. If not than, Please kindly take my email address out off your recipiant= (directory) list. If you have any issue regarding to above issue, Please let me know. Thank you Anil Soni SO Delivery, Security & Risk Mgm IBM Global Business ID Administration asoni@us.ibm.com From: "Jack Parker" <jack.parker4@verizon.net> To: ids@iiug.org, Date: 10/11/2012 10:22 AM Subject: Re: table size [28482] Sent by: ids-bounces@iiug.org Sorry, my mailer puts that in as an added bonus. It seems to feel that an "=3D3D" sign is too one dimensional and wants to turn it into 3D. So remove the 3D wherever you see it after an equal sign. Wonder if I can escape it: "=3D3D" \\\\=3D3D "\\\\=3D3D" =3D3D j. On Oct 11, 2012, at 10:06 AM, Peter_Logan@spartanstores.com wrote: > Not understanding some of the syntax .. what is up with the '3' ?=3D2= 0 >=3D20 > Peter Logan=3D20 > Senior Database Administrator=3D20 > Phone: 616/878-8309=3D20 >=3D20 > From: "Jack Parker" <jack.parker4@verizon.net>=3D20 > To: ids@iiug.org,=3D20 > Date: 10/11/2012 09:45 AM=3D20 > Subject: Re: table size [28480]=3D20 > Sent by: ids-bounces@iiug.org=3D20 >=3D20 > -- Reports size in MB=3D20 > CREATE FUNCTION tabsize(tabname char(128)) RETURNING integer;=3D20>=3D20 > DEFINE p_size INTEGER;=3D20 >=3D20 > -- Fragmented tables have partnum in sysfragments=3D20 > SELECT SUM(a.npused * a.pagesize)/(1024*1024)=3D20 > INTO p_size=3D20 > FROM sysmaster:sysptnhdr a, sysfragments b, systables c=3D20 > WHERE c.tabname=3D3D3Dtabname=3D20 >=3D20 > AND b.tabid=3D3D3Dc.tabid=3D20 >=3D20 > AND b.partn=3D3D3Da.partnum=3D20 >=3D20 > AND c.partnum=3D3D3D0;=3D20 >=3D20 > -- Non-fragmented tables have partnum in systables=3D20 > IF p_size IS NULL THEN=3D20 > SELECT SUM(a.npused * a.pagesize)/(1024*1024)=3D20 > INTO p_size=3D20 > FROM sysmaster:sysptnhdr a, systables c=3D20 > WHERE c.tabname=3D3D3Dtabname=3D20 >=3D20 > AND c.partnum=3D3D3Da.partnum;=3D20 > END IF;=3D20 >=3D20 > RETURN p_size;=3D20 >=3D20 > END FUNCTION;=3D20 >=3D20 > -- Report size of an index=3D20 > CREATE FUNCTION idxsize(idxname char(128)) RETURNING integer;=3D20>=3D20 > DEFINE p_size INTEGER;=3D20 >=3D20 > SELECT SUM(a.npused * a.pagesize)/(1024*1024)=3D20 > INTO p_size=3D20 > FROM sysmaster:sysptnhdr a, sysfragments b=3D20 > WHERE indexname=3D3D3Didxname=3D20 >=3D20 > AND b.partn=3D3D3Da.partnum;=3D20 >=3D20 > RETURN p_size;=3D20 >=3D20 > END FUNCTION;=3D20 >=3D20 > On Oct 11, 2012, at 9:32 AM, Peter_Logan@spartanstores.com wrote:=3D2= 0 >=3D20 >> Aix 6.1=3D3D20=3D20 >> IDS 11.70.fc3=3D3D20=3D20 >> =3D3D20=3D20 >> Before I develop a query ... wondering if anyone already has this=3D= 20 > ....=3D3D20=3D3D=3D20 >=3D20 >> =3D3D20=3D20 >> Looking for a query that will calculate the amount of space which a = =3D3D=3D =3D20 > table=3D3D20=3D20 >> is actually using ... not the allocated space, but what is being=3D2= 0 > used.=3D3D20=3D3D=3D20 >=3D20 >> Needs to take into consideration different page sizes ... =3D3D=3D20= > fragmentation ..=3D3D20=3D20 >> etc. Also like to see it with indexes excluded and included ..=3D3D2= 0=3D20=3D >> =3D3D20=3D20 >> If anyone has such a query .. please let me know .. Thanks ...=3D3D2= 0=3D20=3D >> =3D3D20=3D20 >> Peter Logan=3D3D20=3D20 >> Senior Database Administrator=3D3D20=3D20 >> Phone: 616/878-8309=3D3D20=3D20 >> =3D3D20=3D20 >> =3D3D20=3D20 >> =3D3D=3D20 > =3D ***********************************************************************= ***=3D =3D3D=3D20 >=3D20 > *****=3D3D20=3D20 >> Forum Note: Use "Reply" to post a response in the discussion =3D forum.=3D3D20=3D3D=3D20 >=3D20 >> =3D3D20=3D20 >=3D20 >=3D20 > =3D ***********************************************************************= ***=3D *****=3D20 >=3D20 > Forum Note: Use "Reply" to post a response in the discussion forum.=3D= 20 >=3D20 >=3D20 > =3D ***********************************************************************= ***=3D *****=3D20 > Forum Note: Use "Reply" to post a response in the discussion forum.=3D= 20=3D >=3D20 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to Anil Soni
Art Kagel — — source: IIUG Forums & Mailing Lists

Anil, You seem to be subscribed to one of the International Informix Users Group's (IIUG) forums. I am on the IIUG Board and will try to get you removed. If you like you can try to unsubscribe yourself. Go to www.iiug.org, login to the member's pages with your email address that is receiving these messages, and then go to the forums pages and uncheck all of the forums. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 11, 2012 at 11:20 AM, Anil Soni <asoni@us.ibm.com> wrote: > Good Morning ! > > Its been while, I am receving these massages, in one day about 30 massa= > ges. > I have no idea, what is these emails talk about, and I don't think the= > se > are related to me at all, If they are, please explain me how so. > If not than, Please kindly take my email address out off your recipiant= > > (directory) list. > > If you have any issue regarding to above issue, Please let me know. > > Thank you > Anil Soni > SO Delivery, Security & Risk Mgm > IBM Global Business > ID Administration > asoni@us.ibm.com > > From: "Jack Parker" <jack.parker4@verizon.net> > To: ids@iiug.org, > Date: 10/11/2012 10:22 AM > Subject: Re: table size [28482] > Sent by: ids-bounces@iiug.org > > Sorry, my mailer puts that in as an added bonus. It seems to feel that > an "=3D3D" sign is too one dimensional and wants to turn it into 3D. > > So remove the 3D wherever you see it after an equal sign. > > Wonder if I can escape it: > "=3D3D" > \\\\=3D3D > "\\\\=3D3D" > =3D3D > > j. > > On Oct 11, 2012, at 10:06 AM, Peter_Logan@spartanstores.com wrote: > > > Not understanding some of the syntax .. what is up with the '3' ?=3D2= > 0 > >=3D20 > > Peter Logan=3D20 > > Senior Database Administrator=3D20 > > Phone: 616/878-8309=3D20 > >=3D20 > > From: "Jack Parker" <jack.parker4@verizon.net>=3D20 > > To: ids@iiug.org,=3D20 > > Date: 10/11/2012 09:45 AM=3D20 > > Subject: Re: table size [28480]=3D20 > > Sent by: ids-bounces@iiug.org=3D20 > >=3D20 > > -- Reports size in MB=3D20 > > CREATE FUNCTION tabsize(tabname char(128)) RETURNING integer;=3D20> >=3D20 > > DEFINE p_size INTEGER;=3D20 > >=3D20 > > -- Fragmented tables have partnum in sysfragments=3D20 > > SELECT SUM(a.npused * a.pagesize)/(1024*1024)=3D20 > > INTO p_size=3D20 > > FROM sysmaster:sysptnhdr a, sysfragments b, systables c=3D20 > > WHERE c.tabname=3D3D3Dtabname=3D20 > >=3D20 > > AND b.tabid=3D3D3Dc.tabid=3D20 > >=3D20 > > AND b.partn=3D3D3Da.partnum=3D20 > >=3D20 > > AND c.partnum=3D3D3D0;=3D20 > >=3D20 > > -- Non-fragmented tables have partnum in systables=3D20 > > IF p_size IS NULL THEN=3D20 > > SELECT SUM(a.npused * a.pagesize)/(1024*1024)=3D20 > > INTO p_size=3D20 > > FROM sysmaster:sysptnhdr a, systables c=3D20 > > WHERE c.tabname=3D3D3Dtabname=3D20 > >=3D20 > > AND c.partnum=3D3D3Da.partnum;=3D20 > > END IF;=3D20 > >=3D20 > > RETURN p_size;=3D20 > >=3D20 > > END FUNCTION;=3D20 > >=3D20 > > -- Report size of an index=3D20 > > CREATE FUNCTION idxsize(idxname char(128)) RETURNING integer;=3D20> >=3D20 > > DEFINE p_size INTEGER;=3D20 > >=3D20 > > SELECT SUM(a.npused * a.pagesize)/(1024*1024)=3D20 > > INTO p_size=3D20 > > FROM sysmaster:sysptnhdr a, sysfragments b=3D20 > > WHERE indexname=3D3D3Didxname=3D20 > >=3D20 > > AND b.partn=3D3D3Da.partnum;=3D20 > >=3D20 > > RETURN p_size;=3D20 > >=3D20 > > END FUNCTION;=3D20 > >=3D20 > > On Oct 11, 2012, at 9:32 AM, Peter_Logan@spartanstores.com wrote:=3D2= > 0 > >=3D20 > >> Aix 6.1=3D3D20=3D20 > >> IDS 11.70.fc3=3D3D20=3D20 > >> =3D3D20=3D20 > >> Before I develop a query ... wondering if anyone already has this=3D= > 20 > > ....=3D3D20=3D3D=3D20 > >=3D20 > >> =3D3D20=3D20 > >> Looking for a query that will calculate the amount of space which a = > =3D3D=3D > > =3D20 > > table=3D3D20=3D20 > >> is actually using ... not the allocated space, but what is being=3D2= > 0 > > used.=3D3D20=3D3D=3D20 > >=3D20 > >> Needs to take into consideration different page sizes ... =3D3D=3D20= > > > fragmentation ..=3D3D20=3D20 > >> etc. Also like to see it with indexes excluded and included ..=3D3D2= > 0=3D20=3D > > >> =3D3D20=3D20 > >> If anyone has such a query .. please let me know .. Thanks ...=3D3D2= > 0=3D20=3D > > >> =3D3D20=3D20 > >> Peter Logan=3D3D20=3D20 > >> Senior Database Administrator=3D3D20=3D20 > >> Phone: 616/878-8309=3D3D20=3D20 > >> =3D3D20=3D20 > >> =3D3D20=3D20 > >> =3D3D=3D20 > > =3D > ***********************************************************************= > ***=3D > > =3D3D=3D20 > >=3D20 > > *****=3D3D20=3D20 > >> Forum Note: Use "Reply" to post a response in the discussion =3D > forum.=3D3D20=3D3D=3D20 > >=3D20 > >> =3D3D20=3D20 > >=3D20 > >=3D20 > > =3D > ***********************************************************************= > ***=3D > > *****=3D20 > >=3D20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=3D= > 20 > >=3D20 > >=3D20 > > =3D > ***********************************************************************= > ***=3D > > *****=3D20 > > Forum Note: Use "Reply" to post a response in the discussion forum.=3D= > 20=3D > > >=3D20 > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba614c8086973e04cbca4d55

Glossary