Viewing All Indexes with an Active QIndex

You may find it necessary to change a queue assignment for several indexes. (For example, you may decide to change several deferred indexes to a non-deferred status.) Because you cannot change a queue assignment when there is an active QIndex on the deferred queue, you need to find out which index groups have an active QIndex. You can check to see if there is an active QIndex on the group of indexes you want to change by using the Search menu or by using the Display menu.

This section explains these topics:

Using the Search Menu to View All Indexes with an Active QIndex
Using the Display Button to View All Indexes with an Active QIndex

To use the Search menu to view all indexes with an active QIndex

1 Open the mq_index view in the Table Editor, or start the Indexes process.

The default location of this process is the Administration\Index Control Menu folder on the navigation bar.

2 Do one of these options to display the Search menu:
Press CTRL+F2.
Choose File, Search.
3 In the Indexes list, find and highlight Active:

4 In the Search for field, mark Yes.
5 Click OK.
6 Do one of these tasks:

If there is an active QIndex

If there is no active QIndex

Horizon displays the List Horizon Index Definitions window with all active mq_indexes displayed.

You can use the Display button to display additional information in the window. (For example, you can add the queue and active fields to display in the window.)

Horizon displays this message:

1 Click OK.
2 Click Cancel to close the Search menu.

To use the Display button to view all indexes with an active QIndex

1 Open the mq_index view in the Table Editor, or start the Indexes process.

The default location of this process is the Administration\Index Control Menu folder on the navigation bar.

Horizon displays the List Horizon Index Definitions window showing all of the indexes you have created.

2 Click Display.

Horizon displays the Set Columns and Properties for Display window.

3 In the Choose columns to display column, highlight Queue and Active.
4 Click OK.

Horizon redisplays the List Horizon Index Definitions window with the Queue and Active columns added to the window:

5 Use the scroll bar to find the index whose active queue status you want to view.

A check mark means QIndex is active for that index.

 


© 1998-2017 Sirsi Corporation