![DIVIDE_BY_ZERO_ERROR option [TSQL]](arrow-right.gif){kind=icon}
Sets database block allocation policy.
ON, OFF
ON
Can be set for the PUBLIC group only. Requires DBA permissions. Takes effect at the next checkpoint.
In general, disk space fragmentation is much lower with the default setting, DISK_STRIPING_PACKED OFF. DISK_STRIPING_PACKED OFF causes Sybase IQ to check first for the first available space fragments to use when allocating space.
Change this option only if Sybase Support instructs you to do so. When this option is ON, Sybase IQ allocates space starting from the next available last block allocated on the current dbspace.
For more information about disk striping and performance, see Balancing I/O in Chapter 5, “Managing System Resources” of the Sybase IQ Performance and Tuning Guide.
