niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Sybase
check transaction log
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
Chris
*nix forums beginner


Joined: 10 Jul 2006
Posts: 1

PostPosted: Mon Jul 10, 2006 6:10 am    Post subject: check transaction log Reply with quote
Help! is there a way i can view if the transaction logs are getting
full? My problem is that every week i do a dump_tran just to clear the
transaction log because when the transaction log gets full our
application hangs. So what i need is how to check if the transaction
log is nearing 100%. BTW, I perform a daily dump database but somehow
the transaction log still gets full once a week.

Thanks!
Back to top
bret@sybase.com
*nix forums addict


Joined: 24 May 2005
Posts: 66

PostPosted: Mon Jul 10, 2006 3:50 pm    Post subject: Re: check transaction log Reply with quote
Chris wrote:
Quote:
Help! is there a way i can view if the transaction logs are getting
full? My problem is that every week i do a dump_tran just to clear the
transaction log because when the transaction log gets full our
application hangs. So what i need is how to check if the transaction
log is nearing 100%. BTW, I perform a daily dump database but somehow
the transaction log still gets full once a week.

Thanks!

To get the current size of the log in a database:

sp_spaceused syslogs

Note that DUMP DATABASE does not truncate the log - it just makes
a backup copy of everything. The DUMP TRAN command makes a copy
of the log and then truncates it (up to the beginning of the oldest
still open
transaction).


You can use THRESHOLDS to automatically dump and truncate the log
when it reaches some level of fullness.

-bret
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Sun Nov 23, 2008 11:09 am | All times are GMT
navigation Forum index » Databases » Sybase
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Force linker to check all the implementation toton C++ 1 Thu Jul 20, 2006 6:08 am
No new posts Qmail / SpamControl => Check if DNS exist ? Phibee NOC Qmail 2 Thu Jul 20, 2006 4:51 am
No new posts Power On Self Test Failed: Memory check Blk test failed BertieBigBollox@gmail.com Solaris 0 Wed Jul 19, 2006 9:48 am
No new posts How to check if a variable contains a " or ` ? Unix-Shell shell 1 Tue Jul 18, 2006 2:10 pm
No new posts range() is not the best way to check range? Summercoolness@gmail.com python 42 Tue Jul 18, 2006 2:41 am

Adverse Credit Remortgage | Debt Consolidation | Loans | Fast Loans | Remortgages
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.3272s ][ Queries: 16 (0.1723s) ][ GZIP on - Debug on ]