Regenerate IR keys

Applies to User Roles:

System Administrator

You need to run an IR Regen only in the following cases:

  • If you are changing an IR key (adding or removing a field);
  • If you are changing global IR configurations, for example, the stop words file, the techterms file, and language definition files;
  • If you have found an IR index corruption.

When needed, perform an IR Regen against a specific file or against all IR indexed files in the system.

Note: You can perform an IR Regen by using the System Definition or the Database Dictionary utility.

To regenerate the IR index for a table using System Definition:

  1. Log in to the Service Manager Windows client.
  2. Click System Definition > Tables.
  3. Double-click the name of the table containing the IR key you want to regenerate.
  4. From the Table management section, click Regenerate IR index.

    Note: This option is only available for tables that contain an IR key.

  5. Specify the regeneration parameters, and then click OK.

To regenerate the IR index for a table using Database Dictionary:

  1. Log in to the Service Manager Windows or web client.
  2. Click Tailoring > Database Dictionary.
  3. In the Table field, type the table name (for example, incidents), and click Search.

    The table details form opens.

  4. From the table details form, click More or the More Actions icon, and select Regen IR.

  5. Click OK to run the IR Regen immediately or click the Schedule button to run it at a later time.

Note: When you run an IR Regen, Service Manager needs to clear the current indexes. This causes a delete to the back-end database. When Service Manager attempts to delete a large set of records, the database could run out of space for this activity and cause an error. Each supported database platform provides some type of transaction or undo log to back up data changes and allow a rollback in case of errors. If you encounter such an error, contact your database administrator and ask them to increase the size available for this purpose.

Some examples of the errors you could encounter are:

Oracle: SQL code=30036 message=ORA-30036: unable to extend segment by % in undo tablespace

SQL Server SQL State: 42000-9002 Message: [Microsoft][SQL Native Client][SQL Server]The transaction log for database '%' is full

DB2 SQL State: 57011--964 Message: [IBM][CLI Driver][DB2/NT] SQL0964C The transaction log for the database is full. SQLSTATE=57011

Related topics

IR Expert
System Definition utility
Regenerating database keys

Regenerate database keys
Regen a database dictionary
Access IR Expert
Enable IR search for a file