Marketing Operations | umoConfiguration | database

These properties specify information about the database that is used forHCL® Marketing Operations.

fileName

Description

Path to file for loading data sources using JNDI lookup.

Default value

plan_datasources.xml

sqlServerSchemaName

Description

Specifies the database schema to use. This parameter applies only if you are using SQL Server for your HCL Marketing Operations database.

Default value

dbo

db2ServerSchemaName

Important: Changes to the default value supplied for this parameter are not recommended.
Description

Used internally by HCL® Marketing Software applications.

Default value

blank

thresholdForUseOfSubSelects

Description

Specifies the number of records beyond which a subquery must be used in the IN clause of SQL (for listing pages) instead of the actual entity IDs in the IN clause. Setting this parameter improves performance for HCL Marketing Operations installations that have a large application data set. As a best practice, do not change this value unless you encounter performance issues. If this parameter is missing or commented out, the database behaves as if the threshold is set to a large value.

Default value

3000 (records)

commonDataAccessLayerFetchSize

Description

This parameter specifies resultset fetch size for certain performance sensitive, critical queries.

Default value

0

commonDataAccessLayerMaxResultSetSize

Description

This parameter specifies maximum resultset size for certain performance sensitive, critical queries.

Default value

-1

useDBSortForAllList

Description

This parameter is used to configure ALL HCL Marketing Operations List Handlers. Use another useDBSortFor<module>List parameter to override the paging behavior of a particular list.

Valid values
  • True: get one page of list data from the database at a time.

  • False: cache all list data.

Default value

True

useDBSortForPlanList

Description

This parameter is used to configure the Plan List Handler.

Valid values
  • True: get one page of list data from the database at a time.

  • False: cache all list data.

Default value

True

useDBSortForProjectList

Description

This parameter is used to configure the Project List Handler.

Valid values
  • True: get one page of list data from the database at a time.

  • False: cache all list data.

Default value

True

useDBSortForTaskList

Description

This parameter is used to configure the Task List Handler.

Valid values
  • True: get one page of list data from the database at a time.

  • False: cache all list data.

Default value

True

useDBSortForProgramList

Description

This parameter is used to configure the Program List Handler.

Valid values
  • True: get one page of list data from the database at a time.

  • False: cache all list data.

Default value

True

useDBSortForApprovalList

Description

This parameter is used to configure the Approval List Handler.

Valid values
  • True: get one page of list data from the database at a time.

  • False: cache all list data.

Default value

True

useDBSortForInvoiceList

Description

This parameter is used to configure the Invoice List Handler.

Valid values
  • True: get one page of list data from the database at a time.

  • False: cache all list data.

Default value

True

useDBSortForAlerts

Description

This parameter is used to configure the Alerts List Handler.

Valid values
  • True: get one page of list data from the database at a time.

  • False: cache all list data.

Default value

True