Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Setting

Description

Storage Type

From the drop-down list, select either File Storage or Database Storage.

Using Database Storage means that a database will be used as storage instead of the EC file system. When choosing this option several new fields will be displayed.

Database Profile (only for Database Storage type)

Click Browse to select the Database Profile you want to use for the Inter Workflow Profile.

Note

Note!

Currently, the SQL storage only supports PostgreSQL, SAP HANA, and Oracle databases.

Show SQL Statement (only for Database Storage type)

When you select Database Profile, this button will print the SQL statements needed to create the tables and indexes required for the Inter Workflow Profile. You can copy and paste this to your database management software.

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

Info!
You will have to copy the SQL script generated in the text box to create the PostgreSQL, SAP HANA, or Oracle tables on their own in the database listed in the Database profile. The Inter Workflow profile will not automatically create the tables for you.

Copy to Clipboard (only for Database Storage type)

This button will copy the text in the text area below, which was generated by the “Show SQL Statement” button, to the clipboard on your computer.

Storage Host

From the drop-down list, select either Automatic or an activated EC group.

Using Automatic means that the storage will use the EC Group where the first workflow accessing this profile is started. Following workflows using the same profile will use the same EC Group for storage until the first workflow accessing the profile is stopped. The EC Group where the next workflow accessing this profile is started will then be used for storage. The location of the storage will therefore vary depending on the start order of the workflows.

Info

Example

Below is an example of a scenario where Automatic is used as a storage host with the following setup:

  • Workflow 1 is running on EC Group 1 with Interworkflow Forwarding agent

  • Workflow 2 is running on EC Group 2 with Interworkflow Collection agent
     

  1. Workflow 2 is started.

    EC Group 2 is used for storage
     

  2. Workflow 1 is started.

    EC Group 2 is still used for storage.
     

  3. Workflow 1 is stopped.

    EC Group 2 is still used for storage.
     

  4. Workflow 2 is stopped.

    No EC Group is used for storage.
     

  5. Workflow 1 is started.

    EC Group 1 is used for storage.


Note

Note!

The workflow must be running on the same EC as its storage resides. If the storage is configured to be  Automatic, its corresponding directory must be a shared file system between all the EC Groups.


Root Directory (only for File Storage type)

The absolute pathname of the directory on the storage handler where the temporary files will be placed.

If this field is greyed out with a stated directory, it means that the directory path has been hard coded using the mz.present.interwf.storage.path property. This property is set to false by default.

Info

Example - Using the mz.preset.interwf.storage.path property

To enable the property and state the directory to be used:

Code Block
mzsh topo set val:common.mz.preset.interwf.storage.path '/mydirectory/iwf'


To disable the property:

Code Block
mzsh topo unset val:common.mz.preset.interwf.storage.path

For further information about all available system properties, see System Properties.

Max Bytes

An optional parameter stating the limit of the space consumed by the files stored in the Root Directory or Database. If the limit is reached, any Inter Workflow forwarding agent using this profile will abort.

Max Batches

An optional parameter stating the maximum number of batches stored in the Root Directory or Database. If the limit is reached, any Inter Workflow forwarding agent using this profile will abort.

Compress intermediate data

Select this check box checkbox if you want to compress the data sent between the Inter Workflow agents.

The data will be compressed into *.gzip format with compression level 5.

Named MIMs

A list of user defined MIM names. These variables do not have any values assigned. They are populated with existing MIM values from the Inter Workflow forwarding agent. This way, MIMs from the forwarding workflow can be passed on to the collecting workflow.

...

Setting

Description

Profile

Select an SQL profile. This profile is used to access the storage for aggregation sessions.

Note

Note!

Currently, the SQL storage only supports PostgreSQL and SAP HANA databases.

Storage sharing functionality is currently not supported.

Index Fields

Click the Add button to select the UDR type.

Table SQL Script

This text box will generate the SQL statements for the selected UDRs' table schema and indexes for Id, TxId. The schema will be generated based on the number of UDRs in the UDR Type Mapping table.

Info

Info!

Users You will have to copy the SQL script generated in the text box to create the PostgreSQL and SAP HANA tables on their own in the database listed in the Database profile. The Aggregation profile will not automatically create the tables for you.

Note

Note!

The following table columns are mandatory when creating the database:

Column NameData Type

Id

VARCHAR(24)

TxId

BIGINT

Deleted

BOOLEAN

Timeout

BIGINT

Session

BYTEA

...