Junction points & mount points cause error in Autogrowth MTE

July 30, 2009 at 5:49 pm

[] [] [] [] [] [] [] [] [] [] [] [] []

Symptom
Autogrowth MTE in RZ20 for SQL Server reports there is not enough room to grow
Other terms
Space management, RZ20 for SQL Server, Autogrowth, sap_mon_sqldbfiles, CCMS_MSS_SPACE_MGMT
Reason and Prerequisites
There is a programming error.
In release 620 and 640 this error is in function module CCMS_MSS_SPACE_MGMT.
In release 700 and 710, the stored procedure sap_mon_sqldbfiles needs to be changed.
The use of [...]

RZ20 SQL Server message “No free space in file”

July 11, 2009 at 10:31 am

[] [] [] [] [] [] [] [] [] [] [] [] [] []

Symptom
The AutoGrowth MTE ( CCMS_MSS_SPACE_fileag_ma ) is Red and shows the message “No free space in file”. Autogrow on but not all files can grow, is shown.
Other terms
Autogrowth, SQL Server rz20, CCMS_MSS_SPACE_filepct_ma, sap_mon_sqldbfiles, CCMS_MSS_SPACE_MGMT, Mountpoints, Mount point
Reason and Prerequisites
Changes to RZ20 for SQL Server in 2008 were done in order to make [...]