Marketing Operations | umoConfiguration | database
These properties specify information about the database that is used forIBM® 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 IBM® Marketing Operations database.
Default value
dbo
db2ServerSchemaName
*
Changes to the default value supplied for this parameter are not recommended.
Description
Used internally by IBM® EMM 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 IBM® 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 IBM® 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
Copyright IBM Corporation 2014. All Rights Reserved.