NAME

sfsadmin query file - displays status and storage information about a file

SYNOPSIS

sfsadmin query file -server servername filename

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 about which information is requested. 

DESCRIPTION

The sfsadmin query file command displays status and storage information about a file, including

The file name and type of file. 

The name, data type, and size of each record field. 

The names and keys of the primary index. 

The names of the secondary indices. 

The maximum and current number of records in the file. 

This information is not transactionally consistent; that is, the data may reflect incomplete transactions. For example, the number of records displayed may include records that have been inserted but not yet committed. 

EXAMPLE

The following command displays information about the relative file Inventory. The file’s primary index orders the records by stock number. The file has one secondary index named productNameIndex. 

% sfsadmin query file

File name: Inventory
File organization: relative
Record fields:
Name: stockNum, Type: unsignedInt32
Name: quantity, Type: unsignedInt32
Name: price, Type: unsignedInt32
Name: productName, Type: string, Size: 20
Name: vendorName, Type: string, Size: 16
Name: comments, Type: varLenByteArray, Size: 50
Primary index name: stockNumIndex
Index fields:
 Name: stockNum, Ordering: ascending
Volume: sfsDataVol, Allocated pages: 8, Utilized pages: 1
Max number of records: 500
Number of records: 300
File state: file OK
Creation time: Tue Dec  7 11:33:05 1993
Last read time: Tue Dec  7 11:33:05 1993
Last write time: Tue Dec  7 11:34:22 1993
Last administer time: Tue Dec  7 11:33:06 1993
Secondary indices:
 productNameIndex

PRIVILEGE REQUIRED

Encina SFS query (Q) permission on the file

RELATED INFORMATION

sfsadmin copy file

sfsadmin destroy file

sfsadmin empty file

sfsadmin expand file

sfsadmin list files

sfsadmin rename file

  —  March 1997