beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 106

background image

NOTE:

Diagnostic information displayed by the System Offender tab is intended for use by

HP support. If you have questions about an offending process, contact your HP support
representative.

Description

Field

The segment number. A Neoview platform consists of up to 16 segments with each
segment containing up to 16 processing nodes.

SEGMENT

The processing node.

CPU

The process identification number (PIN). The PIN is an unsigned integer that identifies
a process in a processing node.

PIN

The execution priority of the process (an integer in the range from 1 through 199 (1
is lowest priority)).

PROCESS PRIORITY

The type of process, the display of which is controlled by the Process Type parameter
in the Alter Offender Parameters dialog box. For example, if the current Process
Type

is set to SQL, the process types can be MXUDR, MXESP, MXCI, and MXOSRVR.

If the Process Type is set to ALL, any process type can be displayed. For information
about setting the process type, see

“Use the Alter Offender Parameters Dialog Box”

(page 109)

.

PROCESS TYPE

The current CPU utilization from 0 to 100%.

CPU USAGE PERCENT*

The current memory usage in megabytes (MB).

MEMORY USAGE MB*

A name that is assigned to a process when the process is created. A process name
uniquely identifies a process or process pair in a system. A process name consists of
a dollar sign ($) followed by one to five alphanumeric characters, the first of which
must be alphabetic.

PROCESS NAME

The name of the program.

PROGRAM NAME*

The number of the segment on which the parent process is running.

PARENT SEGMENT

The processing node in which the parent process is running.

PARENT CPU

The process identification number (PIN) of the parent process. The PIN is an unsigned
integer that identifies a process in a processing node.

PARENT PIN

The execution priority of the parent process (an integer in the range from 1 through
199 (1 is lowest priority)).

PARENTPROCESSPRIORITY

The type of parent process, the display of which is controlled by the Process Type
parameter in the Alter Offender Parameters dialog box. For example, if the current
Process Type

is set to SQL, the process types can be MXUDR, MXESP, MXCI, and

MXOSRVR. If the Process Type is set to ALL, any process type can be displayed.
For information about setting the process type, see

“Use the Alter Offender Parameters

Dialog Box” (page 109)

.

PARENT PROCESS TYPE

A name that is assigned to a parent process when the process is created. Includes the
segment name. A process name uniquely identifies a process or process pair in a
system. A process name consists of a dollar sign ($) followed by one to five
alphanumeric characters, the first of which must be alphabetic.

PARENT PROCESS NAME

The name of the parent program.

PARENTPROGRAMNAME*

The port to which the client process is connected.

TCP PORT*

The state of the client connection.

TCP STATE*

How long the query has been executing.

ELAPSED TIME

How long the query has been in a waiting state.

WAIT TIME*

How long the query has been on hold.

HOLD TIME*

The query ID number (up to 160 characters).

QUERY ID

106

Find Offending Processes and Queries