Copyright © Cloud Software Group, Inc. All Rights Reserved

cdqp_cfg

The cdqp_cfg table holds the details of each mapping of a CDQP to a queue.

Structure

The cdqp_cfg table has the following structure:

TABLE cdqp_cfg (
cfg_id number(10) NOT NULL,
def_id number(10) NOT NULL,
queue_name varchar2(48) NOT NULL)

Column	Description
cfg_id	Unique ID for this CDQP/queue mapping generated from the sequences table.
def_id	ID of the CDQP that is mapped to the queue_name queue, as defined in the cdqp_def table.
queue_name	Name of the iProcess queue that the CDQP defined in def_id is mapped to, as defined in the user_names table.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)	Index Tablespace
pk_cdqp_cfg	cfg_id	MEDIUMINDEXSPACE

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_cdqp_cfg1	def_id	cdqp_def

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following index is defined for this table.

Index Name	Column(s) Indexed	Tablespace
idx_cdqp_cfg_fk	def_id	MEDIUMINDEXSPACE

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	MEDIUMTABLESIZE
Percentage Increase	MEDIUMTABLEPCTINCREASE
Tablespace	MEDIUMTABLESPACE

Table Activity

The cdqp_cfg table contains one row for each mapping of a CDQP to a queue that is defined on the system. For example, if CDQP1 is mapped to 6 queues, and CDQP2 is mapped to 4 queues, the cdqp_cfg table contains 10 rows.

Rows are added, updated and deleted in the following situations.

A row is...	When...
added	a field (that is already defined as a CDQP) is mapped to a queue.
updated	never.
deleted	an existing CDQP mapping is deleted.

Copyright © Cloud Software Group, Inc. All Rights Reserved