Example: Flattening Text Index Updates

Update all text indexes for the product line HCM every 120 minutes, and flatten the update sequence. The results will be similar to those shown below.

Command Run

dbtextindex –U –i 120 hcm

Result

CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'CANDCANDSRCH2', 'UPDATE 
     FREQUENCY 0 0,2,4,6,8,10,12,14,16,18,20,22 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'CANDCANDSRCH3', 'UPDATE 
     FREQUENCY 2 0,2,4,6,8,10,12,14,16,18,20,22 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'CANDKEYWORDSEARCH', 'UPDATE 
     FREQUENCY 5 0,2,4,6,8,10,12,14,16,18,20,22 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'CANDSKILLSEARCH', 'UPDATE 
     FREQUENCY 8 0,2,4,6,8,10,12,14,16,18,20,22 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'CANDCANDSRCH4', 'UPDATE 
     FREQUENCY 11 0,2,4,6,8,10,12,14,16,18,20,22 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'CANDCANDSRCH6', 'UPDATE 
     FREQUENCY 13 0,2,4,6,8,10,12,14,16,18,20,22 * * *');
. . . 
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'EECRDAFILE', 'UPDATE 
     FREQUENCY 53 0,2,4,6,8,10,12,14,16,18,20,22 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'EMDOCDFFILE', 'UPDATE 
     FREQUENCY 55 0,2,4,6,8,10,12,14,16,18,20,22 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'EEEDUAFILE', 'UPDATE 
     FREQUENCY 58 0,2,4,6,8,10,12,14,16,18,20,22 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'HEIDNIDNDFILE', 'UPDATE 
     FREQUENCY 1 1,3,5,7,9,11,13,15,17,19,21,23 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'HRORUHRORUPUSDFS', 'UPDATE 
     FREQUENCY 4 1,3,5,7,9,11,13,15,17,19,21,23 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'HJBCCJDDFILE', 'UPDATE 
     FREQUENCY 6 1,3,5,7,9,11,13,15,17,19,21,23 * * *');
. . .
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'CSASAGDUFILE', 'UPDATE 
     FREQUENCY 51 1,3,5,7,9,11,13,15,17,19,21,23 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'TRTSKEAFILE', 'UPDATE 
     FREQUENCY 54 1,3,5,7,9,11,13,15,17,19,21,23 * * *');
CALL SYSPROC.SYSTS_ALTER('LMAJGHCM2', 'EMPWAKEYWORDSEARCH', 'UPDATE 
     FREQUENCY 57 1,3,5,7,9,11,13,15,17,19,21,23 * * *');