Abend.log max file size
Does anyone know how to increase the max size of the abend.log file? I
have 3 servers out of 30 that for some reason get to 100k and then
won't write to the log file after that. I have no idea why those
particular servers have restrictions and all the others don't,
especially since I can't find anyplace to set the size of that file.
Thanks.
--
Rmurphy24
------------------------------------------------------------------------
Rmurphy24;1565029 Wrote:
> Does anyone know how to increase the max size of the abend.log file? I
> have 3 servers out of 30 t...
Max Size of Transaction Log FileI try to limit the size of transaction log file. According to online
help, -m option may speed up the database fragmentation when .log and .db
files are on the same drive. Another approach is to create an event handler
and use BACKUP DATABASE DIRECTORY '' ... command to truncate the log file
when it exceeds certain size. Is there a third road to limit the log file
growth? Any drawback on the second approach and what is a practical max size
of the log file? Thanks.
mason wrote:
> I try to limit the size of transaction log file. According to online
> help, -m op...
sqla max file size on 32 bit windows
What is the maximum sqla v9/10/11 db file size, when running on 32 bit
windows?
Thanks,
Doug
This will depend on the page size that you are using, and the filesystem
that is being used to hold the database (files).
The maximums have not changed between any of these versions.
Take a look in the docs under:
SQL Anywhere� Server - Database Administration
Physical Limitations
Size and number limitations
--
Mark Culp
SQLAnywhere Research and Development
Sybase iAnywhere Engineering
-------------------------------------------------------------------------
-- SQL A...
curious max user log cache size observation (11.9.2x)Hi,
I have a semi-interesting observation while reviewing multiple sp_sysmon runs on
11.9.2x. Typically when the ULC is flushed due to it being full, the "Max ULC
Size During Sample" will match the "max user log cache size".
As you can see below, there is a 4 byte discrepency between the two. Why should
I care about 4 bytes? Normally, I don't but I've noticed that when they don't
match, it is almost always 4 bytes difference (about 90% of the time with 8
bytes being the other times).
Yes, yes, I know about the "remaining portion of the ...
curious max user log cache size observation (11.9.2x)Hi,
I have a semi-interesting observation while reviewing multiple sp_sysmon runs on
11.9.2x. Typically when the ULC is flushed due to it being full, the "Max ULC
Size During Sample" will match the "max user log cache size".
As you can see below, there is a 4 byte discrepency between the two. Why should
I care about 4 bytes? Normally, I don't but I've noticed that when they don't
match, it is almost always 4 bytes difference (about 90% of the time with 8
bytes being the other times).
Yes, yes, I know about the "remaining portion of the ...
Log file size different for dbbacked up logsASA 6.0.3.2747
I noticed that the log files created by dbbackup are 8k, whereas the 'live'
log files are 192k. Is this a problem?
Most of these log files have no transactions -- they are the result of my
testing replication using dbbackup etc. and I'm not creating any
transactions between iterations.
I haven't noticed any problems with the backed-up versions of the log
files -- I can even run the remote agent against them. So really I am just
looking for some reassurance that the 8k log files are OK.
My command line is:
DBBACKUP -r -k -y -t -c ...etc.
Tha...
Max File size!Does anyone know what the maximum file size is for a SQLAnywhere 5.0
database, running the 16-Bit engine on NT 4 server. The SQL books say 2G,
they also state that if the engine is running on an NTFS partition that the
limitation of file size is determined by the OS. Does this apply to the
16-Bit engine? Thanks in advance for your help.
Eric Vinson
Eric_Vinson wrote...
> Does anyone know what the maximum file size is for a SQLAnywhere 5.0
> database, running the 16-Bit engine on NT 4 server. The SQL books say 2G,
> they also state that if the engine is running on a...
LOG File SizeI am looking forward for the log file size where it will not take a
performance hit.
For example of about 30GB database,
ENV ASA 5.5
and ASA 8.0.2
Thanks
VSV
To improve performance of the log file, make sure that it is hosted on a
separate physical hard drive on the same machine that is hosting the server.
If the log and the db are on the same device, they will compete for access
to the read/write head of the drive.
There are several options for log file management. I suggest that you look
into the use of -r option of the dbbackup command. Its use will result in a
backup an...
Log max sizeis there a way to define a max size for the filter and junk logs?
when the log gets on the X size, the older logs are deleted and the
newer ones gets logged
...
Log file size
I was just browsing my SQL server and realized that my dotnetnuke database LOG file in SQL was almost 10 gig in size. Is there a way to disable logging in DotNetNuke?
You can set the number of days for logging, I think default is 60? I believe it's under host settings, and can be per portal.ChrisHammond.comEngage Software
What about archiving the info for tend analysis over a year for example.
How about adding an archiving capability that exports just the log into a zip file for later retreival by a yet to be built module that can read the zip file.
As we all know clients like to...
Log file sizesWe have post office agents running on both Netware and windows boxes. On
the netware boxes log files are smaller and there many small files on a
daily basis. On the windows boxes only a single file is created on a daily
basis and this can be quite large and cumbersome to use. Is there anyway
to choose the log file size on a windows box??
Also on a windows box we have trouble setting the physical log file
allocation space. We set it with the switch /logmax-size option but it
defaults to a different than we set. Also found to have trouble setting
through consoleone. Anyone have ...
log file size
Should the log file created the first time you run discovery be growing
to 20 gb? Are there settings you can change on what gets logged? This
is a new 10.1 install.
--
cleik
------------------------------------------------------------------------
cleik,
>Should the log file created the first time you run discovery be growing
>to 20 gb? Are there settings you can change on what gets logged? This
>is a new 10.1 install.
Component Name: Deployment
Enable Debugging (self documenting xml file. Set to FINEST):
Windows server:
\Program Files\Novell\ZENworks\c...
Enforce max file size of 5MB with "File upload" control
Hi, Whenever I try to upload a file bigger than 4MB I get an "Internet Explorer cannot display the webpage" error.I googled on this and found out that the solution is to increase the value of maxRequestLength in web.config. However the page will still crash if file size is greater than maxRequestLength!!Then I override OnError and tried to display some friendly message using Response.write, but still get "cannot display the webpage" error and not my custom message. How can I completely override the asp.net default behavior on this. Don't forget to click &quo...
Max File size!Does anyone know what the maximum file size is for a SQLAnywhere 5.0
database, running the 16-Bit engine on NT 4 server. The SQL books say 2G,
they also state that if the engine is running on an NTFS partition that the
limitation of file size is determined by the OS. Does this apply to the
16-Bit engine? Thanks in advance for your help.
Eric Vinson
Eric_Vinson wrote...
> Does anyone know what the maximum file size is for a SQLAnywhere 5.0
> database, running the 16-Bit engine on NT 4 server. The SQL books say 2G,
> they also state that if the engine is runnin...