"Cannot create or add file %2 for dbspace %3 until new readwrite space is added to dbspace %4 to hold the new freelist. %1"
| Item | Description |
|---|---|
|
SQLCode |
-1009064L |
|
Constant |
EMSG_SDBEXT_NO_FREELIST_SPACE |
|
SQLState |
QSA64 |
|
ODBC 2 State |
ERROR |
|
ODBC 3 State |
ERROR |
|
Sybase Error Code |
20085 |
|
Severity Code |
|
|
Parameter 1 |
location of the exception |
|
Parameter 2 |
pathname of file being created |
|
Parameter 3 |
name of dbspace for which file is being created |
|
Parameter 4 |
name of IQ_SYSTEM_MAIN dbspace |
When creating a new dbspace in the IQ MAIN STORE, or creating a new file for a dbspace other than IQ_SYSTEM_MAIN in the IQ MAIN STORE, there must if sufficient freelist space available to describe the physical blocks we are adding to the database. If this is not the case, the above error occurs. (The space for the freelist can only be allocated in readwrite IQ_SYSTEM_MAIN files.) The corrective action is to first add a new file to the IQ_SYSTEM_MAIN dbspace so that new freelist space becomes available.