Error 1009157

"There is insufficient reserve space to add %3 blocks to segment %2. Only %4 blocks or less may be added. %1"

Item	Description
SQLCode	-1009157L
Constant	EMSG_SDBEXT_SEGMENTNORESERVE
SQLState	QSB52
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Sybase Error Code	20195
Severity Code	14
Parameter 1	location of the exception
Parameter 2	Database segment.
Parameter 3	Number of blocks user attempted to add
Parameter 4	Maximum blocks that may be added

Probable cause

Since a segment must use a contiguous range of block numbers, it can only be resized larger when the blocks following it are not in use by the next segment.