SAP ABAP Table SALDB6AL (DB2 Database Alert Threshold)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-CNF-GRP (Application Component) Workload Balancing and Group Management
     ⤷ SRZL (Package) Computing Center Management System

Basic Data

Table Category	INTTAB	Structure
Structure	SALDB6AL	Table Relationship Diagram
Short Description	DB2 Database Alert Threshold

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ALRTINTVL	☐	ALALRTINTL	INT1	INT1	3	0	Database Alert Monitor Refresh Interval: multiples of 10s
2	NUMSQLSTMT	☐	ALNUMSQL		INT4	10	0	SQL Statements per 10 secs interval.
3	ROLLBACKLM	☐	ALROLLBACK		INT4	10	0	User Rollbacks per Refresh Interval
4	LOCKWAIT	☐	ALLOCKWAIT		INT4	10	0	Waits on Locks
5	AVWAITTM	☐	ALAVGWAIT		INT4	10	0	Average wait time (in ms)
6	SORTTOTAL	☐	ALSORTTOT		INT4	10	0	Total sorts
7	SORTAVG	☐	ALSORTAVG		INT4	10	0	Average sorts
8	SORTNUM	☐	ALSORTNUM		INT4	10	0	Number of sorts
9	READSLOG	☐	ALREADSLOG		INT4	10	0	Logical reads
10	READSLM	☐	ALREADS		INT4	10	0	Physical Reads per Refresh Interval
11	BUFPOOLW	☐	ALBUFWRITE		INT4	10	0	Buffer Pool Writes
12	DATABUFFLM	☐	ALDBBUFF		INT4	10	0	Data Buffer Hit Ratio in %
13	LCKUSEDLM1	☐	ALLOCKLM1		INT4	10	0	Locks Used % Yellow Alert
14	UPDCHECK	☐	UPDCHECK		INT4	10	0	Update stats last check days
15	UPDRUN	☐	UPDRUN		INT4	10	0	Update stats last run days
16	BACKUPAGE	☐	ALBACKUPAG	INT1	INT1	3	0	Most Recent Backup Age Allowed
17	ARCHIVEREM	☐	ALARCHIVE		INT4	10	0	Archive Remaining Space in KB

History

Last changed by/on	SAP	20130604
SAP Release Created in