NAME

sfsadmin query index - displays information about the secondary index of a specified file

SYNOPSIS

sfsadmin query index -server servername filename index

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. 

index Specifies the name of the secondary index about which information is being requested. 

DESCRIPTION

The sfsadmin query index displays storage and status information about the specified secondary index. This information includes the index name, whether the index is active or inactive, whether duplicate key values are allowed, key fields for the index, the volume on which the index resides, disk space allocated and used, and number of entries. 

EXAMPLE

The following command displays information about the secondary index productNameIndex in the file Inventory :

% sfsadmin query index Inventory productNameIndex

Index name: productNameIndex
Active: yes, Unique: yes
Index fields:
 Name: productName, Ordering: ascending
Volume: sfsDataVol, Allocated pages: 8, Utilized pages: 1
Number of entries: 187
Btree level: 4
Number of leaves: 32

PRIVILEGE REQUIRED

Encina SFS query (Q) permission on the file

RELATED INFORMATION

sfsadmin add index

sfsadmin deactivate index

sfsadmin delete index

sfsadmin expand index

sfsadmin rebuild index

sfsadmin rename index

  —  March 1997