WebSphere Commerce database table: BZSVCCFG

Reference > Database > WebSphere Commerce database tables > B

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 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
SQL100520030306880 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

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

Related reference

Rule server configuration data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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.

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