Very Computer

When we created our database device (dd1), we created it smaller than the
logical volume it resides on and so it is not taking full advantage of the
space on the volume.  We can no longer increase the size of our database on
this device either.  We've been told by consultants that the solution is to
drop our database, redefine the device, and then reload the database.  We
don't want to do this because it may involve reloading system databases as
well where we would encounter numerous problems.

Another option we have discovered is that we do have space available on two
other volumes and we're thinking we may be able to just extend our database
device onto these other volumes, not having to do any kind of dump/restore.
 But this sounds almost too easy.  

Any other suggestions or advice on the options above?

Bobbi

|> When we created our database device (dd1), we created it smaller than the
|> logical volume it resides on and so it is not taking full advantage of the
|> space on the volume.  We can no longer increase the size of our database on
|> this device either.  We've been told by consultants that the solution is to
|> drop our database, redefine the device, and then reload the database.  We
|> don't want to do this because it may involve reloading system databases as
|> well where we would encounter numerous problems.

I would agree with the consultants.  Why on earth would this involve reloading
the system databases? (unless you have your user database on the master device,
which is poor practice in the first place.  If that is the case, let me know).

It is presumably possible to directly update the sysdevices.high field to
enlarge the device to the real size of the volume, but I don't advise doing
it and Sybase does not support doing so.  If you miscalculate, you will be

Quote:>very< unhappy at some unpredictable* time in the future.

|> Another option we have discovered is that we do have space available on two
|> other volumes and we're thinking we may be able to just extend our database
|> device onto these other volumes, not having to do any kind of dump/restore.
|>  But this sounds almost too easy.  

You can't extend your >device< onto other volumes, but you could certainly run
disk init to create a new sybase device on those volumes and then alter your

Quote:>database< onto the new device.  You will still be wasting the unused disk

--
---------------------------------------------------------------------
| Bret Halford                    Imagine my disappointment       __|
| Sybase Technical Support        in learning the true nature  __|  
| 6400 S. Fiddlers Green Circle   of rec.humor.oracle...    __|  
| Englewood, CO 80111-4954 USA                             |
============================================================

HTH

Manoj