Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# predict_lock

The `predict_lock` table stores the locks that are used to control access to the `predict` table.

## Structure

The `predict_lock` table has the following structure:

    TABLE predict_lock (
    	node_id		number(5)			NOT NULL,
    	proc_num	number(5)		NOT NULL,
    	case_num	number(20)		NOT NULL)

Column | Description
`node_id` | ID of the node that this prediction lock is hosted on, as defined in the nodes table.
`proc_num` | ID of the procedure that this prediction lock applies to, as defined in the proc_index table.
`case_num` | Case number of the main case that this prediction lock applies to, as defined in the case_information table.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s) | Index Tablespace
`pk_predict_lock` | `node_id proc_num case_num` | SMALLINDEXSPACE

## Foreign Keys

The following foreign key is defined for this table.

Key Name | Column(s) | Referenced in Table... | Column(s)
`fk_predict_lock` 1 This key enforces the DELETE CASCADE referential action. | `node_id proc_num case_num` | case_information | `node_id proc_id casenum`

## Indexes

None.

## Storage

The following STORAGE values are defined for this table.

Value | Definition
Initial | SMALLTABLESIZE
Percentage Increase | SMALLTABLEPCTINCREASE
Tablespace | SMALLTABLESPACE

Note | By default, the `predict` and `predict_lock` tables use the `SMALL` macro values. If you intend to enable case prediction on your system, TIBCO recommends that you change these tables to use a larger value in line with the level of prediction activity you expect.

## Table Activity

The `predict_lock` table contains one row for every main case on the system that currently has prediction data defined in the predict table. Rows are added, updated and deleted in the following situations.

A row is... | When...
added | background prediction is enabled on the iProcess Engine, and a case that has prediction enabled is started. Note: Case prediction can be enabled and disabled using the `ENABLE_CASE_PREDICTION` process attribute. See TIBCO iProcess Engine Administrator's Guide for more information.
updated | never.
deleted | a case that has prediction enabled is purged.

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