Solved

SYBASE LOG Information

Posted on 2009-07-08
5
470 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
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

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

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

This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

630 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