Checking Exclusive Lockwaits (Informix) (SAP Library

Checking Exclusive Lockwaits (Informix)

Use

You can use the detailed database analysis in the SAP/Informix database monitor to check the following information on lockwaits:

Lock Holder	Lock Waiter
Database user name	Database user name
Host name	Host name
Process ID (PID)	Process ID (PID)
Session ID (SID)	Session ID (SID)
ABAP program name	Name of the locked table
Work process time	ABAP program name
Status information	Work process time
SAP user name	Wait period
	How long the lock has already been held
	SAP user name

The host name and PID enable you to identify holder and waiter SAP work processes.

Procedure

Choose Tools ® CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity ® Detail Analysis Menu ® Exclusive Lockwaits.

Choose SQL Statement to display the most recent SQL statement from holder or waiter (not necessarily the one causing the lock for the holder, since the holder might have gone on to other statements within one logical unit of work).

Note

If there is no work process left for the lock monitor itself, use onstat instead to determine which process is holding the lock. Refer to Analyzing Lockwaits with onstat (Informix).