SAP Basis Tech Supports

Symptom

This note is an overview note about problems with the database analyzer. It lists notes that are often helpful if you experience problems with the database analyzer. This note briefly describes the contents of each of these notes.
The list does not claim to be conclusive or complete.

Other terms

DbAnalyzer, database analyzer

Reason and Prerequisites

Problems with the database analyzer are caused by a number of reasons. To eliminate the errors more quickly, check the notes in this list.

Solution

Note and short text

1311806 : DBAnalyzer: Error “-9806″, liveCache 7.6.05 build 12

Platform: all
Affected: liveCache Versions 7.6.05 build 12
Reason: Error when accessing table DBAN_OMS_VERSIONS
The DB analyzer does not start or reports an “Ignorable SQL error”.
Solution: Import the attached
configuration files.

1114626 : DBAnalyzer: Statistics cannot be displayed using DB50/LC10

Platform: all
Affected: MaxDB/liveCache Version 7.6.03 Build 09 (exclusively)
Reason: Error in the program DBMServer
Solution: Install Version 7.6.03 Build 10 or higher.

1102727 : DBAnalyzer does not start terminates with error “-3016″.

Platform: all
Affected: MaxDB/liveCache Versions 7.6.02, 7.6.03, and 7.7
Reason: Error when accessing table HISTORYINFO
Solution: Import the configuration files attached to the note

1052280 : DBAnalyzer: high CPU consumption, slow data collection

Platform: all
Affected: liveCache versions 7.6 and 7.7
Reason: There are too may entries in the system table.
READERWRITERLOCKSTATISTICS
Solution: Import the configuration files attached to the note

1071912 : DBAnalyzer warning: No actual system tables for Kernel

Platform: all
Affected: All MaxDB/liveCache versions of Version 7.6.02
Reason: Error in configuration file dbanalyzer76.cfg
Solution: Import the configuration files attached to the note

794397 : Database analyzer data is displayed for the current day only

Platform: all
Affected: all MaxDB/liveCache versions
Reason: too many entries in the directory
/sapdb/data/wrk//analyzer
Solution: Move all directories that are older
than 6 months.

748582 : DBAnalyzer crashes during disconnection

Platform: Windows
Reason: Microsoft Data Access Components (MDAC) < 2.7
Solution: Installation of the latest MDAC version

981599 : MaxDB/liveCache crash when system accesses FILES table

Platform: All
Affected: MaxDB/liveCache versions 7.6. and 7.7
Reason: The instance crashes when the system accesses the FILES table.
Solution: Import the configuration files attached to

955201 : DBAnalyzer does not start "OLD_CONSISTENTVIEWS_AR"

Platform: All
Affected: liveCache Version 7.6.0 Build 29/30 and 7.7 < SP 02
Reason: There is an error in the configuration file.
Solution: Import the configuration files attached to

879601 : Problems with the DBAnalyzer < 7.5.00 Build 30 on AIX

Platform: AIX
Affected: MaxDB/liveCache Version 7.5.00 <= Build 30
Reason: SELECT on the MACHINEUTILIZATION table
Solution: Import the configuration files attached to

841933 : Using the DBAnalyzer on SUN/Linux: "too many open files"

Platform: SUN and Linux
Affected: MaxDB/liveCache Version 7.5.00 <= Build 25
Reason: File handle leak on "/devices/pseudo/kstat@0:kstat"
Solution: Import the attached
configuration files.

978121 : DBAnalyzer does not start in LC10/DB50

Platform: UNIX
Affected: liveCache Version 7.5.00 < Build 18
Affected: MaxDB/liveCache Version 7.5.00 <= Build 20
Reason: /bin is not part of the PATH variable
Solution: Start x_server in the relevant environment.

806232 : Error -9111 when you start DBAnalyzer 7.5.00 < Build 18

Platform: all
Affected: liveCache Version 7.5.00 < Build 18
Reason: -9111 with SELECT * FROM OMS_HEAP_STATISTICS_OV
Solution: diagnose optimize join onephase off

754140 : DBAnalyzer: Status cannot be displayed

Platform: all
Affected: all MaxDB/liveCache versions
Reason: User SUPERDBA was created as an EXCLUSIVE user
Solution: sql_execute ALTER USER SUPERDBA NOT EXCLUSIVE

739985 : Error -4008 when starting the database analyzer

Platform: all
Affected: MaxDB/liveCache Version 7.4.03 Build 28
Reason: User SUPERDBA saved in lower case
Solution: Convert user name to upper case

953689 : DBAnalyzer stops after message -9806 Invalid output value

Platform: All
Affected: liveCache Version 7.4.2 Build < 29
Reason: Temporarily invalid column value
Solution: Extend the IGNOREERROR list

751975 : “Formatting error” when displaying TASK_IO in LC10

Platform: All
Affected: liveCache Version 7.4.2 Build < 29
Reason: Client software on application server is too old
Solution: Install new liveCache Client software.

701059 : Error -4004 when starting the database analyzer

Platform: all
Affected: all MaxDB/liveCache versions
Reason: Parameter INSTANCE_TYPE has not been maintained.
Solution: Set the parameter INSTANCE_TYPE.

739216 : Error in the expert analysis of bottlenecks (LC10, DB50)

Platform: All
Affected: Various SAP Basis Support Packages
Solution: New SAP Basis Support Package/correction instructions

944393 : DBAnalyzer & data collector do not start automatically

Platform: All
Affected: Various SAP Basis Support Packages
Solution: New SAP Basis Support Package/correction instructions

783653 : Analysis of the bottleneck analysis returns no data

Platform: All
Affected: Various SAP Basis Support Packages
Solution: New SAP Basis Support Package/correction instructions

530394 : Using the Database Analyzer for bottleneck analysis
657365: : Detecting database bottlenecks with the Database Analyzer

Platform: All
Affected: Various SAP Basis Support Packages
Solution: Description of availability in various SAP Support Packages

1165577 : DBAnalyzer warning: Long, open, consistent views for T0

Platform: All
Affected: liveCache Version 7.5
Reason: This is due to an error in the liveCache kernel that can be ignored.
Solution: Import the attached
configuration files.