LoadPublicViewsAndSubsetsAtStartup

Added in v2.0.8 This configuration parameter enables whether public subsets and views are loaded when the the Planning Analytics database starts and keeps them loaded to avoid lock contention during the first use.

Parameter type: optional, static

Default: LoadPublicViewsAndSubsetsAtStartup=T

If LoadPublicViewsAndSubsetsAtStartup=F, public views subsets are loaded on-demand for your Planning Analytics database.

Lock contention issues can occur when public views and subsets are loaded on-demand (when a user requests the subset). You can avoid lock contention on server startup by loading all public views and subsets from all users into memory and keeping them loaded to avoid lock contention during the first use. Add the following setting to yourPlanning Analytics database configuration.

LoadPublicViewsAndSubsetsAtStartup=T