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 [...]
July 23, 2009 at 8:48 am
Symptom
This note is valid for the DBA Cockpit on SAP with the Oracle database.
The SQL Command Editor in Basis Releases 7.00 and 7.10 cannot process tables that have a namespace entry. In an SQL statement, if you use //
tables, such as
select * from “//
”
(the double quotation marks are important),
(even though the table exists [...]
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 [...]
July 3, 2009 at 12:42 am
Symptom
Deploying Microsoft JDBC Driver for SQL Server (sqljdbc.jar) deploys an empty jar file in /bin/ext/ directoryOther terms
Microsoft JDBC driver deployment, empty jar, sqljdbc.jar, SQL Server
Reason and Prerequisites
Version 1.2 of the Microsoft JDBC Driver (583.286 bytes) contains besides the classes implementing the JDBC connectivity two additional files, namely:
sqljdbc.jar (0 bytes in size)sqljdbc.jar.old (287 KBs [...]