Does ServiceDesk add additional update agents for tables that are not specified by NX_VIRTDB_AGENT in NX.env file?

Document ID : KB000025053
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

In NX.env the NX_VIRTDB_AGENT defines the update agents that handles specific tables. However, there are many tables which are not defined by the variable. This document explains how ServiceDesk handles updates on the other tables.


Question:

We have created custom table, how do we edit NX_VIRTDB_AGENT to it.

Answer: 

In NX.env file the NX_VIRTDB_AGENT defines the update agents that handles specific tables.

# NX_VIRTDB_AGENTn defines update agents that manage
# all updates for a particular table(s).
# These agents are not part of $NX_MAX_DBAGENT count
@NX_VIRTDB_AGENT1=Call_Req
@NX_VIRTDB_AGENT2=Act_Log
@NX_VIRTDB_AGENT3=Change_Request
@NX_VIRTDB_AGENT4=Change_Act_Log
@NX_VIRTDB_AGENT5=Issue
@NX_VIRTDB_AGENT6=Issue_Act_Log
@NX_VIRTDB_AGENT7=Audit_Log, event_log, session_log
@NX_VIRTDB_AGENT8=EBR_FULLTEXT, EBR_FULLTEXT_ADM, BU_TRANS
@NX_VIRTDB_AGENT9=CREATE_INDEX

However, the updates to rest of the tables in ServiceDesk is handled by Agent#0 which is not defined in NX.env file. ServiceDesk does not add additional update agents.

To verify run the following command in the command prompt of ServiceDesk server.

pdm_vdbinfo >info.txt

The file will indicate the update agent#0,/p>

========================================
VDBINFO invoked at 11/20/2008 05:04:54
========================================
Min Config Agents = 6
Max Config Agents = 6
Max DB Agents = 6
Tgt num idle = 2
Num Agents running = 16
Num Agents starting = 0
Num Requests pending = 0
Actual num idle = 6
Agent #0 - (UPD) prov#6592_bpvirtdb_srvr @11/20/2008 05:04:51 with 0 in work
Agent #1 - (UPD) prov#4368_bpvirtdb_srvr @12/31/1969 16:00:00 with 0 in work
Agent #2 - (UPD) prov#5472_bpvirtdb_srvr @12/31/1969 16:00:00 with 0 in work
Agent #3 - (UPD) prov#7108_bpvirtdb_srvr @12/31/1969 16:00:00 with 0 in work
Agent #4 - (UPD) prov#6428_bpvirtdb_srvr @12/31/1969 16:00:00 with 0 in work
Agent #5 - (UPD) prov#5540_bpvirtdb_srvr @12/31/1969 16:00:00 with 0 in work
Agent #6 - (UPD) prov#9468_bpvirtdb_srvr @12/31/1969 16:00:00 with 0 in work
Agent #7 - (UPD) prov#8616_bpvirtdb_srvr @11/20/2008 05:04:03 with 0 in work
Agent #8 - (UPD) prov#1576_bpvirtdb_srvr @11/20/2008 04:22:07 with 0 in work
Agent #9 - (UPD) prov#9672_bpvirtdb_srvr @12/31/1969 16:00:00 with 0 in work