Defining data buffering

To improve performance and resolve bottlenecks, you can specify how input and output data for an IBM® Db2® Connector stage is buffered. Although the size and operation of the buffer are usually the same for all links on all stages, you can modify the settings for specific links.

About this task

Important: By default, data is buffered so that no deadlocks occur. Be careful when changing data buffering settings because specifying inappropriate values might create a deadlock.

Any changes that you make to the properties on the Advanced tab are automatically reflected on the Advanced tab of the stage at the other end of the link.

To change the settings for data buffering:

Procedure

  1. On the job design canvas, double-click the Db2 connector icon.
  2. Select either the Input link tab or the Output link tab depending on the link that you want to edit.
  3. On the Advanced tab, select the Buffering mode and specify the required values.
  4. Click OK to save your changes and close the stage editor.

    For more details on the properties click Help.