Error 1009118

Message text

Database segment '%2' is not valid. %3 freelist blocks were found, but %4 freelist blocks were expected. This segment cannot be used. %1

Item

Value

SQLCode

-1009118L

Constant

EMSG_SDBEXT_DIF_NFLBLOCKS

SQLState

QSB18

ODBC State

ERROR

Parameter 1

location of the exception

Parameter 2

name of the segment

Parameter 3

number of freelist blocks recorded in the segment header

Parameter 4

number of freelist blocks that were expected to be recorded in the header

Probable cause

When a database segment is opened, the segment header is read and the number of freelist blocks read from the header is compared with the number of freelist blocks that are expected to be read from the segment header. If the numbers do not match, the segment cannot be used and the database must be restored from backup.