Error when trying to create a new device

I get the following error when trying to create a new device. I tried a couple of times and even rebooted the server. I'm not sure what it means. The error log doesn't give me any good information.


Any ideas?

Who is Participating?
Joe WoodhousePrincipal ConsultantCommented:
Supporting a certain number of Sybase devices take up memory, so ASE starts with a very small number by default.

ie. you're still running with a default configuration, which is only enough to start the ASE out of the box. You've hit that limit so you can't have any more.

You need to run (with SA privileges):

sp_configure "number of devices", N

where N is a larger number.

Depending on your version this may require a Sybase restart.

Don't go crazy and make N huge! You are paying memory for these even if you aren't using them. 25-50 should be plenty for now.

This also implies you've left a number of other important settings at default, which isn't appropriate even for a toy dataserver on a laptop...
entronetAuthor Commented:

The server is an exact copy of an already configured server so I don't believe the settings are all that wrong. I do prefer to read up on the configuration and optimization though. Is there a place where I can get some good pointers (no book).

Joe WoodhousePrincipal ConsultantCommented:
In my experience it's quite unusual to find "number of devices" left at the default value of 10. It would normally be one of the first five things I'd change in a newly built server... but perhaps you've just never needed more than 7 (3 are typically used for system devices). 8->

The best reference for the *many* configurable options is the System Administration Guide. You don't say what version you're on so I'll point you at a fairly modern (but not the latest & greatest) one:

Chapter 4 covers the parameters.

I know you said you didn't want a book, but really, for documenting what there is and what they do, this is the best. Sybase's manuals are actually pretty good most of the time!

What the manual *doesn't* cover is *when* to change a setting, and what to change it to. That's a fairly extensive topic and I really don't know where to start you off. Again the Sybase manuals (look for the Performance and Tuning volumes) do a pretty good job. Failing that most of the easily internet-findable resources are now very out of date and are more trouble than they're worth...

... yeah, I just had a quick search and everything I find is at least three versions old. I'll keep looking and post if I find anything...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.