Solution : https://service.sap.com/sap/support/notes/1027512 (SAP Service marketplace login required)
Summary :
SAP Note elucidates critical updates with the deployment of SAP_BASIS support package SP12, which introduces a pivotal shift from previous database monitoring transactions (ST04, DB02, DB12) to the enhanced DBACOCKPIT. This restructured framework consolidates existing functionalities and offers improved interfacing, alongside extended capabilities to oversee multiple databases. Users must meticulously reconfigure database maintenance schedules initially set through DB13, as these will cease to operate post-update. Furthermore, accessory roles and authorizations are needed for accessing the new system, emphasizing a revamped security model to accommodate the broader monitoring scope. Significant modifications include the division of combined operations into discrete executable steps, ensuring compliance and functional integrity.
Key words :
include activity dba add/modify object s_dbcon, include transaction dbacockpit add/modify object s_admi_fcd, dbacockpit -> space -> history -> table size history -> job configuration, start sql management studio select sql agent, microsoft sql server agent service history log, sap ccms_<sid>_<sid>_update_tabstats, table size history mechanism stores data, add/modify object s_tcode, sql server agent job step, maximum job history log size
Related Notes :
| 1458291 | SolMan 7.1 Database Warehouse & Alerting for MSSQL |
| 1388700 | SQL Server Remote Database Monitor in Solution Manager 400 |
| 1365266 | RCA: Managed System Setup for BOBJ Financial Cons. 10.5-7.5 |
| 1328011 | RCA: Managed System Setup for SAP BPC |
| 1265134 | DBA Cockpit: Connecting a remote database |
| 1227499 | /SDF/MSS_DBCC_CHECKDB returns no results |
| 1178916 | Update_Tabstats job causes system performance problems |
| 1144935 | Report RSMSSDBSZHIST does not show "old" db size history |
| 1094192 | FM /SDF/MSS_GROWING_TABLES returns function module not found |
| 1072066 | DBA Cockpit: New function for DB monitoring |
| 1057855 | DB13/DBACOCKPIT database jobs fail after SP12 |
| 1052909 | DBA Cockpit: Error in delivery of Support Package 12 |
| 1050292 | MSSQL DBACOCKPIT : multiple errors on various screens |
| 1044821 | Conversion overflow on db02 main screen |
| 1044339 | Shortdump OBJECTS_OBJREF_NOT_ASSIGNED in MSSQL DBACOCKPIT |
| 1027146 | Database administration and monitoring using the DBA Cockpit |