We help IT Professionals succeed at work.

Error when trying to create a new device

entronet
entronet asked
on
Medium Priority
1,281 Views
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.

THE VDEVNO OF 10 IS OUT OF RANGE. THE MAXIMUM VDEVNO ALLOWED IS 9.

Any ideas?

/RH
Comment
Watch Question

Principal Consultant
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
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...

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks,

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

/Rasmus
Joe WoodhousePrincipal Consultant
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
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:

http://manuals.sybase.com/onlinebooks/group-as/asg1251e/sag

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...
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.