on 03-24-2014 7:43 PM
I have sybase installed and running on Linux. How can I read the errorlog? for example from windows client?
Two methods
1. Using a text editor
The location of the errorlog file can be found in the RUN_<db server name> file located at $SYBASE/$SYBASE_ASE/install. For me it is located at /Sybase/Sybase_15-0/install/RUN_<DBServer>. This file will give you the location of the error log and then you can read it using any text editor on the database server host.
2. Using a query tool
If you want to use a query client tool to access errorlog then one option is to enable the mda tables for error log. You might want to do a bit of reading on these first before trying it out in production.
Here is what you need.
exec sp_configure 'enable monitoring',1
exec sp_configure 'errorlog pipe active', 1
exec sp_configure 'errorlog pipe max messages', 300 -- tweak it as per your requirement and resources.
go
After you have set up these parameters you might use master..monErrorLog to look at the error log using a select statement. The user should be added to mon_role to access this table.
warm regards,
sudhir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.