Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML
<style>
.release-box {
	height: 30px; 
	width: 100px; 
	padding-top: 8px;
	text-align: center; 
	border-radius: 5px; 
	font-weight: bold; 
	background-color: #d4af37; 
	border-color: #FCE28A;
}

.release-box:hover {
  	cursor: hand;
    cursor: pointer;
    opacity: .9; 
}
</style>
<meta name="robots" content="noindex">

<div class="release-box">
<a href="https://docs.perspectium.com/display/gold" style="text-decoration: none; color: #FFFFFF; display: block;">
Gold
</a>
</div>

Key Set Processing is a capability of the DataSync Agent which can be enabled when replicating messages from a ServiceNow instance to a database. The Key Set capability optimizes throughput while further ensuring message ordering.

(info)(info) NOTE: It's strongly recommended to enable this capability when replicating from a ServiceNow instance.

This is enabled on a task by task basis by adding the following configuration direction within the <task> definition.

Code Block
languagexml
<task>
	<enable_keyset_processing/>
	...
	...
</task>



The following directives can be added to the agent.xml when enabling the Key Set Processing

DirectiveDescriptionExample
<keyset_size>

Indicates the number of key set processor that will maintain the connection to the database.

(info) NOTE: Overriding the default key set size (8) may reduce overall throughput of message processing.



Code Block
languagexml
<keyset_size>4</keyset_size>


<queue_consumer_polling_interval>

Indicates the time interval the queue will be consumed. By default, the key set is scheduled to read from the queue every two seconds. 


Code Block
languagexml
<queue_consumer_polling_interval>nn</queue_consumer_polling_interval>

(info) NOTEThe value nn is in milliseconds.

<keyset_read_wait_time>

Indicates the time each key set processor will wait when reading from its queue. By default, the wait time is 200 milliseconds. 



Code Block
languagexml
<keyset_read_wait_time>nn</keyset_read_wait_time>


Example of the agent.xml 

Code Block
languagexml
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
    <agent>
        <share/>
        <subscribe>
			<task>
				<enable_keyset_processing/>
				<keyset_size>4</keyset_size>
				<queue_consumer_polling_interval>nn</queue_consumer_polling_interval>
				<keyset_read_wait_time>nn</keyset_read_wait_time>
				...
				...
			</task>
		</subscribe>
        <max_reads_per_connect>4000</max_reads_per_connect>
        <polling_interval>5</polling_interval>
        <skip_message_set_processing/>
    </agent>
</config>




Similar topics


Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
cqllabel = "datasync-agent-advance" and space = currentSpace()

Contact Perspectium Support


US: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com