The ScopeSET Support and Community Portal
         
View all tags
Tags:    No tags associated yet.
To provide more physical data space to the sybase server existing devices can be enlarged or additional devices can be added. Both topics will be covered here.

Enlarging existing devices

To enlarge an existing device sybase provides the command 'disk resice', which can be executed in isql.

First, set the Sybase environment and start isql

isql -Usa -P<sa Password> -S<ASE server name>
  • in a default Sybase Promo Installationen,the sa password is blank, for OpenAmeos, it is usually "welcome" (see here)
  • ASE Server name is the logical name of the Sybase server (see $SYBASE/interfaces when in doubt)
On the isql command prompt you then can execute 'disk resize':
1> disk resize name="ameos_device", size="100M"
2> go

This will enlarge 'ameos_device' by 100MB.

To check if the device has been enlarged successfully run sp_helpdevice:

1> sp_helpdevice ameos_device
2> go

Creating additional Sybase devices

The easiest way to add an additional device is to use Sybase Central. Start Sybase Central from your Programs Menu and login to the sqlserver as `sa`. Click on Database Devices and add an additional device. Finally this device should be a default device, which can be set in the properties of this device.

If Sybase Central is not available, isql can be used to add an additional device.

First, set the Sybase environment and start isql

isql -Usa -P<sa Password> -S<ASE server name>
  • in a default Sybase Promo Installationen,the sa password is blank, for OpenAmeos, it is usually "welcome" (see here)
  • ASE Server name is the logical name of the Sybase server (see $SYBASE/interfaces when in doubt)
On the isql command prompt, you then need to first identify the already used device numbers:
1> select distinct vdevno from sysdevices order by vdevno
2> go

All numbers in the list returned by that command are in use, note the next available number and use it as vdevno parameter for the next command which creates the physical device (as a regular file in your filesystem):

1> disk init name = "openameos_device",
2> physname="/opt/sybase/data/openameos_device.dat",
3> vdevno = 4, size = 102400
4> go
  • new_device is the logical name of the new device
  • physname is the full path name of the device (usually, this should be the same path as used for already existing devices)
  • vdevno is the next free device number
  • size is the number of 2K pages for the device, the above example equates to 200MB

To check if the device has been created successfully:

1> sp_helpdevice
2> go
Once you have created a device you should designate it as a default device (there can be many default devices, Sybase then allocates database space automatically):
1> sp_diskdefault "openameos_device", defaulton
2> go

Finally, turn off the master device as default device:

1> sp_diskdefault "master", defaultoff
2> go

Further detailed instructions can be found in the Ameos Administration Guide which ships with OpenAmeos.