shrink database device
I know that with Sybase ASE 15.7 you can shrink log space with the following command (example for the saptools):
alter database saptools log off logsaptools_1 = '200M'
I have tried it out and it works fine.
Is there also a possibility to shrink the device logsaptools_1 afterwards?
Tilman Model-Bosch replied
Dear Mr Hoerner
Shrink database is supported for SAP Netweaver systems if ASE is 15.7 SP110 or higher.
Further important information are available in SAP notes
1943890 - SYB: Release information for SAP Sybase ASE 18.104.22.168 with SAP Business Suite
2000203 - SYB: Release information for SAP ASE 22.214.171.124 with SAP Business Suite
(SAP System must be offline, full database backup must be performed after wards)