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.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
I0000052 SERVICENAME+STOREENT_ID+BZSRVCFG_ID Unique Index
SQL050212031205350 BZSVCCFG_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_149 BZSRVCFG_ID BZSRVCFG BZSRVCFG_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_150 BZSVCCFG_ID BZSVCSTA BZSVCCFG_ID Cascade

Feedback