This view shows the CPU use, page I/Os, and current process state for all processes in Adaptive Server.
For each process in the most recent sample interval it shows the:
Login name
Process ID
Kernel Process ID
Current process state.
The view also presents each process’s connect time, total page I/Os and CPU usage time, accumulated since the start of the session.
SMC_SIZET process_activity_count = 7;
SMC_DATAITEM_STRUCT process_activity_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_CONNECT_TIME, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_PAGE_IO, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_CPU_TIME, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_CUR_PROC_STATE, SMC_STAT_VALUE_SAMPLE }
};