Question Re: Sybase DB auto extend - multiple devices in Technology Q&A

Sybase DB auto extend - multiple devices

robert_germanos — Mon, 09 Jan 2023 14:08:57 GMT

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

Re: Sybase DB auto extend - multiple devices

victoria_normand — Thu, 19 Jan 2023 17:36:03 GMT

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.

Re: Sybase DB auto extend - multiple devices

robert_germanos — Fri, 20 Jan 2023 09:41:27 GMT

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.

Re: Sybase DB auto extend - multiple devices

victoria_normand — Fri, 20 Jan 2023 11:38:07 GMT

Hi Robert,

Well actually having the maxsize to 0 is a way to disable the automatic growth, but since the growby is defined this value should not disable the automatic expansion.
I'm not sure which is your SAP Basis version but there was an issue with that, fixed thru SAP Note 2594651 - SYB: DBA Cockpit - Automatic Database Expansion: Wrong interpretation of inputted 'maxsize' value for segment/device. Can you check it it is implemented on your system ?

Best regards,
Victoria.

Re: Sybase DB auto extend - multiple devices

robert_germanos — Fri, 20 Jan 2023 11:50:33 GMT

This note is already implemented. In dbacockpit i removed the auto expand for the 2 data files and then activated it again but i did not specify a maxsize, when i checked it on DB the maxsize is no longer there. The only thing i need to check now is the threshold as to when the auto extend happens. Below is the current settings

type name segment item value status

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

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

database default (all) growby 0 disabled

device data_001 (n/a) growby 5120M enabled

device data_002 (n/a) growby 5120M enabled

device data_003 (n/a) growby 5120M enabled

device default (n/a) growby 0 enabled

Re: Sybase DB auto extend - multiple devices

victoria_normand — Fri, 20 Jan 2023 12:09:07 GMT

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.