Process detail for locks

This view shows the status of locks held or being requested by Adaptive Server processes as of the end of the most recent sample interval. Each lock is identified by:

If the lock is being requested by the process, the amount of time that this process has waited to acquire the lock and the Process ID of the process that holds the lock are shown. If the process holds the lock, the count of other processes waiting to acquire that lock is shown.

SMC_SIZET process_detail_locks_count = 13;
SMC_DATAITEM_STRUCT process_detail_locks_view[] = {
{ SMC_NAME_LOGIN_NAME,               SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_SPID,                     SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_KPID,                     SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_DB_NAME,                  SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_DB_ID,                    SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_OBJ_NAME,                 SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_OBJ_ID,                   SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_PAGE_NUM,                 SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_LOCK_STATUS,              SMC_STAT_VALUE_SAMPLE },   
{ SMC_NAME_DEMAND_LOCK,              SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_TIME_WAITED_ON_LOCK,      SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_BLOCKING_SPID,            SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_LOCKS_BEING_BLOCKED_CNT,  SMC_STAT_VALUE_SAMPLE }
};