To specify the log file directory, you can use the command dbanalyzer -o <outputdir>. When activated, Database Analyzer saves the analysis data that is collected in the course of a day, as well as other log files, in the /YYYYMMDD subdirectories of the log file directory.
If you start Database Analyzer on the computer on which the database is installed, you do not need to specify the option -o. When activated, Database Analyzer saves the log files in the analyzer subdirectory of the database run directory.
DBAN.prt/DBAN<monitor_class>.prt
The file DBAN.prt contains the following information:
Information about the configuration and data relevant to the performance of the database
Bottlenecks discovered by Database Analyzer
The DBAN<monitor_class>.prt files contain information about SQL statements and tasks which were relevant during snapshots.
I |
Information |
General information, such as the number of executed commands |
W1 to W3 |
Warning levels 1 to 3 |
Bottleneck warnings with low, medium, and high priority |
E |
Emergency |
Critical problems, such as an imminent database crash |
DBAN_<monitor_class>.csv
These files contain all analysis data. They allow you to check the runtime behavior.
There is one file for each monitor class (analysis area). You can use Microsoft Excel to open these files.
Log Files for the Database Analyzer Program
If problems with the Database Analyzer program occur, the system writes messages to the following log files:
DBAN.err: Error file
DBAN.inf: Runtime information for the Database Analyzer that was most recently started
This file also contains information for identifying the database session ( DBAN.sid file) and for identifying the processes ( DBAN.pid file).
List of All Log Files
Log File |
Description |
---|---|
DBAN.err |
Error file |
DBAN.inf |
Current information about the Database Analyzer most recently started |
DBAN.prt |
Records Database Analyzer messages, including analysis rules and the current values that caused these messages More information: Database Analyzer Messages |
DBAN_RUNNING_COMMANDS.prt |
List of SQL statements that were active when starting Database Analyzer analysis. The SQL statements are logged only if the command monitor was enabled. |
DBAN_SHOW_ACTIVE_TASKS.prt |
Information about tasks that were active when starting Database Analyzer analysis |
DBAN_TASK_SUSPENDS.prt |
Information about all task suspend reasons |
DBAN_UKT_CPU_UTILIZATION.prt | Information about CPU utilization per UKT |
DBAN_USER_TASKS_ACTIVITIES.prt |
List/information about user tasks that executed at least one SQL statement during the last analyses |
DBAN_ANALYZER_TASK_STAT.csv |
Information about the number of SQL statements, accesses to critical sections, dispatches, and physical reads of Database Analyzer task. This Database Analyzer information helps to identify the workload generated due to data collection. |
DBAN_BACKUP.csv |
Number and duration of physical write and read operations during data and/or log backups |
DBAN_CACHES.csv |
Successful and unsuccessful accesses to caches, and also hit rates |
DBAN_CATALOG_CACHE.csv |
Successful and unsuccessful accesses to catalog cache, and also hit rate |
DBAN_CLUSTER_IO.csv |
Information about clustered read and cluster compression operations |
DBAN_COMMIT_STAT.csv |
Statistics about COMMIT and ROLLBACK statements (number, time, I/O wait time) |
DBAN_COMMUNICATION.csv | Client communication statistics |
DBAN_CPU_UTILIZATION.csv |
Information about the system load: CPU usage in user and system mode, broken down by system, database, and time in idle state. |
DBAN_FILLING.csv |
Fill level of the database (for example, the size of the data volumes, number of permanently and temporarily used pages) |
DBAN_GC.csv |
Information about garbage collector task activities: how often they were active, number of deleted and history objects, and number of physical I/O operations. |
DBAN_IO.csv |
Read and write operations to cache pages and data pages |
DBAN_IO_PREFETCH.csv |
Statistics about prefetching (requests, ignored requests, LOB requests) |
DBAN_IOTHREADS.csv |
Number and duration of physical write and read operations (I/O threads) |
DBAN_JOIN_STAT.csv |
Statistics about JOIN statement (number, access kind, optimize kind) |
DBAN_LOAD.csv |
Accesses and selectivity of SELECT, FETCH, INSERT, UPDATE, and DELETE statements |
DBAN_LOCKS.csv | Information about lock statistics (table locks, row locks, lock collision, and so on) |
DBAN_LOGGING.csv |
Number of log pages written, fill level of the log queue, and so on |
DBAN_OVERVIEW.csv |
Overview of the most important information from the log files of Database Analyzer |
DBAN_REGIONS.csv |
Information about accesses to critical sections |
DBAN_RW_LOCKS.csv |
Information about accesses to critical sections (reader-writer locks) |
DBAN_SHARED_SQL.csv |
Statistics about shared SQL (hit rates of the prepare cache, command cache, cleanup, unload) |
DBAN_SPINLOCKS.csv |
Information about accesses to critical sections (spinlocks) |
DBAN_STRATEGY_INDEX.csv |
Accesses and selectivity for index searches |
DBAN_STRATEGY_PRIMKEY.csv |
Accesses and selectivity for PRIMARY KEY searches |
DBAN_STRATEGY_SCANS.csv |
Accesses and selectivity for INDEX SCAN and TABLE SCAN searches |
DBAN_SV.csv |
Information about server tasks activities (such as number/duration of I/O, dispatches, suspends) |
DBAN_SYS_ALLOCATION.csv |
Information about memory allocation on runtime environment memory and system heap allocator |
DBAN_TASK_DISPATCHES.csv |
Information about task dispatches |
DBAN_TASK_IO.csv |
Number and duration of physical writes and reads from perspective of the log writer, the user task, and the pager |
DBAN_TASK_STATES.csv |
Number and execution duration of processed statements Number and wait duration of the task states Vsuspend, Vwait, sleep |
DBAN_TRANSACTIONS.csv |
Number of SQL statements and procedure calls, PREPARE, EXECUTE, COMMIT, and ROLLBACK statements, subtransactions, TIMEOUTS caused by locks, and conversions of row locks to table locks ( Lock List Escalations) |
DBAN_USER_TASK_STATES.csv |
Number of user tasks in different task states (states such as running, waiting for log, waiting for I/O, waiting for region access) |
Log File |
Description |
---|---|
DBAN_OMS_ROUTINES_EXECUTED.prt |
Information about LCApps routines that have been executed when starting Database Analyzer analysis |
DBAN_CACHE_OCCUPANCY.csv |
Cache load and occupancy (proportion of OMS, SQL, and history pages in the data cache) |
DBAN_OMS.csv |
Number of calls by DB procedures, dereferences, deleted objects, history accesses |
DBAN_OMS_CONTAINER.csv |
Information on class containers (such as number of classes, occupancy, number of free pages) |
DBAN_OMS_HEAP.csv |
Information on the OMS heap (such as occupancy, current size, collisions) |
DBAN_OMS_VERSIONS.csv |
Information on OMS versions (such as number and age of versions used) |
Database Administration, Log Files