ADMINISTERING


Using console commands to manage inline view indexing

Use server console commands to monitor and manage inline view indexing.

About this task

Table 1. Console commands to manage inline view indexing
CommandDescription
tell inlineindex show <database> <view>Shows views in a database that are enabled for inline viewing indexing with Updall. Use the <view> argument to see whether a specific view is enabled for inline view indexing with Updall.
tell inlineindex disableTemporarily disables inline view indexing for open databases.
tell inlineindex enableEnables inline view indexing for open databases after temporarily disabling it.
tell inlineindex refreshRefreshes all view indexes that were enabled for inline view indexing with Updall.
show dbs * inlineShows the view expiration period for open databases that are enabled for inline view indexing. Lists all open databases with views that are enabled for inline view indexing and the number of views that are enabled in each database.
show dbs * inline viewsShows the same output as show dbs * inline, but adds information about each view that is enabled for inline view indexing.
dbcache show inlineShows view expiration periods for closed databases that are enabled for inline view indexing. Lists all closed databases with views that are enabled for inline view indexing and the number of views that are enabled in each.
dbcache show inline viewsShows the same output as dbcache show inline, but adds information about each view that is enabled for inline view indexing.
show stat database.inline*Shows statistics for databases with views that use inline indexing.

Example

show dbs * inline


sho dbs * inline views
dbcache show inline
dbcache show inline views
Key to output labels

Table 2. Key to output labels
Output labelDescription
IDView NoteID associated with the index.
NumIndexesThe current number of open indexes.
TypeThe type of inline index, Static or Design enabled.
StateEnabled (open and in use) or Disabled (index disabled due to issue listed in the Info column.
AccessorsThe number of active open databases references to the index.
InactiveThe number of minutes the index has not been actively updated.
AccessedThe last time the index was actively updated.
InfoWhy an index is disabled. An index can be disabled for a variety of reasons, for example if the operations on the database are not compatible with inline view indexing.

Parent topic: Enabling and managing inline view indexing

Related tasks
Enabling inline view indexing with the Updall task
Enabling inline view indexing with INLINE_VIEW_INDEX setting
Setting index expiration for inline view indexes
Showing inline indexing statistics
Disabling inline view indexing
Showing inline indexing statistics