SAP ABAP Class CL_DB6_DEADLOCK_EVMON (DB6: abstraction of a DB2 Event Monitor)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)
Properties
Class CL_DB6_DEADLOCK_EVMON  
Short Description DB6: abstraction of a DB2 Event Monitor    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package STU6   DB6: Performance-Monitor (UNIX/Windows) 
Created 20071010   SAP 
Last change 20110908   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 ABAP Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
2 DB6CC Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
3 DB6CI Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Class CL_DB6_DEADLOCK_EVMON has no interface implemented.
Friends
Class CL_DB6_DEADLOCK_EVMON has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 AGENT_BUFFER Static Attribute Private Type reference (TYPE) DB6CI_DB6PMDLTR_TAB 20071010
2 CONNHEADER_BUFFER Static Attribute Private Type reference (TYPE) DB6CI_DB6PMDLCH_TAB 20071010
3 DBCNAME Static Attribute Private Type reference (TYPE) DBCON_NAME Logical name for a database connection 20071010
4 DEADLOCK_BUFFER Static Attribute Private Type reference (TYPE) DB6CI_DB6PMDLOV_TAB 20071010
5 EVMON_NAME Constant Public Type reference (TYPE) STRING 'DB6_DLMON_HISTVALS' 20071010
6 EXISTS Static Attribute Private Type reference (TYPE) ABAP_BOOL 20071010
7 INSTANCE Static Attribute Private Object reference (TYPE REF TO) CL_DB6_DEADLOCK_EVMON DB6: abstraction of a DB2 Event Monitor 20071010
8 LOCK_BUFFER Static Attribute Private Type reference (TYPE) DB6CI_DB6PMDLLK_TAB 20071010
9 NAV_REF Static Attribute Private Object reference (TYPE REF TO) CL_DB6_TREE_NAVIGATOR CL_DB6_TREE_NAVIGATOR 20071010
10 STMTHIST_BUFFER Static Attribute Private Type reference (TYPE) DB6CI_DB6PMDLSH_TAB 20071010
11 STMTVALS_BUFFER Static Attribute Private Type reference (TYPE) DB6CI_DB6PMDLSV_TAB 20071010
Methods
# Method Level Visibility Method type Description Created on
1 CONSTRUCTOR Instance method Public Constructor do not use! use GET_INSTANCE instead 20071010
2 CREATE_EVMON Instance method Public Method create event monitor (deadlock with details history values) 20071010
3 DELETE_OBSOLETE_DATA Instance method Private Method delete prematurely dumped data 20071010
4 DROP_EVMON Instance method Public Method drops the SAP deadlock event monitor 20071010
5 EVMON_EXISTS Instance method Private Method check wether an SAP event monitor is already existing 20071010
6 EXECUTE_MODIFY Instance method Private Method executes a DML statement directly 20071010
7 FLUSH Instance method Public Method flush event monitor 20071010
8 GET_AGENT Instance method Public Method get specific agent (buffered) 20071010
9 GET_AGENTS Instance method Public Method get agents involved in deadlock (DLMON_DLCONN) 20071010
10 GET_AGENTS_FOR_DLK Instance method Public Method get involved agents for specific deadlock (buffered) 20071010
11 GET_AGENT_ID Instance method Public Method get specific agent (buffered) 20071010
12 GET_BUFFERSIZE Instance method Private Method get Monitor BUFFERSIZE value 20071010
13 GET_CONNECTION_HEADERS Instance method Public Method get connection headers (DLMON_CONNHEADER) 20071010
14 GET_CONN_HEADER_FOR_AGENT Instance method Public Method get connection header for given agent (buffered) 20071010
15 GET_CONN_HEADER_FOR_APPL Instance method Public Method get connection header for given appl. ID (buffered) 20071010
16 GET_CONTROL_INFO Instance method Public Method get event monitor control information 20071010
17 GET_DEADLOCK Instance method Public Method get deadlock data (buffered) 20071010
18 GET_DEADLOCKS Instance method Public Method get all registered deadlocks (DLMON_DEADLOCK) 20071010
19 GET_INSTANCE Static method Public Method get Event Monitor Instance (Singleton) 20071010
20 GET_LOCKS Instance method Public Method get locks held for given deadlock (DLMON_DLLOCKS) 20071010
21 GET_LOCKS_FOR_AGENT Instance method Public Method get locks held by single agent (buffered) 20071010
22 GET_MONITOR_STATE Instance method Public Method is monitor running (state=1) or not (state=0) 20071010
23 GET_START_TIME Instance method Public Method get event monitor start time 20071010
24 GET_STATEMENTS_FOR_AGENT Instance method Public Method get statement history for given agent (buffered) 20071010
25 GET_STATEMENT_HISTORY Instance method Public Method get statement history for given deadlock (DLMON_STMTHIST) 20071010
26 GET_STATEMENT_VALUES Instance method Public Method get statement history for given deadlock (DLMON_STMTHIST) 20071010
27 GET_VALUES_FOR_STATEMENT Instance method Public Method get statement history for given agent (buffered) 20071010
28 IS_EXISTING Instance method Public Method returns wether deadlock monitor is existing on the database 20071010
29 REFRESH_BUFFERS Instance method Public Method reset event monitor and all of its tables 20071010
30 RESET Instance method Public Method reset event monitor and all of its tables 20071010
31 START Instance method Public Method set event monitor state to 1 (running) 20071010
32 STOP Instance method Public Method set event monitor state to 0 (stopped) 20071010
Events
Class CL_DB6_DEADLOCK_EVMON has no event.
Types
Class CL_DB6_DEADLOCK_EVMON has no local type.
Method Signatures

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CONNECTION Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20071010
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method CREATE_EVMON Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing BUFFERSIZE Call by reference Type reference (TYPE) I 20071010
2 Importing TSPNAME Call by reference Type reference (TYPE) DB6TSPNAME DB6: Tablespace Name 20071010
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method DELETE_OBSOLETE_DATA Signature

Method DELETE_OBSOLETE_DATA on class CL_DB6_DEADLOCK_EVMON has no parameter.
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method DROP_EVMON Signature

Method DROP_EVMON on class CL_DB6_DEADLOCK_EVMON has no parameter.
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method EVMON_EXISTS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning EXISTS Value transfer Type reference (TYPE) ABAP_BOOL 20071010
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method EXECUTE_MODIFY Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CON Call by reference Object reference (TYPE REF TO) CL_SQL_CONNECTION Database Connection 20071010
2 Importing STMT Call by reference Type reference (TYPE) STRING 20071010
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Ausnahmeklasse für SQL Fehler 20071010

Method FLUSH Signature

Method FLUSH on class CL_DB6_DEADLOCK_EVMON has no parameter.
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method GET_AGENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning AGENT Value transfer Type reference (TYPE) DB6PMDLTR DB6 CCMS: Event Monitor - Deadlock involved transactions 20071010
2 Importing AGENT_ID Call by reference Type reference (TYPE) DB6PMDLTR-AGENT_ID 20071010
3 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010

Method GET_AGENT on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_AGENTS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning AGENTS Value transfer Type reference (TYPE) DB6CI_DB6PMDLTR_TAB 20071010

Method GET_AGENTS on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_AGENTS_FOR_DLK Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning AGENTS Value transfer Type reference (TYPE) DB6CI_DB6PMDLTR_TAB DB6 CCMS: Event Monitor - Deadlock involved transactions 20071010
2 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010

Method GET_AGENTS_FOR_DLK on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_AGENT_ID Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning AGENT_ID Value transfer Type reference (TYPE) DB6PMDLTR-AGENT_ID DB6 CCMS: Event Monitor - Deadlock involved transactions 20071010
2 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010
3 Importing PARTICIPANT_NO Call by reference Type reference (TYPE) DB6PMDLTR-PARTICIPANT_NO 20071010

Method GET_AGENT_ID on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_BUFFERSIZE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning BUFFERSIZE Value transfer Type reference (TYPE) I 20071010
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method GET_CONNECTION_HEADERS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning CONNHEADERS Value transfer Type reference (TYPE) DB6CI_DB6PMDLCH_TAB 20071010

Method GET_CONNECTION_HEADERS on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_CONN_HEADER_FOR_AGENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing AGENT_ID Call by reference Type reference (TYPE) DB6PMDLTR-AGENT_ID 20071010
2 Returning CONNHEADER Value transfer Type reference (TYPE) DB6PMDLCH DB6 CCMS: Event Monitor: Connection Header 20071010

Method GET_CONN_HEADER_FOR_AGENT on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_CONN_HEADER_FOR_APPL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing APPL_ID Call by reference Type reference (TYPE) DB6PMDLTR-APPL_ID 20071010
2 Returning CONNHEADER Value transfer Type reference (TYPE) DB6PMDLCH DB6 CCMS: Event Monitor: Connection Header 20071010

Method GET_CONN_HEADER_FOR_APPL on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_CONTROL_INFO Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning CONTROL_INFO Value transfer Type reference (TYPE) DB6CI_DB6PMDLCTL_TAB 20071010

Method GET_CONTROL_INFO on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_DEADLOCK Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning DEADLOCK Value transfer Type reference (TYPE) DB6PMDLOV DB6 CCMS: Event Monitor - Deadlock Overview 20071010
2 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010

Method GET_DEADLOCK on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_DEADLOCKS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning DEADLOCKS Value transfer Type reference (TYPE) DB6CI_DB6PMDLOV_TAB 20071010

Method GET_DEADLOCKS on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_INSTANCE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing CONNECTION Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20071010
2 Returning EVMON Value transfer Object reference (TYPE REF TO) CL_DB6_DEADLOCK_EVMON DB6: abstraction of a DB2 Event Monitor 20071010
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: action controller has inconsistent state 20071010

Method GET_LOCKS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010
2 Returning LOCKS Value transfer Type reference (TYPE) DB6CI_DB6PMDLLK_TAB DB6 CCMS: Event Monitor - held Locks 20071010

Method GET_LOCKS on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_LOCKS_FOR_AGENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010
2 Returning LOCKS Value transfer Type reference (TYPE) DB6CI_DB6PMDLLK_TAB DB6 CCMS: Event Monitor - held Locks 20071010
3 Importing PARTICIPANT_NO Call by reference Type reference (TYPE) DB6PMDLTR-PARTICIPANT_NO 20071010

Method GET_LOCKS_FOR_AGENT on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_MONITOR_STATE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning STATE Value transfer Type reference (TYPE) I 20071010
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method GET_START_TIME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning TSTAMP Value transfer Type reference (TYPE) DB6CI_STRUC_TSTAMP 20071010
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method GET_STATEMENTS_FOR_AGENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010
2 Importing PARTICIPANT_NO Call by reference Type reference (TYPE) DB6PMDLTR-PARTICIPANT_NO 20071010
3 Returning STMT_HISTORY Value transfer Type reference (TYPE) DB6CI_DB6PMDLSH_TAB 20071010

Method GET_STATEMENTS_FOR_AGENT on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_STATEMENT_HISTORY Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010
2 Returning STMT_HISTORY Value transfer Type reference (TYPE) DB6CI_DB6PMDLSH_TAB 20071010

Method GET_STATEMENT_HISTORY on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_STATEMENT_VALUES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010
2 Returning STMT_VALUES Value transfer Type reference (TYPE) DB6CI_DB6PMDLSV_TAB 20071010

Method GET_STATEMENT_VALUES on class CL_DB6_DEADLOCK_EVMON has no exception.

Method GET_VALUES_FOR_STATEMENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing DEADLOCK_ID Call by reference Type reference (TYPE) DB6PMDLOV-DLK_ID 20071010
2 Importing PARTICIPANT_NO Call by reference Type reference (TYPE) DB6PMDLTR-PARTICIPANT_NO 20071010
3 Importing STMT_HISTORY_ID Call by reference Type reference (TYPE) DB6PMDLSV-STMT_HISTORY_ID 20071010
4 Returning STMT_VALUES Value transfer Type reference (TYPE) DB6CI_DB6PMDLSV_TAB 20071010

Method GET_VALUES_FOR_STATEMENT on class CL_DB6_DEADLOCK_EVMON has no exception.

Method IS_EXISTING Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning EXISTING Value transfer Type reference (TYPE) ABAP_BOOL 20071010

Method IS_EXISTING on class CL_DB6_DEADLOCK_EVMON has no exception.

Method REFRESH_BUFFERS Signature

Method REFRESH_BUFFERS on class CL_DB6_DEADLOCK_EVMON has no parameter.
Method REFRESH_BUFFERS on class CL_DB6_DEADLOCK_EVMON has no exception.

Method RESET Signature

Method RESET on class CL_DB6_DEADLOCK_EVMON has no parameter.
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method START Signature

Method START on class CL_DB6_DEADLOCK_EVMON has no parameter.
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010

Method STOP Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SKIPDELETE Call by reference Type reference (TYPE) ABAP_BOOL 20071010
# Exception Resumable Description Created on
1 CX_DBA_ADBC DBA Cockpit: ADBC Errors 20071010
History
Last changed by/on SAP  20110908 
SAP Release Created in 711