Versions Compared

Old Version 6

changes.mady.by.user Yuri Au Yong

Saved on

compared with

New Version Current

changes.mady.by.user Jenni Wallin

Saved on

Key

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

...

The contents of the menus in the menu bar may change depending on which configuration type that has been opened. The Duplicate UDR profile uses the standard menu items and buttons that are visible for all configurations, and these are described in Common Configuration Buttons (4.1).

ItemButton

Description

External References

Select this menu item to Enable External References in an agent profile field. Refer to Enabling External References in an Agent Profile Field in External Reference (4.1) for further information.

...

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

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

Setting

Description

Storage Host

In the drop-down menu, the preferred storage host, where the duplicate UDRs are to be stored, can be selected. The choice for storage of duplicate repositories is either on a specific EC Group or Automatic.

If Automatic is selected, the same EC Group used by the running workflow will be selected. When the Duplicate UDR Inspector is used, the EC Group is automatically selected.

Note

Note!

The workflow must be running on the same EC Group as its storage resides, otherwise, the Duplicate UDR Agent will refuse to run. If the storage is configured to be Automatic, its corresponding directory must be a file system shared between all the EC Groups.

Directory


An absolute path to the directory on the selected storage host, in which to store the duplicate cache.

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

Info
Code Block
mzsh topo set val:common.mz.preset.dupUDR.storage.path '/mydirectory/dupudr'
To disable the property:
Code Block
mzsh topo unset val:common.mz.preset.dupUDR.storage.path

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

External References specific to File Storage can be used with the following field: 

...

Setting

Description

Database Profile 

This is the database in which to store the Duplicate UDR cache. 

Click the  Browse...  button to get a list of all the database profiles that are available. For further information see Database Profile (4.1). 

Duplicate UDR SQL Storage is supported for use with the following database: 

  • SAP HANA 2.0 SP 7 5 and above 

  • PostgreSQL 12 and above

Note

Note!

If no changes are made to the Duplicate UDR profile, changes to the settings of selected Database Profile will only be detected during Duplicate UDR Agent workflow run. 

Generate SQL 

Click this button to bring up a dialog that will contain the SQL statements for the table schema generated for the Duplicate UDR profile. 

Note

Note!

The Duplicate UDR profile Configuration Key is used for generating the names of the Duplicate UDR database tables. You will need to save the profile at least once for the profile to have a Configuration Key, so that proper database table names can be generated. 

Warning

Warning!

Users will have to copy the SQL script generated in the dialog and execute the SQL script separately to create the Duplicate UDR tables on their own in the database selected with the Database Profile selector. The Duplicate UDR profile will not automatically create the tables in the database for you. 

Generate SQL Dialog Box 

...