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 126.96.36.199 with SAP Business Suite
2000203 - SYB: Release information for SAP ASE 188.8.131.52 with SAP Business Suite
(SAP System must be offline, full database backup must be performed after wards)