we are facing issue with the temp file which is growing very fastly in /usr/openv/tmp/sqlany/nb_/tmp/
we tried with database rebuild but still we are facing the same issue and also tried with
AUDIT="ENABLED"
AUDIT_RETENTION_PERIOD="14" but no luck
The temp files in /usr/openv/tmp/sqlany/nb_/tmp/ might be growing fast due to heavy queries, big transactions, or index rebuilds. You can try limiting the temp file size with sp_configure 'MaxTempFileSize' and tweak the TEMPDB settings. Make sure there's enough disk space, and consider moving the temp files to a different drive. If that doesn't fix it, check the logs, update SQL Anywhere, or reach out to support for help.
