When table was dropped?
I want to know the time when a table was dropped. This will help to restore point of time. online.log file doesn't store table level information. Where can i look for this information? Thanks DJ...
It won't appear in the message log. You have to look in the logical logs
on disk. Use the onlog utility, its documented in the Adminstrator's
Reference manual. Note that using onlog on the current log will lock out
transactions. Switch the engine to the next log with onmode -l before
looking at the last log file.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. 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, Nov 17, 2009 at 7:33 AM, DHANANJAY KUMAR <
dhananjay_kumar2k@yahoo.com> wrote:
> I want to know the time when a table was dropped. This will help to restore
> point of time.
>
> online.log file doesn't store table level information. Where can i look for
> this information?
>
> Thanks
> DJ...
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0015174c0f0266f40a0478927ed2
If you are using point in time table level restore to recover a
dropped table then you do not need to find the exact time.
PIT Table Level Restore is assumes that if you have
asked to restore a table you do not wish to replay the
drop of the table.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 11/17/2009 07:08:11 AM:
> [image removed]
>
> Re: When table was dropped? [18134]
>
> Art Kagel
>
> to:
>
> ids
>
> 11/17/2009 07:09 AM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> It won't appear in the message log. You have to look in the logical logs
> on disk. Use the onlog utility, its documented in the Adminstrator's
> Reference manual. Note that using onlog on the current log will lock out
> transactions. Switch the engine to the next log with onmode -l before
> looking at the last log file.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
and
> do not reflect on my employer, Oninit, the IIUG, nor any other
organization
> with which I am associated either explicitly or implicitly. 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, Nov 17, 2009 at 7:33 AM, DHANANJAY KUMAR <
> dhananjay_kumar2k@yahoo.com> wrote:
>
> > I want to know the time when a table was dropped. This will help to
restore
> > point of time.
> >
> > online.log file doesn't store table level information. Where can ilook
for
> > this information?
> >
> > Thanks
> > DJ...
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --0015174c0f0266f40a0478927ed2
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>