Configure system-specific XACTCommandQSpooler processes

Note: For information on overriding default configuration settings, refer to Modify configuration settings.

The XACTCommandQSpooler allows clients to send transactions to a Microsoft SQL Server residing in a different domain.

By default, the system spawns separate XACTCommandQSpooler processes for every line entered in the %DNAInstallRoot%\RealTime\config\Settings\Realtime_XACT.json file. This enables each specified process to use a different Data Access Layer (DAL) driver for local and remote connections.

Sample Realtime_XACT.json file

{

"RealTime": {

"XACT": {

"Queues": {

"Historical": {

"Size": 102400,

"DALDirectory" : ""

},

"RealTime": {

"Size": 20480,

"DALDirectory" : ""

},

"LMS": {

"Size": 20480,

"DALDirectory" : ""

},

"RTUDataDump": {

"Size": 10240,

"DALDirectory" : ""

},

"GasMeasurement": {

"Size": 20480,

"DALDirectory" : ""

}

}

}

}

}

Follow the procedure below if you require a specific type of configuration for a system.

To configure system-specific XACTCommandQSpooler processes

1. In the %DNADataRoot%\RealTime\config\Settings directory, either create or open the Realtime_XACTConfig.json file.

2. Modify the new file as required.

3. Save your changes.

4. Restart the RealTime service.

5. Copy the Realtime_XACTConfig.json file from the Hot RealTime server to the Standby RealTime server.

6. Restart the RealTime service on the Standby RealTime server.