Re: DBSrv 9.0.1 - Tempfile is growing and growing and then Disk is full - TEMP_SPACE_LIMIT_CHECK? - 12-24-2008 , 08:55 AM
The temp file is used to store cache pages that do not belong in a dbspace
or the transaction log file. The most common of these are pages required to
materialize a result set so running the big query causes the file to grow
If you enable the option TEMP_SPACE_LIMIT_CHECK the connection trying to use
more than it's quota will get a SQLSTATE_TEMP_SPACE_LIMIT error and the
statement will be cancelled.
This should prevent you from running out of disk space.
You should still sort out why you are allowing "runaway" queries like this
or add some disk so the problem doesn't occur.
Stephen Rice, Sybase iAnywhere
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"
"Andreas Bauer" <andreas.bauer (AT) vsa (DOT) de> wrote