Update services start during db2text start. These services update the text index automatically at the specified times. Note that the text index is not immediately synchronized with the user table.
During index creation, you can specify how often Update Services check if an update of the index is required by using the following command:
db2text create index DB2EXT.TITLE for text on DB2EXT.TEXTTAB (TITLE) UPDATE FREQUENCY D(1,3) H(0,12) M(0) update minimum 5
In this example, every Monday and Wednesday at 12 p.m. and 12 a.m. the Update Services wake up and check if there is some work to be completed on index db2ext.title. Note that there need to be at least five changes before the automatic index update can start to synchronize with the database.
See CREATE INDEX for more details on the parameters.
In a partitioned database environment, the update services only start on one node.
Note |
---|
Using UPDATE FREQUENCY every minute brings a high workload on your machine. To avoid this, only use UPDATE FREQUENCY for a very limited number of indexes. |