Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see High-speed Apply Engine 13.1.

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

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 figures show examples of the [ObjectPartition] parameters for a Db2 target on a mainframe:

/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'

The following figures show examples of the [ObjectPartition] parameters for a Db2 LUW target:

 [ObjectPartition]
  Table=ACCT.PAYBLE
   Column=AcctNumber
   Column=Date
   Partition=CC5700_YTD
    Value=5700
    Value=2008-05-01
   Partition=CC5700_MTD
    Value=5700
    Value=2008-05-18

The following figures show examples of the [ObjectPartition] parameters for an Oracle target:

[ObjectPartition]
  Table=ACCT.PAYBLE
   Column=AcctNumber
   Column=Date
   Partition=CC5700_YTD
    Value=5701
    Value=TO_DATE('2008/05/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
   Partition=CC5700_MTD
    Value=5701
    Value=TO_DATE('2008/05/18 00:00:00','YYYY/MM/DD HH24:MI:SS')
   Partition=CCREST
    Value=MAXVALUE
    Value=MAXVALUE

This section also contains the following topics:

Related topics

Command-and-syntax-reference

Distribution-of-work

Format-of-configuration-parameters

 

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