Sybase Error – Cannot create or add file %2 for dbspace %3 until new readwrite space is added to dbspace %4 to hold the new freelist. %1

In this blog post, you’ll learn more about the Sybase Error Cannot create or add file %2 for dbspace %3 until new readwrite space is added to dbspace %4 to hold the new freelist. %1 and the reason for receiving this error

Sybase SQL Error Message

Cannot create or add file %2 for dbspace %3 until new readwrite space is added to dbspace %4 to hold the new freelist. %1

Reason for this Error

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.