Question about Sybase Adaptive Server Enterprise for Mac OS X 12.5

1 Answer


Dear sir,


my databse size is 20gb, my log file size 5gb, my log file is full then what i do?



Posted by on


1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Hi Sushant,

If your database log gets filled. You can alter the log size if required in future too. If the log suddenly got filled and it is not occuring everyday then you have to find which query causing the log filled by executing the below

select * from syslogshold where dbid=db_id("your db name")

find out the spid and then run sp_showplan and dbcc sqltext for the particular spid and then decide upon the query whether you can stop(kill the process) it or allow it run by increasing the log space.

Be careful in production environment. Don't it kill any process without confirmation of user.

If the same query is running everyday and log is getting fill everyday then you can alter the database log space with proper approval.

If the same query is running everyday but today only log space got fill then check the growth of data decide accordingly log size of your database.

I hope this will help you if log got filled.

All the best


Posted on Oct 29, 2007


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

How does S9700 write Logs to CF card?

The logs are cached instead of being immediately written into the log files on the CF card. The S9700 supports two methods to write the logs:
1, On S9700, the cache can store 33 KB logs. When the cache is full, the logs are written into the log file on the CF card.
2, You can also store logs to the CF card manually. That is, run the save logfile command in the user view. The information in the cache can be immediately written into the log file on the CF card.

Aug 24, 2016 | Computers & Internet

1 Answer

I placed a order with EMTC (Transaction ID 6F842902BD799474T) on 03/12/2015. I was told the item shipped on 03/13/15 but I have not received it yest. When I use the Tracking # 0968835404521548 it tells me...


I believe you may be a victim of a scam and I would log into your Paypal account and file a claim to have the charges reversed. You can contact a Paypal agent by looking up "contact us" at the bottom of a Paypal page. If you do not get help from Paypal then by all means call your credit card company (Paypal hates this) and have the charges reversed. Do not delay. Your not going to get what you spent your money on! A full answering message machine is the FIRST BIG RED FLAG you have been had!
Good luck.

Mar 20, 2015 | Computers & Internet

1 Answer

After restore database lost my graph of sales ,

You should run Verify to check for damage whenever QuickBooks appears to be functioning improperly or erroneously. The Verify Data utility detects data damage, and then logs any errors it finds in a file named Qbwin.log. The Qbwin.log file is contiguous, so that every time you verify, rebuild, condense, or update your data, any integrity issues found will be appended to the end of the Qbwin.log file. It is common for the Qbwin.log to become very large. You can identify only current errors in the data file by renaming the Qbwin.log file, located in your QuickBooks directory, to Qbwin.old. QuickBooks will create a new Qbwin.log file to store the results of the utility you ran most recently. To run the Verify utility
check this for more details

Jan 18, 2011 | Intuit QuickBooks Pro 2010 Full Version...

1 Answer

I have a Dell Dimension 4600 PC. I get error messages saying "cannot find install log" Does this mean a full restore??

Yuo missed a log file by some reason . somebody has delete a log file . check your recycle bin if you see a filecalled" install "restore it . otherwise you have to copy back that file .
this wrning is not asking you to full restore

Oct 24, 2009 | Dell Dimension 4600 PC Desktop

1 Answer

Partition Full

This is a log file from VMWARE. Click on the link below to get more information. Please note that this is not a direct solution, but solution for a similar problem. If you intend to follow the steps, please ensure that you take backup, where required.

Aug 06, 2009 | Envision EN-910e 19 in.CRT Conventional...

1 Answer

Burn errors cant get drive to write

It looks like from error codes that yoi may have a hardware error, or a disk format problem, if this is only burning problem you have on pc and it worked before, then uninstall and reinstall Nero, info gathered from here,
sense code 5 ASC 2c= 5 / 2C / 00 COMMAND SEQUENCE ERROR
5ASC2700=5 / 27 / 00 WRITE PROTECTED
Please give good rating if this helps you or points you in right direction, thanks

Apr 12, 2009 | Computers & Internet

1 Answer

The size of squid log files of my proxy server are geting too big for my disk space. I manually deleate them when the disk space is gettin full & the squid service is stoped autometically.How can I delete...

Find your squid.conf file. Likely path to it could be /usr/lib/squidc/etc, or
maybe /etc/squid.

That file should contain a setting for logfile_rotate, probably at a default of
10. Change that to 2.

Then add a once-a-day job to root's crontab, on the order of:
1 1 * * * /usr/lib/squid/bin/squid -k rotate

Mar 03, 2008 | Computers & Internet

Not finding what you are looking for?
Sybase Adaptive Server Enterprise for Mac OS X 12.5 Logo

Related Topics:

977 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sybase Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Sybase Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides