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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.