db2ts RESET PENDING command

Issues a SET INTEGRITY statement for all text-maintained staging tables that are associated with a particular table. Certain commands cause the Db2® Text Search staging tables to go into pending mode, which blocks other database or text search operations. If you use the db2ts RESET PENDING command, you do not have to find all text indexes and associated staging tables and then issue a SET INTEGRITY statement for each table.

After detaching a data partition, you must issue the RESET PENDING command to update the staging-table content.

Authorization

This command requires the SYSTS_MGR role and at least one of the following authorities or privileges:
  • DATAACCESS authority
  • CONTROL on the base table on which the text index is created
Note: Currently ALL privileges are granted to the SYSTS_MGR to allow for the creation or dropping of new index tables. However, if a dependent object like an index is implicitly created on the index table, then authorization is not propagated. To delete the dependent object, grant CONTROL privilege to the user.

Required connection

You must issue this command from the Db2 database server.

Command syntax

Read syntax diagramSkip visual syntax diagramRESET PENDING FOR TABLE table-schema.table-name FOR TEXT |connection-options|
Connection-options
Read syntax diagramSkip visual syntax diagramCONNECT TOdatabase-nameUSERuseridUSINGpassword

Command parameters

table-name
The name of the table for which the text-maintained staging infrastructure was added and for which integrity processing is required.
table-schema
The schema of the table for which a command was issued that resulted in a pending mode.

Usage notes

Use the RESET PENDING command after issuing a command that causes the underlying tables to be put into pending mode, such as the LOAD command with the INSERT parameter, or after issuing a command that requires a SET INTEGRITY statement to refresh dependent tables, such as the ALTER TABLE ... DETACH statement.