Solved

SYBASE LOG Information

Posted on 2009-07-08
5
467 Views
Last Modified: 2012-05-07
ASE is installed on UNIX machine but mounted on to different servers.
I want to know where the log in getting dumped.
I tried select @@ERRORLOG and that gives me the path but not the server name.
Could you please let me know if there is any way to find it ?
0
Comment
Question by:koppcha
5 Comments
 
LVL 14

Expert Comment

by:shru_0409
ID: 24803740
0
 
LVL 14

Expert Comment

by:shru_0409
ID: 24803772
0
 
LVL 14

Assisted Solution

by:Jan_Franek
Jan_Franek earned 75 total points
ID: 24803798
As far as I know, ASE can't directly access files on other servers. So @@ERRORLOG should give you valid path on the server that ASE runs on. It can be mounted from other server, but it's OS thing, not ASE thing.

In most UNIXes you can probably use mount command to see paths, that are mounted on external servers. Or just ask your UNIX admin.
0
 
LVL 6

Assisted Solution

by:IncisiveOne
IncisiveOne earned 75 total points
ID: 24810389
> ASE is installed on UNIX machine but mounted on to different servers.
"mount" is a technical term, an Unix command, so no, that is impossible.  Please identify exactly what you really mean.  Or do you mean "available" on different systems (servers or PCs, they are all Clients because in this context, ASE is the Server) ?

@@errorlog will give you the path to the errorlog file.  Not the transaction log that gets dumped.

Each database has a transaction log (one per db; not one per server).  Since you have no documentation, you will need to inspect the server.  You will need "sa_role", which is similar to admin privileges.   To find the location of the tran log dump
- use  <db_name>
- sp_helpthreshold (confirm that non-LCT thresholds have been set and the name of the sproc that is invoked when a threshold is triggered)
- use sybsystemprocs
- [using whatever tool you use for extract/display and] extract the named threshold proc
- the default proc is "sp_thresholdaction"
- read the code.  Somewhere in there, you should find a "dump tran <db_name> to <path/file_name>"

That will be a local path, not an external path.  (NFS and external paths it may well be, but that is done at the o/s level before ASE is booted, and that is transparent, the result is, the path is local).  On that unix system, as the sybase user, you should be able to:
- ls -ls <path/file_name>

If there is no such proc, the tran log is not getting dumped.  It may be a development database, check:
 - sp_helpdb <db_name>
 - look for "truncate_log_on_checkpoint" option being set
 - post back here
 
 Cheers
0
 
LVL 1

Accepted Solution

by:
BenSlade earned 100 total points
ID: 24963910
Re:  "ASE is installed on UNIX machine but mounted on to different servers."

Do you mean the ASE executables are available on a network shared filesystem which is mounted to different Unix machines?  Ie., the ASE server runs on a Unix machine and the executables being run come from files on the shared file system?

Re: "I want to know where the log in getting dumped."

Ie, the Unix box where the ASE server is running?   Because ASE writes out it's error log onto what it thinks is a local file on the box where it's running.

Re: "I tried select @@ERRORLOG and that gives me the path but not the server name.
Could you please let me know if there is any way to find it ?"

Assuming you want to find the Unix host where the ASE server is running, you can't get that from inside the ASE server.  You have to get that out of the interfaces file.

Ben
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Advantage DB snapshots, replication or mirroring 2 430
sybase 3 53
sql statement error sybase 2 64
Sybase and replication server 13 56
While it may be true that the internet is a place of possibilities, it is also a hostile environment lurking with many dangers. By clicking on the wrong link, trusting the wrong person or using a weak password, you are virtually inviting hackers to …
Direct mail marketing is the act of mailing materials straight to prospective customers. This wide form of marketing is one of the oldest methods of communicating with a geographic based demographic. So is it useful in 2017 and beyond?
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question