Skip to Content
Jan 09 at 02:08 PM

Sybase DB auto extend - multiple devices



I have a database that 3 data files, only one was created during the installation of SAP and the DB, the additional 2 (data_002 and data_003) were added later. I have automatic DB extension running on the data_001 device and it was setup during installation and it is working. On the additional 2 devices auto extend is active but it is not working. I activated them in dbacockpit. Below is the output of exec sp_dbextend 'list'

type name segment item value status

-------------------------------- ------------------------------------------------ ---------------------------- ---------------------------- -------------------- --------------------------------

feature server-wide (n/a) (n/a) (n/a) enabled

database default (all) growby 0 disabled

device SID_data_001 (n/a) growby 5120M enabled

device SID_data_002 (n/a) maxsize 0 enabled

device SID_data_002 (n/a) growby 5120M enabled

device SID_data_003 (n/a) maxsize 0 enabled

device SID_data_003 (n/a) growby 5120M enabled

device default (n/a) growby 0 enabled

Can someone please tell me if there is anything additional that needs to be done to get this to work?Thank you