Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# iap_monitor

The `iap_monitor` table holds the monitor ID records for each procedure and node. If a procedure or node has any activity monitoring configured, it is assigned a monitor ID. The monitor ID is then used when correlating between the iap_activity and iap_field tables.

## Structure

The `iap_monitor` table has the following structure:

    TABLE iap_monitor(
    	node_id		INTEGER		NOT NULL,
    	proc_id		INTEGER		NOT NULL,
    	monitor_id	numeric(10)		NOT NULL)

Column | Description
`node_id` | ID of the node that this procedure is defined on, as defined in the nodes table.
`proc_id` | Unique ID of this procedure, generated from the sequences table.
`monitor_id` | Unique ID of the record for the procedure or node being monitored.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_iap_monitor` | `monitor_id`

## Foreign Keys

The following foreign key is defined for this table.

Key Name | Column(s) | Referenced in Table...
`fk_iap_monitor` 1 This key enforces the DELETE CASCADE referential action. | `proc_id node_id` | proc_index nodes

## Indexes

The following index is defined for this table.

Index Name | Column(s) Indexed
`idx_iap_monitor_fk` | `proc_id node_id`

## Table Activity

The `iap_monitor` table contains one row for each procedure or node that has activity monitoring configured for it. Rows are added, updated and deleted in the following situations.

A row is... | When...
added | a new procedure or node has activity monitoring configured.
updated | a procedure or node’s activity monitoring configuration is updated.
deleted | never.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine