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.
