Monitoring chunks added over time

Hello, I am using IDS 11.50.FC7 on aix 5.3 and wondering is there a way to look at the history of how many chunks have been added to an instance over a period of time? 1 week, 3 months, 6 months, or even a year. I looked in syschunks and didn't see a date column so is there somewhere else to look?

The only history would be in the logical logs. You would have to scan through them. 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 Tue, Mar 6, 2012 at 10:53 AM, Michael Wiggins < michaelwiggins30@comcast.net> wrote: > Hello, > > I am using IDS 11.50.FC7 on aix 5.3 and wondering is there a way to look > at the history of how many chunks have been added to an instance over a > period of time? 1 week, 3 months, 6 months, or even a year. I looked > in syschunks and didn't see a date column so is there somewhere else to > look? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f838a5569fcc204ba96a166

Hi guys! I changed the SERVERNUM parameter and i started the third instance!! Thanks a lot !! Regards, Alberto. -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de Art Kagel Enviada em: terça-feira, 6 de março de 2012 14:47 Para: ids@iiug.org Assunto: Re: Monitoring chunks added over time [26456] The only history would be in the logical logs. You would have to scan through them. 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 Tue, Mar 6, 2012 at 10:53 AM, Michael Wiggins < michaelwiggins30@comcast.net> wrote: > Hello, > > I am using IDS 11.50.FC7 on aix 5.3 and wondering is there a way to look > at the history of how many chunks have been added to an instance over a > period of time? 1 week, 3 months, 6 months, or even a year. I looked > in syschunks and didn't see a date column so is there somewhere else to > look? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f838a5569fcc204ba96a166 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

if you didn't prune you message log in the last 6 months or year or whatever (or you save copies off before pruning) then there should be a entry posted similar to : 13:57:20 Chunk '/dev/rlvinformix' added to space 'atsixdbs'. Mark

oncheck -pe will show the date the chunk was added.The information is probably in the sysmaster tables. DBspace Usage Report: rootdbs Owner: informix Created: 07/01/2005 Chunk Pathname Pagesize(k) Size(p) Used(p) Free( p) 1 /az/inst/test1000/dbs/rootdbs 4 131072 79085 519 87 Description Offset(p) Size(p ) ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 12 CHUNK FREELIST PAGE 12 1 rootdbs:'informix'.TBLSpace 13 250