ASE Database forum

Author

Read log

Manuel Espinoza

2005-12-29, 1:24 pm

is there a way to read ASE's log??

Rob Verschoor

2005-12-29, 8:24 pm

You can use dbcc log. This is an undocumented command -- search on the
internet for clues how to understand the output. If you have my book "Tips,
Tricks & Recipes for Sybase ASE", it contains various examples of how to
extract certain information elements from the log.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"Manuel Espinoza" <jmespino& #91;no_spam]za_en_se
icom.com.mx> wrote in message
news:43b426a2$1@foru
ms-1-dub...
> is there a way to read ASE's log??
>
>

Jason L. Froebe [Team Sybase]

2005-12-29, 8:24 pm

Rob Verschoor wrote:
> You can use dbcc log. This is an undocumented command -- search on the
> internet for clues how to understand the output. If you have my book "Tips,
> Tricks & Recipes for Sybase ASE", it contains various examples of how to
> extract certain information elements from the log.
>
> HTH,
>
> Rob
> -------------------------------------------------------------
> Rob Verschoor

Don't forget the 3rd party products such as ProActive DBA by Whitesands
and Quest Foglight by Quest Technologies. Both will read the log in a
human readable format.

--
Jason L. Froebe
http://jfroebe.livejournal.com
Team Sybase

Sponsored Links