Enforcing quota on Catalog Store temporary space (behavior change) A new database option, TEMP_SPACE_LIMIT_CHECK, lets you prevent connections from using more than their quota of Catalog Store temporary space. As a result of this change, when this option is enabled, some queries against Catalog Store tables may fail in situations where they did not in previous versions; however, this option helps ensure that temporary space requirements of individual connections do not affect server stability. For more information, see “TEMP_SPACE_LIMIT_CHECK option” in Sybase IQ Reference Manual.
sa_disk_free_space system procedure This procedure allows you to determine the space available for your Catalog Store dbspaces and temporary file, the transaction log, and transaction log mirror. For more information, see the Adaptive Server Anywhere SQL Reference.