assign one table to more than one db agent

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Is it possible to assign one table to more than one db agent in the NX.env?

Environment

WINDOWS

Resolution

It is not possible to assign one table to more than one agent as it is not supported. Even if you can define\map more that one db agent in NX.env for same table, you will observe the following messages in the log  and only one of the agents will be used:

bpvirtdb_srvr 35336 SIGNIFICANT vdbagent.c 2373 Creating upinde agent 13 for table(s):Call_Req

bpvirtdb_srvr 35336 ERROR vdbagent.c 3866 Table (Call_Req) already defined for UPINDE agent (1). Duplicate definition ignored