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

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/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.

When creating a custom table, how do we edit NX_VIRTDB_AGENT to it.

Environment

Release: 14.1 or higher
Component:  CA Service Desk Manager

Resolution

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

======================================== 
VDBINFO invoked at 11/20/XXXX 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