Basis Errors and Solutions

Symptom
In the Web browser-based version of the DBA Cockpit, you are trying to set up the WLM event monitors. Thereby, you receive one of the following SQL-errors.
DB2 V9.5:
SQL0264N Partitioning key cannot be added or dropped because table resides in a table space defined on the multi-node nodegroup “SAPEVENTMONGRP”. SQLSTATE=55037
DB2 V9.7:
SQL0612N “PARTITION_KEY” is a [...]

Symptom
In the DBA Cockpit, you choose Performance -> Lockwaits and Deadlocks. Thereby, you run into an infinite loop and no screen is displayed.
Other terms
DBACOCKPIT, ST04, DB6COCKPIT
Reason and Prerequisites
Program error
Solution
Import the appropriate Support Package as follows:
SAP Basis 7.00 > Basis Support Package 20SAP Basis 7.01 > Basis Support Package 5SAP Basis [...]

Symptom
When you use the “Backup Logs” or “DBA Logs” function in the DBA Cockpit and change the selected remote system, the detail display of the log may not work and the system may issue message BR0252E.
Other terms
DBA, database administration, DBA Cockpit, Oracle, DBACOCKPIT, backup, logs, DBA logs, DB12, DB14
Reason and Prerequisites
This problem is caused [...]

Symptom
The main screen generated by DB02->Tablespaces->Detail Analysis shows
zero size and free space for temporary tablespaces.
Other terms
DBACOCKPIT, DB02N, PSAPTEMP, dba_temp_files
Reason and Prerequisites
This is a bug. The values are not calculated during runtime, unfortunately.
Solution
Apply the attached correction.

Symptom
This SAP Note is used as a collection of corrections for the DBA Cockpit in SAP Basis Release 7.01 and SAP Basis Release 7.11.
This SAP Note includes other required SAP Notes that are regularly extended and updated. Therefore, you can use this SAP Note in transaction SNOTE as a generic update mechanism for [...]

Symptom
This SAP Note is used as a collection of corrections for the DBA Cockpit in SAP Basis Release 7.00 and SAP Basis Release 7.10.
This SAP Note includes other required SAP Notes that are regularly extended and updated. Therefore, you can use this SAP Note in transaction SNOTE as a generic update mechanism for [...]

Symptom
When comparing segment history information of Oracle database based systems between ST14 and DB02N (SAP_BASIS 620-700) or DBACOCKPIT/DB02 (700 SP12+) you notice differences in size and further measures.
Other terms
DBACockpit Oracle, DB02 Oracle
Reason and Prerequisites
With SAP_BASIS 620 a new history collector for Oracle was introduced. Please Refer to SAP Note 868063 for details. [...]