WebSphere Commerce database table: BZSVCCFG

This table contains rule service configuration data. Each row represents a rule service configuration, including the rule server to which the service belongs. This table is deprecated and is provided for backward compatibility only.

Column Descriptions
Column Name Column Type Description
BZSVCCFG_ID INTEGER NOT NULL A system generated ID for this rule server configuration.
BZSRVCFG_ID INTEGER NOT NULL The ID of the rule server to which this rule service belongs.
SERVICENAME VARCHAR(127) NOT NULL The name of this rule service. Any non-empty string is valid. The name must be unique within a rule server and store entity.
STOREENT_ID INTEGER NOT NULL The store entity to which this rule service belongs.
PROJECTPATH VARCHAR(1022) NOT NULL The location of the rule project on the file system. This should be a fully-qualified path.
AGENTS INTEGER NOT NULL DEFAULT -1 The initial number of rule agents the system creates when it starts this rule service. Setting this to the special value -1 causes the system to create and destroy rule agents as required.
SESSIONTIMEOUT INTEGER NOT NULL DEFAULT 30000 The length of time (in milliseconds) the system will wait for this rule service to respond to a request.
LASTUPDATE TIMESTAMP NOT NULL The date and time of the last time this rule service was updated, either by changing configuration data or the underlying rule project.
ENABLED INTEGER NOT NULL DEFAULT 1 Indicates whether the rule service is enabled: 0=false, 1=true.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000052 SERVICENAME+STOREENT_ID+BZSRVCFG_ID Unique Index
SQL060903235134060 BZSVCCFG_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_149 BZSRVCFG_ID BZSRVCFG BZSRVCFG_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_150 BZSVCCFG_ID BZSVCSTA BZSVCCFG_ID Cascade