How to find the create date of a chunk ?

Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Thank you. --------------------------------- Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers!

It would not always be accurate but you could look at the list of tables within the chunk (using the oncheck -pe), find a newly created table within that chunk and look at thattable's creation date. All tables maintain their creation dates, but you have to work your way backwards ... Sadly, I do not know of a programmable way of determining this information, unless it is captured somewhere in sysmaster. Hope that helps. Clifton Mike Smith <idsquiz@yahoo.com> wrote: Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Thank you. --------------------------------- Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers!

Grep out the online log (if availible) for the date & the chunk added msg. On a HPUX 11i system I ran: cat online.log |grep -E '2004|Chunk' Which returns: Mon Jul 26 00:00:20 2004 Tue Jul 27 00:01:35 2004 11:21:21 Chunk '/informix/BWP/sapdata/physdev28/data55' added to space 'psapfac ta'. 12:44:51 Chunk '/informix/BWP/sapdata/physdev88/data176' added to space 'psapod s'. 12:46:44 Chunk '/informix/BWP/sapdata/physdev88/data175' added to space 'psapod s'. Wed Jul 28 00:00:16 2004 Thu Jul 29 00:02:23 2004 -Chris "Clifton M. Bean" <cmbean@sbcglobal.net> Sent by: forum.subscriber@iiug.org 08/10/2004 07:54 PM To ids@iiug.org cc Subject Re: How to find the create date of a chunk ? [3341] It would not always be accurate but you could look at the list of tables within the chunk (using the oncheck -pe), find a newly created table within that chunk and look at that table's creation date. All tables maintain their creation dates, but you have to work your way backwards ... Sadly, I do not know of a programmable way of determining this information, unless it is captured somewhere in sysmaster. Hope that helps. Clifton Mike Smith <idsquiz@yahoo.com> wrote: Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Thank you. --------------------------------- Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers!

Have you tried onmonitor? (mine doesn't work... I got a defect)... But might that tell you as you look at dbspaces and ctrl-b or something like that to get to the details and chunk info? -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of chris.staub.... Sent: Wednesday, August 11, 2004 9:17 AM To: ids@iiug.org Subject: Re: How to find the create date of a chunk ? [3344] Grep out the online log (if availible) for the date & the chunk added msg. On a HPUX 11i system I ran: cat online.log |grep -E '2004|Chunk' Which returns: Mon Jul 26 00:00:20 2004 Tue Jul 27 00:01:35 2004 11:21:21 Chunk '/informix/BWP/sapdata/physdev28/data55' added to space 'psapfac ta'. 12:44:51 Chunk '/informix/BWP/sapdata/physdev88/data176' added to space 'psapod s'. 12:46:44 Chunk '/informix/BWP/sapdata/physdev88/data175' added to space 'psapod s'. Wed Jul 28 00:00:16 2004 Thu Jul 29 00:02:23 2004 -Chris "Clifton M. Bean" <cmbean@sbcglobal.net> Sent by: forum.subscriber@iiug.org 08/10/2004 07:54 PM To ids@iiug.org cc Subject Re: How to find the create date of a chunk ? [3341] It would not always be accurate but you could look at the list of tables within the chunk (using the oncheck -pe), find a newly created table within that chunk and look at that table's creation date. All tables maintain their creation dates, but you have to work your way backwards .... Sadly, I do not know of a programmable way of determining this information, unless it is captured somewhere in sysmaster. Hope that helps. Clifton Mike Smith <idsquiz@yahoo.com> wrote: Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Thank you. --------------------------------- Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================