Sybase DB auto extend - multiple devices

[robert_germanos]

Hi

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

[victoria_normand · Accepted solution]

Hi Robert,
The problem is the maxsize = 0 defined for SID_data_002 and SID_data_003. This maxsize indicate until which size the auto expansion will be done for the segment and stopped once reached.
You may refer to this KBA https://launchpad.support.sap.com/#/notes/2563763

Best regards,
Victoria.

[robert_germanos · Accepted solution]

Hi Victoria,

Thank you for the reply, how do i disable the maxsize? On the data001 it is disabled, i would like set data 2 and 3 the same as data 1.