interpreting log files

i'm not sure if this is the right forum for this thread, but i was curious
if anyone knew of a utility that allows an end user to interpret a log file.

obviously right now we can have our users send us their log file and we can
convert it to SQL and then search for a particular date/SQL command.
basically, does anyone know of a utility with a user interface that would
allow someone who is not too database savvy to do this on their own?


0
Douglas
1/21/2005 8:04:47 PM
sybase.sqlanywhere.general 32637 articles. 22 followers. Follow

4 Replies
310 Views

Similar Articles

[PageSpeed] 41
Get it on Google Play
Get it on Apple App Store

You could write you own GUI for this (if you are up to writting C code to
access our dbtools API) but dbtran is it.

Is there a specific business need to see the contents of a log other than
for recovery when there is a file system failure?  [if not dbtran suffices
for most of the needs we are aware of]

"Douglas M. Deram" <dougderam@yeahright.com> wrote in message 
news:41f16059$1@forums-2-dub...
> i'm not sure if this is the right forum for this thread, but i was curious
> if anyone knew of a utility that allows an end user to interpret a log 
> file.
>
> obviously right now we can have our users send us their log file and we 
> can
> convert it to SQL and then search for a particular date/SQL command.
> basically, does anyone know of a utility with a user interface that would
> allow someone who is not too database savvy to do this on their own?
>
> 


0
Nick
1/24/2005 2:48:21 AM
> Is there a specific business need to see the contents of a log other than
> for recovery when there is a file system failure?

yes.  to see which user deleted/changed data that was not supposed to be
deleted/changed (and when it was done).  i guess more generally to keep tabs
on when data is getting changed and by whom.




"Nick Elson" <no_spam_nicelson@sybase.com> wrote in message
news:41f461f3$1@forums-2-dub...
> You could write you own GUI for this (if you are up to writting C code to
> access our dbtools API) but dbtran is it.
>
> Is there a specific business need to see the contents of a log other than
> for recovery when there is a file system failure?  [if not dbtran suffices
> for most of the needs we are aware of]
>
> "Douglas M. Deram" <dougderam@yeahright.com> wrote in message
> news:41f16059$1@forums-2-dub...
> > i'm not sure if this is the right forum for this thread, but i was
curious
> > if anyone knew of a utility that allows an end user to interpret a log
> > file.
> >
> > obviously right now we can have our users send us their log file and we
> > can
> > convert it to SQL and then search for a particular date/SQL command.
> > basically, does anyone know of a utility with a user interface that
would
> > allow someone who is not too database savvy to do this on their own?


0
Douglas
1/24/2005 3:41:27 PM
Take a look at the dbtran utility as a starting point.

-- 
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
 choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Douglas M. Deram" <dougderam@yeahright.com> wrote in message
news:41f51722$1@forums-2-dub...
> > Is there a specific business need to see the contents of a log other
than
> > for recovery when there is a file system failure?
>
> yes.  to see which user deleted/changed data that was not supposed to be
> deleted/changed (and when it was done).  i guess more generally to keep
tabs
> on when data is getting changed and by whom.
>
>
>
>
> "Nick Elson" <no_spam_nicelson@sybase.com> wrote in message
> news:41f461f3$1@forums-2-dub...
> > You could write you own GUI for this (if you are up to writting C code
to
> > access our dbtools API) but dbtran is it.
> >
> > Is there a specific business need to see the contents of a log other
than
> > for recovery when there is a file system failure?  [if not dbtran
suffices
> > for most of the needs we are aware of]
> >
> > "Douglas M. Deram" <dougderam@yeahright.com> wrote in message
> > news:41f16059$1@forums-2-dub...
> > > i'm not sure if this is the right forum for this thread, but i was
> curious
> > > if anyone knew of a utility that allows an end user to interpret a log
> > > file.
> > >
> > > obviously right now we can have our users send us their log file and
we
> > > can
> > > convert it to SQL and then search for a particular date/SQL command.
> > > basically, does anyone know of a utility with a user interface that
> would
> > > allow someone who is not too database savvy to do this on their own?
>
>


0
Robert
1/24/2005 3:48:34 PM
On 24 Jan 2005 07:41:27 -0800, "Douglas M. Deram"
<dougderam@yeahright.com> wrote:

>> Is there a specific business need to see the contents of a log other than
>> for recovery when there is a file system failure?
>
>yes.  to see which user deleted/changed data that was not supposed to be
>deleted/changed (and when it was done).  i guess more generally to keep tabs
>on when data is getting changed and by whom.

If that is an ongoing need, new "audit" tables with rows inserted by
delete and update triggers would make life much easier as well as
allow instant checking. The primary key of an audit table should
consist of the primary key of the original table plus a DEFAULT
CURRENT TIMESTAMP column, to allow for the fact that a base table row
with the same primary key can be deleted and inserted more than once.

Breck

--
SQL Anywhere Studio 9 Developer's Guide 
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20 
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
0
Breck
1/25/2005 10:37:44 AM
Reply: