Skip to Content
0

Removing a device from a database Sybase ASE 15.0.2

Mar 21, 2017 at 01:01 AM

320

avatar image

There is an extra device created on a second database and not needed anymore. The device is already in use on the first database. There is no data being used on this device by the second database. What is the best method to remove the device from the second database preferably without having to restart the database?

ASE server is 15.0.2. (does have replication)

There is a method available on more recent ASE 15.7 servers. Is there any workaround on ASE 15.0.2?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bret Halford
Mar 22, 2017 at 03:12 PM
0

I don't think you can avoid a reboot of the database.

The easiest method would be to dump the second database, drop the second database, re-create the second database for load using another device in place of the device you want to remove from the second database, load the dump.


However, I suspect that you not only want to remove the device from the database, but also make the database smaller - which isn't quite the same thing. I wrote up a process for shrinking a database a couple decades ago, long before the formal ALTER DATABASE SHRINK feature was introduced. It is published on the old International Sybase Users Group FAQ site

http://www.isug.com/Sybase_FAQ/ASE/section1.2.html#1.2.12. I consider it safe as long as you are sure to take a fresh dump of the database before starting (so you can restore the starting point if anything goes wrong) and full dbccs (checkalloc and checkdb) run clean at the end.


-bret

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for the response Bret. The intent is to remove the device only from the second database where it is not being used. (there is also some extra unused space). Ideally, it needs to be done without a reboot. It seems that I may have come across your article to shrink the database before..If you find any other options, kindly notify.

Regards

Aravind

0