ObjectPartition parameters

[ObjectPartition] parameters enable you to specify logical data partitions for the target tables. The High-speed Apply Engine uses the values that you specify in this section to distribute the workload between apply agents. 

Parameter

Reference

Column

LimitKey

Order

Partition

Table

Value

Related topics

Command-and-syntax-reference

Distribution-of-work

Format-of-configuration-parameters

You can use these parameters to:

  • Optimize High-speed Apply Engine performance for tables that are not physically partitioned
  • Optimize performance by using partitions that are different than the physical partitions of the target tables

The following figure shows an example of the [ObjectPartition] parameters:

/ObjectPartition/
 Table=ACCT.PAYBLE
  Column=AcctNumber
  Column=Date
  Order=DESC
  Partition=CC5700_YTD
   Value=5700
   Value=2008-05-01
  Partition=CC5700_MTD
   Value=5700
   Value=2008-05-18
 Table=ACCT.MONTHLY
  Column=TTIME
  Partition=Part1
   LimitKey='000101010080000003'
  Partition=Part3
   LimitKey='00010101008000000A'

This section also contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*