SAP Knowledge Base Article - Preview

2737823 - Temporary file grows until the file system runs out of space

Symptom

The SQL Anywhere temporary file keeps on growing up to hundreds of GBs when executing a complex INSERT statement with many JOINs (INSERT INTO .... ( ..... ) SELECT ..... FROM myCentralTable JOIN .... ON .... JOIN .... ON .... JOIN .... ON .....).


Read more...

Environment

SAP SQL Anywhere 16.0.0.2754
Microsoft Windows
Database server options: -c 50p -ch 70p -xtcpip -ti0 -tl0 -n myName -dt "C:\SQLAny\" "C:\SQLAny\myDir\myDB.db"

Product

SAP SQL Anywhere 16.0

Keywords

Sybase , KBA , BC-SYB-SQA-SRV , SQL Anywhere - Server , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.