Unica Plan | umoConfiguration | database
These properties specify information about the database that is used for Unica Plan.
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 Unica Plan database.
- Default value
dbo
db2ServerSchemaName
- Description
-
Used internally by Unica 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 Unica Plan 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 Unica Plan 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