In this blog post, you’ll learn more about the Sybase Error A local main cache already exists for this node and the reason for receiving this error
Sybase SQL Error Message
A local main cache already exists for this node
Reason for this Error
Creation of more than one user defined CACHE dbspace is not allowed per node.