Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
auditdb -internal_data
15 views
Skip to first unread message
Roy Hann
Apr 12, 2013, 4:47:20 AM4/12/13
to
From talking to Geraint Jones I have just found out about the auditdb
-internal_data flag. (Second day in a row I've learnt something new!)
It seems auditdb can choose that mode automatically too. Does anyone
know under what circumstances?
The DB was inconsistent but it was forced consistent before running
auditdb.
--
Roy
UK Actian User Association Conference 2013 will be on Tuesday June 11. 2013.
The latest information is available from www.uk-iua.org.uk.
-internal_data flag. (Second day in a row I've learnt something new!)
It seems auditdb can choose that mode automatically too. Does anyone
know under what circumstances?
The DB was inconsistent but it was forced consistent before running
auditdb.
--
Roy
UK Actian User Association Conference 2013 will be on Tuesday June 11. 2013.
The latest information is available from www.uk-iua.org.uk.
Paul Mason
Apr 12, 2013, 5:58:29 AM4/12/13
to Ingres and related product discussion forum
Hi Roy,
Had a quick look and I can't see it being turned on automatically.
-internal_data sets a flag JSX2_INTERNAL_DATA and AFAICS it's the only
thing that sets that flag. JSX2_INTERNAL_DATA triggers the output of
LSNs and tids basically and I also looked to see if that was output
under other circumstances but again can't see it.
Is it possible someone set an alias for auditdb that included the flag?
Regards
Paul
> _______________________________________________
> Info-Ingres mailing list
> Info-...@kettleriverconsulting.com
>
http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres
Had a quick look and I can't see it being turned on automatically.
-internal_data sets a flag JSX2_INTERNAL_DATA and AFAICS it's the only
thing that sets that flag. JSX2_INTERNAL_DATA triggers the output of
LSNs and tids basically and I also looked to see if that was output
under other circumstances but again can't see it.
Is it possible someone set an alias for auditdb that included the flag?
Regards
Paul
> Info-Ingres mailing list
> Info-...@kettleriverconsulting.com
>
http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres
Ingres Forums
Apr 12, 2013, 7:09:09 AM4/12/13
to
The -all flag displays LSNs too, as Marty's pointed out to me this
moring.
GJ
--
geraintjones
------------------------------------------------------------------------
geraintjones's Profile: http://community.actian.com/forum/member.php?userid=57763
View this thread: http://community.actian.com/forum/showthread.php?t=15154
Roy Hann
Apr 12, 2013, 7:21:20 AM4/12/13
to
Paul Mason wrote:
> Had a quick look and I can't see it being turned on automatically.
> -internal_data sets a flag JSX2_INTERNAL_DATA and AFAICS it's the only
> thing that sets that flag. JSX2_INTERNAL_DATA triggers the output of
> LSNs and tids basically and I also looked to see if that was output
> under other circumstances but again can't see it.
>
> Is it possible someone set an alias for auditdb that included the flag?
I'd be astonished. I'll try to find out though.
> Had a quick look and I can't see it being turned on automatically.
> -internal_data sets a flag JSX2_INTERNAL_DATA and AFAICS it's the only
> thing that sets that flag. JSX2_INTERNAL_DATA triggers the output of
> LSNs and tids basically and I also looked to see if that was output
> under other circumstances but again can't see it.
>
> Is it possible someone set an alias for auditdb that included the flag?
Paul Mason
Apr 12, 2013, 8:03:15 AM4/12/13
to Ingres and related product discussion forum
So it does.
So if you use -all you get the records in the format that rollforwarddb
-v uses (both call dmd_format_log), whereas auditdb -internal_data adds
an LSN stamp to the usual auditdb output.
Cheers
So if you use -all you get the records in the format that rollforwarddb
-v uses (both call dmd_format_log), whereas auditdb -internal_data adds
an LSN stamp to the usual auditdb output.
Cheers
0 new messages