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.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.prt

Information about tasks that were active when starting Database Analyzer analysis.

DBAN_USER_TASKS_CMDS_EXECUTED.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_CLUSTER_IO.csv

Information about clustered read and cluster compression operations

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_IOTHREADS.csv

Number and duration of physical write and read operations (I/O threads)

DBAN_LOAD.csv

Accesses and selectivity of SELECT, FETCH, INSERT, UPDATE, and DELETE statements

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_SYNC_OVERVIEW.csv

Information about synchronization mechanisms (such as accesses to/collisions on regions, RW regions, spinlocks)

DBAN_SYS_ALLOCATION.csv

Information about memory allocation on runtime environment memory and system heap allocator

DBAN_TASK_ACTIVITIES.csv

Information about task activities (such as number of SQL statements, number of running user tasks, number of task changes)

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_ACT_DETAIL.csv

Number of user tasks in different task states (states such as running, waiting for log, waiting for I/O, waiting for region access)

DBAN_CACHES_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)