How To
Summary
When updating or repriming an Omnfind index the update job may get stuck with
SQ20427 Error occurred during text search administrative procedure.
Message code: IQQD0005E. Exception oss::BaseException:
'IQQD0005E The collection /QOpenSys/QIBM/ProdData/TextSearch/server1/config/collections/.... is closed.'
Steps
Either increase the UPDATEAUTOCOMMIT value from the Default of 100 significantly or disable autocommit with value 0.
e.g.
CALL SYSPROC.SYSTS_ALTER('indexSchema','indexName',
'INDEX CONFIGURATION(UPDATEAUTOCOMMIT 10000)');
In GUI the parameter is labeled "Commit interval on index update"
The general rule is to set it larger if you have large number of rows in a table.
Related Information
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"Omnifind","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
18 December 2019
UID
ibm10717297