Solved

SYBASE LOG Information

Posted on 2009-07-08
5
463 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
Comment Utility
0
 
LVL 14

Expert Comment

by:shru_0409
Comment Utility
0
 
LVL 14

Assisted Solution

by:Jan_Franek
Jan_Franek earned 75 total points
Comment Utility
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
Comment Utility
> 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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now