Sybase DB auto extend - multiple devices

[#1]

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]

Hi Robert,
Ok so that is because NULL was used instead of 0 for maxsize which was the expected fix of that SAP Note.
And the list output should fine now.
I'm not sure to understand why that was not in that way previously but it is clear that deactiving and reactivating auto-expansion allowed to have the correct sp_dbextend statement applied. This should work now, let us know!
Best regards,
Victoria.