NAME

sfsadmin deactivate index - deactivates a secondary index

SYNOPSIS

sfsadmin deactivate index -server servername filename index [-deallocate]

ARGUMENTS

-server servername Specifies the name of the file server. The name must be registered with the DCE Directory Service. If the -server option is not specified, the default is the server defined by the environment variable ENCINA_SFS_SERVER. 

filename Specifies the name of the file containing the secondary index that is to be deactivated. 

index Specifies the name of the secondary index that is to be deactivated. 

[-deallocate] De-allocates the storage currently reserved for the specified index. If the -deallocate option is not specified, reserved space for the index remains allocated. 

DESCRIPTION

The sfsadmin deactivate index command stops all updates to the specified secondary index so that modifications to records in the file are no longer reflected in the index. The records in the file are no longer accessible through the inactive index. Deactivated indices can improve performance since the SFS does not apply record updates to an inactive index. The index can be reactivated with the sfsadmin rebuild index command. 

EXAMPLE

The following command deactivates the secondary index zipCodeIndex in the file Accounts, releasing the disk space reserved for it so that other files can use the space. 

% sfsadmin deactivate index Accounts zipCodeIndex -deallocate

PRIVILEGE REQUIRED

Encina SFS administer (A) and exclusive open (E) permissions on the file

RELATED INFORMATION

sfsadmin add index

sfsadmin delete index

sfsadmin expand index

sfsadmin query index

sfsadmin rebuild index

sfsadmin rename index

  —  March 1997