Database System Parameters
The following table describes the Database set of system parameters.Table 1. Database System Parameters
|
ID |
Name |
Category |
Access Level |
Label |
Description |
Parameter Value |
|
179 |
ETL.GMToffset |
Database |
Normal Access |
GMT offset for UTC conversion |
Defines the time zone offset (in minutes) for GMT to UTC (Coordinated Universal Time) conversion |
+240 |
|
301 |
PR.ProfilingSeedlistCustomersEnabled |
Database |
Normal Access |
Enable Profiling of Seedlist Customers |
Determines whether Connect will calculate statistics of customers included in the seed list along with all other customers in calculations ('TRUE') or not ('FALSE') |
FALSE |
|
140 |
CM.CheckCampaignPriorityBatchSize |
Database |
Advanced Access |
Continuation Policy Check Batch Size |
Indicates the number of processed records the Conversation Manager will use to determine if higher priority campaigns will require preparation or execution |
250 |
|
141 |
CM.CheckCampaignPriorityInterval |
Database |
Advanced Access |
Continuation Policy Check Interval (in seconds) |
Defines the frequency that the Conversation Manager will check (in seconds) to determine if higher priority campaigns will require preparation and execution |
60 |
|
130 |
CM.ExecutionFetchSize |
Database |
Advanced Access |
Fetch size during the 'execution' phase |
Indicates the number of rows used by the Conversation Manager when fetching rows from the customer_queue table during the 'execution' phase |
250 |
|
416 |
CM.IgnoreCustStatusInSubscriptions |
Database |
Advanced Access |
Ignore customer status in new subscriptions? |
Determines whether Connect will create new subscriptions with an 'Active' status ('TRUE') or an 'Inactive' status ('FALSE') |
FALSE TRUE |
|
128 |
CM.PreppingBatchSize |
Database |
Advanced Access |
Insert batch size during the 'prep' phase |
Indicates the batch size used by the Conversation Manager when inserting data into customer_queue table during the preparation phase |
100 |
|
129 |
CM.PreppingFetchSize |
Database |
Advanced Access |
Fetch size during the 'prep' phase |
Indicates the fetch size used by the Conversation Manager when fetching customers from the targeting queue during the 'prep' phase. |
250 |
|
414 |
DB.CheckDBConnectionBeforeUsage |
Database |
Advanced Access |
Check that DB connection is valid before usage? |
Determines whether Connect will verify that the database connection is valid before usage ('TRUE') or not ('FALSE'). This is performed using a test query. |
FALSE |
|
415 |
DB.CheckDBConnectionInterval |
Database |
Advanced Access |
Interval to check database connection before usage |
Defines the interval of time (in miliseconds) in which Connect will check the database connection before usage |
2000 |
|
429 |
DB.TransactionStatementCacheSize |
Database |
Advanced Access |
Transaction statements cache limit |
Indicates the maximum allowed statements cache size used for each transaction. To disable the cache, set this limit value to 0.Value must be in 30-100 range |
30 - 100 0 |
|
169 |
DBM.AnalyzeFrequency |
Database |
Advanced Access |
Interval in days between database statistics analysis |
Defines the amount of time (in days) between updates of the database's cost-based optimizer statistics. Note: Up-to-date statistics help the query optimizer improve performance. |
1 |
|
157 |
DBM.AnalyzeTimeWindow |
Database |
Advanced Access |
Run table analysis during this time period |
Specifies the time period when it is appropriate to analyze the tables. The format of the time frame is: HH:MM HH:MM |
4:00 6:00 |
|
156 |
DBM.BounceTimeWindow |
Database |
Advanced Access |
Run bounce analysis during this time period |
Specifies the time period when it is appropriate to perform customer bounce analysis. The format of the time frame is: HH:MM (start time) HH:MM (ending time) |
6:45 7:45 |
|
173 |
DBM.MaxBounce |
Database |
Advanced Access |
Max number of bounces before we unsubscribe customer |
Indicates the maximum number of bounces to trigger deactivation of a customer |
5 |
|
174 |
DBM.MaxBouncePeriod |
Database |
Advanced Access |
Max days during which we receive max bounces before we unsubscribe a customer |
Defines the amount of time (in days) during which the maximum bounce occurs before deactivating a customer. |
30 |
|
144 |
DBM.PeriodToRebuildLA |
Database |
Advanced Access |
Period to rebuild the aliaser.cache |
Defines how often (in minutes) the aliaser.cache should be rebuilt. Enter a value of '0' if you want the aliaser.cache to be updated incrementally but never rebuilt. |
0 |
|
148 |
DBM.PMFrequency |
Database |
Advanced Access |
Frequency to update profiler targeting tables |
Indicates the frequency in which Connect will update the profiler targeting tables.
|
anytime daily hourly |
|
145 |
DBM.ProfilerTimeWindow |
Database |
Advanced Access |
Hour range of day when updating targeting tables is allowed |
Specifies the time interval during the day when it is appropriate to start updating profiler targeting tables. The format of the time frame is: HH:MM (start time) HH:MM (ending time) |
3:01 23:59 |
|
153 |
DBM.PurgeTimeWindow |
Database |
Advanced Access |
Start purge during this time period |
Specifies the time period when it is appropriate to begin purging the tables. The format of the time frame is: HH:MM (start time) HH:MM (ending time) |
0:01 3:00 |
|
178 |
DBM.PurgeUsedCustSubscriptions |
Database |
Advanced Access |
Purge used, deleted conversations' customer subscriptions? |
Determines whether the DBManager should purge the cust_subscriptions table corresponding to used conversations deleted from the UI ('TRUE') or not ('FALSE') |
FALSE TRUE |
|
181 |
DBM.RebuildDefaultTrackerLinks |
Database |
Advanced Access |
Rebuild default tracker links in cache for instances not older than m months |
Defines the interval (in months) when you want Connect to rebuild the default tracker links in the cache for instances not older than the indicated months. Specify '0' if you do not want to cache default tracker links. Specify '9999' if you want to cache default tracker links for all instances. |
24 |
|
155 |
DBM.RetainAfterDeletion |
Database |
Advanced Access |
Days to retain data marked for deletion by the UI |
Defines the amount of time (in days) to retain data after it is marked for deletion by the UI. |
8 |
|
176 |
DBM.RetainClickHistory |
Database |
Advanced Access |
Days to retain click history |
Defines the time range (in days) to retain a customer's click history |
180 |
|
168 |
DBM.RetainCounterHistory |
Database |
Advanced Access |
Days to retain counter history |
Defines the time range (in days) to retain the history of all counter values |
90 |
|
167 |
DBM.RetainCustMonthStats |
Database |
Advanced Access |
Months to retain monthly statistics on the customers |
Defines the time range (in months) to retain the monthly statistics stored on the customers. |
24 |
|
388 |
DBM.RetainCustomerAttributesHistory |
Database |
Advanced Access |
Days to retain customer attribute history |
Defines the time range (in days) to retain the archived records of deleted customer attributes. |
90 |
|
389 |
DBM.RetainCustomerQueue |
Database |
Advanced Access |
Days to retain CUSTOMER_QUEUE rows |
Defines the time range (in days) to retain the records in the CUSTOMER_QUEUE table for unexpired campaigns |
60 |
|
166 |
DBM.RetainCustWeekStats |
Database |
Advanced Access |
Days to retain weekly statistics on the customers |
Defines the time range (in days) to retain the weekly statistics on the customers |
30 |
|
171 |
DBM.RetainDemoAggStats |
Database |
Advanced Access |
Days to retain demographic aggregate stats |
Defines the time range (in days) to retain demographic aggregate statistics |
180 |
|
172 |
DBM.RetainDomainAggStats |
Database |
Advanced Access |
Days to retain domain aggregate stats |
Defines the time range (in days) to retain the domain aggregate statistics |
180 |
|
164 |
DBM.RetainErrorHistoryCritical |
Database |
Advanced Access |
Days to retain critical errors |
Defines the time range (in days) to retain the error messages with critical-level severity |
90 |
|
170 |
DBM.RetainErrorHistoryDiagnostic |
Database |
Advanced Access |
Days to retain diagnostic errors |
Defines the time range (in days) to retain the error messages with diagnostic-level severity |
7 |
|
159 |
DBM.RetainErrorHistoryError |
Database |
Advanced Access |
Days to retain errors |
Defines the time range (in days) to retain error messages with error-level severity |
90 |
|
154 |
DBM.RetainErrorHistoryWarning |
Database |
Advanced Access |
Days to retain warnings |
Defines the time range (in days) to retain error messages with warning-level severity |
30 |
|
158 |
DBM.RetainEvents |
Database |
Advanced Access |
Days to retain event queuing records |
Defines the time range (in days) to retain the event queuing records in the EVENT_QUEUE table |
60 |
|
430 |
DBM.RetainInstanceLog |
Database |
Advanced Access |
Days to retain instance log entries |
Defines the time range (in days) to retain the instance log entries |
365 |
|
175 |
DBM.RetainMessageHistory |
Database |
Advanced Access |
Days to retain message and reply history |
Defines the time range (in days) to retain the history of messages sent and customer replies. The value of this system parameter needs to be set according to the customer deactivation and the integration with response needs. |
90 |
|
177 |
DBM.RetainStorageHistory |
Database |
Advanced Access |
Days to retain storage history rows |
Defines the time range (in days) to retain the rows in storage history |
60 |
|
425 |
DBM.UpdateGeoLocationTimeWindow |
Database |
Advanced Access |
Hour range of day when updating geolocation is allowed to start |
Specifies the time interval during the day when it is appropriate to start update geolocation for clicks,opens and conversions. The format of the time frame is: HH:MM (start time) HH:MM (ending time) |
0:01 3:00 |
|
314 |
MS.SendDetectorstoAOL |
Database |
Advanced Access |
Add read detectors to HTML messages sent to AOL customers? |
Determines whether to send the read detector when sending HTML messages to AOL customers ('TRUE') or not ('FALSE'). |
FALSE |
|
313 |
MS.SendHTMLtoAOL |
Database |
Advanced Access |
Send HTML to AOL customers |
Determines whether to send HTML instead of AOL content to AOL customers ('TRUE') or not ('FALSE'). |
FALSE |
|
287 |
PR.BatchUpdateSize |
Database |
Advanced Access |
Batch update size |
Indicates the batch update sizes of the profiler's inserts into history tables |
100 |
|
286 |
PR.NumberOfLookupTMs |
Database |
Advanced Access |
Number of Lookup TMs |
Indicates the number of database connections used in parallel for the profiler to perform database lookups to determine first message clicks and reads. The range is from '2' to '20' Note: Make sure to increase the number of database connections available depending upon this set value |
5 |
|
110 |
PR.SubscribeReferredCustomer |
Database |
Advanced Access |
Subscribe referred customer? |
Determines whether the profiler will subscribe the referred friend the referring customers' conversation ('TRUE') or not ('FALSE') |
FALSE |
|
109 |
PR.ValidateReferringCustomer |
Database |
Advanced Access |
Validate referring customer? |
Determines whether the profiler will validate the existence of the referring customer before accepting a referral ('TRUE') or not ('FALSE') |
FALSE |
|
312 |
SM.PrioritizeAOL |
Database |
Advanced Access |
Prioritize AOL domain to determine email client type |
Determines whether to prioritize AOL domain when computing the current email client ID ('TRUE') or not ('FALSE') |
FALSE TRUE |
|
304 |
SM.PrioritizeDomain |
Database |
Advanced Access |
Prioritize domain to determine e-mail client type |
Determines whether to prioritize domain in computing current e-mail client ID ('TRUE') or not ('FALSE') |
FALSE TRUE |
|
418 |
SYS.RealTimeViewerDumpCount |
Database |
Advanced Access |
Real Time Viewer Dump Count |
Indicates the number of consecutive real time viewer dumps that are kept in memory |
20 |
|
417 |
SYS.RealTimeViewerDumpInterval |
Database |
Advanced Access |
Real Time Viewer Dump Interval |
Defines the time interval (in seconds) between two consecutive real time viewer dumps |
30 |
|
381 |
TQ.AllRowsOptimization |
Database |
Advanced Access |
Use ALL_ROWS query hint |
Determines whether Connect will analize the tables in the schema and use the ALL_ROWS optimization provided by Oracle ('TRUE') or not ('FALSE') |
FALSE TRUE |
|
383 |
TQ.IncludeSeedList |
Database |
Advanced Access |
Include Seed list on every occurrence |
Determines whether the seed list members will receive emails for every segment and for every occurrence of a campaign and the corresponding follow-up messages ('TRUE') or not ('FALSE') |
FALSE TRUE |
|
384 |
TQ.TimeBeforeAllowCountDelete |
Database |
Advanced Access |
Period to restrict audience counts deletion |
Defines the time range (in minutes) to disallow the deletion of audience counts after starting count calculations. |
120 |
|
115 |
TR.LogConversionLevel |
Database |
Advanced Access |
Logging level for conversion |
Indicates the level that the tracker logs a conversion. There are three possible values:
|
1 2 3 |
|
285 |
WS.DeleteAssociateData |
Database |
Advanced Access |
Delete the associated information when a web service call fails? |
Determines whether, when a call to a web service fails, all associated information created during the web service transaction will be deleted ('TRUE') or not ('FALSE') |
FALSE TRUE |
|
161 |
DBM.AnalyzeSamplePercent |
Database |
Internal Access |
Cost-based optimizer statistical sample percentage (DBMS_STATS) |
Indicates the sample percentage used for each table when generating the cost-based optimizer statistics. This is applicable only when using DBMS_STATS package. |
0 |
|
160 |
DBM.AnalyzeThreshold |
Database |
Internal Access |
Cost-based optimizer statistical sample size (Analyze) |
Indicates the sample size used for each table when generating the cost-based optimizer statistics. This is applicable only when using ANALYZE command. |
10000 |
|
163 |
DBM.DefaultDomainTableCache |
Database |
Internal Access |
Default size for DomainTable's database cache |
Indicates the default size for DomainTable's database cache |
500 |
|
162 |
DBM.DefaultLinkTableCache |
Database |
Internal Access |
Default size for LinkTable's database cache |
Indicates the default size for LinkTable's database cache |
1500 |
|
427 |
DBM.GeoLocationOldRecors |
Database |
Internal Access |
Update Geolocation for old records |
Determines whether the GeoLocationManager should update geolocation for old click/open/conversion records with populated IP column ('TRUE') or not ('FALSE'). If marked 'TRUE', it will run within the time window that is defined by the system parameter DBM.UpdateGeoLocationTimeWindow. |
FALSE |
|
149 |
DBM.PMTransactionSize |
Database |
Internal Access |
Transaction Size for updating targeting tables |
Indicates the transaction size for database storage procedures updating targeting tables |
10000 |
|
150 |
DBM.ProfilerManagerEnabled |
Database |
Internal Access |
Enable Profiler Manager |
Determines whether Connect will call special database-stored procedures to update customer targeting tables ('TRUE') or not ('FALSE'). These tables include:
Note: The system parameter ProfilingTargetingDisabled cannot be set to 'FALSE' when this system parameter is set to 'TRUE' |
FALSE TRUE |
|
143 |
DBM.RetainLinkInfo |
Database |
Internal Access |
Number of days to keep links active |
Defines the amount of time (in days) to keep links active that are deployed in the aliaser.cache and visible from the nodes outside the firewall. Specify '0' if you wish the links to always be active. LINK_MASTER will never be purged. |
0 |
|
151 |
DBM.TableAnalyzerEnabled |
Database |
Internal Access |
Enable Table analysis to update statistics |
Determines whether Connect will run table analysis to update statistics ('TRUE') or not ('FALSE'). This is applicable only when using SQL Server database. |
FALSE TRUE |
|
142 |
DBM.TableAnalyzeSetting |
Database |
Internal Access |
Setting for computing table statistics |
Indicates the setting for computing table statistics. The values are:
|
1 |
|
426 |
DBM.UpdateGeoLocationTransactionSize |
Database |
Internal Access |
Update GeoLocation Transaction Size |
Indicates the transaction size for updating click and conversion history table with geolocation data |
10000 |
|
180 |
DBM.UseValuesFromInstanceLog |
Database |
Internal Access |
Include delivery failures to 'Total Msgs Sent','Total Bounced' (not recommended) |
Determines whether any delivery failures should be calculated from the Instance_Log table and added to 'Total Messages Sent' and 'Total Messages Bounced' ('TRUE') or not ('FALSE'). Note: This is not recommended, and this system parameter should be set to 'FALSE'. |
FALSE TRUE |
|
412 |
ETL.CheckForDuplicateRows |
Database |
Internal Access |
Check for duplicate rows |
Determines whether the ETL PL/SQL package checks for duplicate rows in ETL tables and marks them as errors (TRUE) or not (FALSE). |
FALSE |
|
306 |
PR.CheckFirstClick |
Database |
Internal Access |
Check first click? |
Determines whether the profiler updates "Messages Clicked" for the first click only (TRUE), or not (FALSE). If marked as 'FALSE', 'Messages Clicked' will equate to the number of links clicked. Note: Setting this system parameter as 'FALSE' will improve performance, but Messages Clicked is not calculated. |
FALSE |
|
307 |
PR.CheckFirstRead |
Database |
Internal Access |
Check first read? |
Determines whether duplicate "first reads" are filtered out from "HMTL Message Opened" ('TRUE') or not ('FALSE'). Note: If set to 'FALSE', no check for duplicates is performed. Performance is faster but the counts are less accurate. |
FALSE |
|
288 |
PR.ConversionUseInterest |
Database |
Internal Access |
Update conversion interest table |
Determines whether, if a conversion occurs with no interests, the interests will not be inherited from the matching link ('FALSE') or will be inherited ('TRUE'). Note: If set to 'FALSE', this allows the profiler to perform batch inserts into conversion_history which significantly increases profiler performance. |
FALSE |
|
310 |
PR.DemoUnknownValue |
Database |
Internal Access |
Demo unknown value |
Indicates the value used and displayed if the demographic information for the customer is unknown. |
UNKNOWN |
|
309 |
PR.DomainCacheTimeoutMinutes |
Database |
Internal Access |
Domain cache timeout in minutes |
Defines the amount of time (in minutes) when the profiler will flush its Domain Data cache |
10 |
|
291 |
PR.FetchBlockChronologically |
Database |
Internal Access |
Fetch profiler log chronologically |
Determines whether Connect will fetch next block of log data chronologically ('TRUE'), or randomly ('FALSE'). |
FALSE |
|
308 |
PR.LinkCacheTimeoutMinutes |
Database |
Internal Access |
Link cache timeout in minutes |
Defines the amount of time (in minutes) when the profiler will flush its Link Data cache |
10 |
|
305 |
PR.MaxEntriesPerBlockGroup |
Database |
Internal Access |
Max entries per block group |
Indicates the approximate number of entries that the profiler will process before committing them |
5000 |
|
428 |
PR.PopulateGeolocation |
Database |
Internal Access |
Populate geolocation information |
Determines whether the profiler will populate click/open/conversion geolocation information when entries are processed ('TRUE') or not ('FALSE'). |
FALSE |
|
311 |
PR.ProfileCustomerInterests |
Database |
Internal Access |
Enable customer interest statistics. |
Determines whether customer interest statistics are enabled ('TRUE') or not ('FALSE'). |
FALSE TRUE |
|
289 |
PR.ProfilerBounceAnalysis |
Database |
Internal Access |
Determine whether Profiler performs bounce analysis |
Determines whether the profiler will flag customers for bounce analysis ('TRUE') or not ('FALSE'). |
FALSE |
|
146 |
PR.ProfilerLogCheckInterval |
Database |
Internal Access |
Number of seconds for the Profiler to wait for storage |
Defines the amount of time ( in seconds) that the profiler will wait before checking for storage when there is no storage available. |
3 |
|
290 |
PR.ProfilerSuspend |
Database |
Internal Access |
Profiler suspend? |
Determines whether to suspend the profiler ('FALSE') or not ('TRUE'). Note: It is strongly suggested that this system parameter set only to 'FALSE' to keep the profiler operative. |
FALSE |
|
295 |
PR.ProfilingCustomerInterestOther |
Database |
Internal Access |
Enable customer interest statistics (other). |
Determines whether Connect will enable customer interest statistics for Tracker/Conversion/Receiver(N/A) log ('TRUE') or not ('FALSE') |
FALSE |
|
297 |
PR.ProfilingDailyAggEnabled |
Database |
Internal Access |
Enable Daily Aggregation |
Determines whether Connect will profile message daily aggregation ('TRUE'), or not ('FALSE') |
FALSE |
|
296 |
PR.ProfilingDemographicEnabled |
Database |
Internal Access |
Enable Demographic Profiling |
Determines whether Connect will profile message demographic aggregation ('TRUE') or not ('FALSE'). |
FALSE |
|
298 |
PR.ProfilingDomainAggEnabled |
Database |
Internal Access |
Enable Domain Aggregation |
Determines whether Connect will profile domain demographic aggregation ('TRUE') or not ('FALSE'). |
FALSE TRUE |
|
299 |
PR.ProfilingEnabled |
Database |
Internal Access |
Enable Profiling |
Determines whether profiling is enabled and creates a profiler log ('TRUE') or disabled ('FALSE'). |
FALSE |
|
292 |
PR.ProfilingHistoryOnly |
Database |
Internal Access |
Profiling History Table Only |
Determines whether Connect will only update (insert) history tables for click, reply and conversion ('TRUE') or not ('FALSE'). |
FALSE TRUE |
|
300 |
PR.ProfilingLinkReportingEnabled |
Database |
Internal Access |
Enable Profiling link for reporting |
Determines whether Connect will profile link for reporting ('TRUE'), or not ('FALSE'). Tables affected:
|
FALSE |
|
302 |
PR.ProfilingLinkTargetingEnabled |
Database |
Internal Access |
Enable Profiling link for targeting |
Determines whether Connect will profile link for targeting ('TRUE') or not ('FALSE'). Table affected:
|
FALSE |
|
399 |
PR.ProfilingSmppAggEnabled |
Database |
Internal Access |
Enable SMSC Aggregation |
Determines whether Connect will profile SMSC aggregation ('TRUE'), or not ('FALSE'). |
FALSE TRUE |
|
294 |
PR.ProfilingTargetingDisabled |
Database |
Internal Access |
Disable Targeting |
Determines whether the profiler will not update customer targeting tables ('TRUE'), or will update tables ('FALSE'). Tables include:
Note: This system parameter cannot be set to 'FALSE' when the system parameter ProfilerManagerEnabled is set to 'TRUE'. |
FALSE TRUE |
|
293 |
PR.ReplyHistoryDBCheck |
Database |
Internal Access |
Ignore duplicate Reply Log entries? |
Determines whether Connect will ignore duplicate reply log entries ('TRUE') or not ('FALSE'). Note: This will include an additional Database access for processing every reply log entry. |
FALSE |
|
147 |
PR.TrackerLogProcessTimeWindow |
Database |
Internal Access |
Hour range of day to process tracker log entries |
Specifies the time interval when it is appropriate to process tracker log entries. The format of the time frame is: HH:MM (start time) HH:MM (ending time) |
0:01 23:59 |
|
303 |
SM.EmailClientTypeDemo |
Database |
Internal Access |
E-mail client type demo |
Indicates the attribute name that Connect uses for 'Email Client Type'. |
Email Client Type |
|
380 |
TQ.FullCountThreshold |
Database |
Internal Access |
Full count threshold |
Indicates the maximum conversation size for which a full count will be performed for the campaign and segment audiences. Any audience size larger than this value will be estimated. |
10000000 |
|
382 |
TQ.UseEnhancedCustomerJoins |
Database |
Internal Access |
Use optimized joins for filters? |
Determines whether Connect will use optimized customer joins when building filters for audiences and segment models ('TRUE') or not ('FALSE'). |
FALSE TRUE |