Question about Sybase Adaptive Server Enterprise for Mac OS X 12.5

1 Answer

SYBASE 12.0 WHEN LOG IS FULL THEN WHAT CAN I DO?

Dear sir,

 

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

thanks

sushant

Posted by on

Ad

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

Regards,
Rajini 

Posted on Oct 29, 2007

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

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

Hi,
A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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.
http://www.thunder-link.com/S9706_p832.html

Aug 24, 2016 | Computers & Internet

Tip

Chkdsk.exe


check hard disk health
Check Disk - check and repair disk problems
goi to run type cmd in run, open cmd as administrator

TYPE

CHKDSK [drive:][[path]filename] [/F] [/V] [/R] [/L[:size]]
Key
[drive:] The drive to check.

filename File(s) to check for fragmentation (FAT only).

/F Automatically Fix file system errors on the disk.
/X Fix file system errors on the disk, (Win2003 and above)
dismounts the volume first, closing all open file handles.

/R Scan for and attempt Recovery of bad sectors.

/V Display the full path and name of every file on the disk.

/L:size NTFS only: change the log file size to the specified number of kilobytes. If size is not specified, displays the current log size and the drive type
(FAT or NTFS).
/C Skip directory corruption checks.
/I Skip corruption checks that compare directory entries to the
file record segment (FRS) in the volume's master file table (MFT)Example:

on May 20, 2010 | 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...


Sir,

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.

http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?objectID=c00809217

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,
http://www.isobuster.com/help.php?help=305
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?

Open Questions:

See all Sybase Adaptive Server Enterprise for Mac OS X Questions

Sybase Adaptive Server Enterprise for Mac OS X 12.5 Logo

Related Topics:

976 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sybase Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 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

Loading...