Is there a DB size limit in SAP ASE developer edition (16.0 SP02). Cannot insert any data anymore.

[Former Member]

Hello,

I've recently installed SAP ASE developer edition (16.0 SP02) on Windows Server 2012.

The installation went fine and I could use the DB normally up to a point. Right now, I cannot insert any data into any database (SELECT queries still run fine). INSERT queries, or CREATE TABLE queries hang forever. Restarting the services or machines didn't help. I wonder if there is any limit on the database size in this edition and if so, what it is.

When trying to add more space via Sybase Central (right click on master->Properties->Devices->Add) it no longer let's me do it (the size is set to 236 MB). Previously, when I could add some space, it would revert the settings to some lower figure, than I entered.

I wonder if there indeed is some limitation on the size of DB in this edition, or perhaps there are some settings I should change.

Would appreciate the response.

[Former Member]

Thank you very much for the response. The problem was indeed related to the transaction log filling up.