Error when trying to create a new device

Posted on 2006-03-21
Last Modified: 2012-08-13
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?

Question by:entronet
    LVL 24

    Accepted Solution

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

    Author Comment


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

    LVL 24

    Expert Comment

    by:Joe Woodhouse
    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...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now