Property UpdateFrequency

Namespace

YndigoBlue.Velocity.Data.DB2

Assembly

YndigoBlue.Velocity.dll

UpdateFrequency

Gets or sets the update frequency schedule for full-text indexes on DB2 databases.

public string UpdateFrequency { get; set; }

Property Value

string

Remarks

This property controls when DB2's full-text index maintenance tasks are executed. The schedule uses a compact notation to specify the days, hours, and minutes when indexes should be updated:

• d(n,n,...) - Days of the week (0=Sunday, 1=Monday, ..., 6=Saturday)
• h(n,n,...) - Hours of the day in 24-hour format (0-23)
• m(n) - Minutes past the hour (typically 0)

The default schedule "d(0,1,2,3,4,5,6) h(0,12) m(0)" updates indexes every day at midnight (00:00) and noon (12:00).

This property works in conjunction with UpdateMinimum, which specifies the minimum number of changes required to trigger an index update. Both values are loaded from the connection's context settings when the connection is initialized.

To update indexes only on weekdays at midnight:

var conn = new DB2DatasourceConnection
{
    Hostname = "localhost",
    Port = 50000,
    Database = "SAMPLE",
    Username = "db2admin",
    Password = "mypassword",
    UpdateFrequency = "d(1,2,3,4,5) h(0) m(0)"  // Mon-Fri at midnight
};