(-Utilities
CONSOLE COMMANDS
Btrieve provides console commands that allow you to determine the file activity and the current level of utilization of the BSERVER process. You can execute these commands at the console of any file server in which a
BSERVERV AP is loaded.
The following sections describe the NetWare Btrieve console commands. Each description includes the following ~nformation:
• Command Format. This section presents the console command in the format in which it should be entered at the file server where BSERVER is loaded.
• Purpose. This section describes the uses of the command.
• How to Use (the Command). This section describes how to issue the command, and the command's results.
2011Revl.00 4-45
BACTIVE
Command Format B ACTIVE < Screen>
Description
The B ACTIVE console command allows you to list all Btrieve files that are currently open at a server, and to view the connection number (workstation) that has each file open and the lock types that are held for each file.
Btrieve will display the results of the command in a tabular format on the screen. The following information will be displayed for each file:
• The full pathname of the file
• The network connection number that has the file open
• The type of locks held for the file
You can use the connection number returned by B ACTIVE to determine which user has the file open. You can also use this number as a parameter in a B RESET command, a BUTIL -RESET command or a Btrieve Reset operation to close the files and release the resources ofa particular station.
If another V AP has the file open, B ACTIVE will display a two-character code for the connection number. For example, the two-character code for NetWare SQL is "NS". You cannot use this two character code as input for a B RESET command. Refer to the discussion of the B RESET command on page 4-50 for more information.
The codes for the three lock types are as follows:
4-46
(
(:~
How to use B ACTIVE
Utilities
BACTIVE
(Continued)
To run B ACTIVE, enter the command in the format shown above at the server where BSERVER. V AP is loaded.
Insert a blank space between B and ACTIVE. You can enter the command in either upper- or lower-case characters.
As long as there are more active files to display, B ACTIVE will display a message so indicating at the bottom of the screen. To see additional screens, re-enter the B ACTIVE command, substituting a number for <Screen> that corresponds to the screen you want to view. For example, to view the second screen of a B ACTIVE operation type the following:
B ACTIVE 2 <Enter>
2011Revl.00 4-47
BDOWN
Command Format BDOWN Description
The B DOWN console command releases all resources used by BSERVER, and terminates the BSERVER process. When you issue B DOWN, Btrieve will
• Close all Btrieve files open at the file server;
• Release all of the locks Btrieve holds at the file server;
• Abort any pending transactions at the file server;
• Halt the BSERVER process.
If you are running another V AP that uses BSERVER to access network files, you should take the following precautions before you issue the B DOWN command:
• Issue the B ACTIVE command to make sure that no files are open by another V AP.
• If any other V AP has Btrieve files open at the file server, you should issue the appropriate command for that V AP that closes its files and halts the process.
For example, if you were running NetWare SQL, you would issue the NS RESET and NS DOWN commands to make sure that all NetWare SQL files were closed. Mter you issue the B DOWN command, workstations and other V APs will not be able to access Btrieve files through BSERVER until the file server is restarted.
How to use B DOWN
To run B DOWN, enter the command in the format shown above at the server where BSERVER is loaded. Insert a blank space between B and DOWN. You can enter the command in either upper- or lower-case characters.
4-48 2011Revl.OO
)
'\ /
(-(
(
... ~.-'
Utilities
BOFF
Command Format B OFF
Description
The B OFF console command causes the previous Btrieve command line utility to stop refreshing the screen.
You should issue B OFF after B ACTIVE, B STATUS, or B USAGE have displayed the information you need. If you do not issue B OFF, these commands will continue to refresh the screen, even after you issue another command.
How to use B OFF
To run B OFF, enter the command in the format shown above at the server where BSERVER.VAP is loaded.
J n sert a blank space between B and OFF. You can enter the command in either upper or lower case.
2011Revl.OO 4-49
BRESET
Command Format
B RESET < connection number>
Description
The B RESET console command releases all resources used by a particular station on the network. When you issue a B RESET console command followed by a station's connection number, Btrieve
• Closes all open files at the station
• Releases all locks held by the station
• Aborts any pending transaction at the station How to Use B RESET
To run B RESET, enter the command in the format shown above at the server where BSERVER.V AP is loaded. Insert a blank space between Band RESET. You can enter the command in either upper- or lower-case
characters.
Substitute the connection number of the station that you want to reset for
<connection number>. For example, to release all resources for station 12, you would issue the following command at the server console:
B RESET 12 <Enter>
Use an asterisk (*) to denote all the Btrieve stations on the network, instead of a single station. To reset all the stations on the network that have Btrieve files open, issue the following command at the server console:
B RESET * <Enter>
The B RESET operation will not accept the two-character ASCII connection ID, which signifies a VAP, as input. To reset any files open by a VAP, you must use the appropriate reset command for that V AP.
4-50 201lRevl.00
(~
Utilities
BSTATUS
Command Format B STATUS Description
You can use B STATUS to help determine whether the level of resources allocated for BSERVER is the most efficient level for your environment.
B STATUS returns information about network requests, packet buffers, and the sessions in use for the file server where you issue the command. The command also returns the number of times the console screen has been refreshed since the command was issued.
How to Use B STATUS
To run B STATUS, enter the command in the format shown above at the server where BSERVERVAP is loaded. You may enter the command in either upper- or lower-case characters. Insert a blank space between each word.
When you execute B STATUS, Btrieve will display the following screen:
Status for NetWare Btrieve Server VAP vS.xx Current, Total requests processed:
nn nn
Available, Max request buffers:
nn nn
Available, Max SPX packet buffers:
nn nn
Unprocessed SPX packet buffers:
nn
Current, Total SPX packets received:
nn nn
Current, Total SPX packets sent:
nn nn
Current.Total SPX requests processed:
nn nn
Current, Max, Peak SPX sessions:
nn nn nn
Number of display iterations:
nn
201lRev1.00 4-51
BSTATUS
(Continued)
"Current" values are the values accumulated since the B STATUS command was issued, and are displayed in the first column. ''Total'' values are the values accumulated since BSERVER was loaded, and are displayed in the second column. "Max" values are the maximum values for the resource that are available in the network's current configuration, and are displayed in the second column. "Peak" values reflect the highest utilization of the resource since BSERVER was loaded. The following paragraphs describe the information returned by the B STATUS command.
"Current, Total requests processed" reflects the number of network requests processed by BSERVER from both workstations and other V APS, such as NetWare SQL.
"Available, Max request buffers" reflects the number of processes active for the V AP. For BSERVER, this value should always be 1.
"Available, Max SPX packet buffers" reflects the number of NetWare packet buffers available to BSERVER, and the maximum number available at the server.
"Unprocessed SPX packet buffers" reflects the difference between the
maximum number of NetWare packet buffers available at the server and the number available to BSERVER.
"Current, Total SPX packets received" reflects the number of network packets received by BSERVER from workstations.
"Current, Total SPX packets sent" reflects the number of network packets sent to workstations by BSERVER.
"Current, Max, Peak SPX sessions" reflects the number of BSERVER sessions in use, and the maximum number available to BSERVER.
''Number of display iterations" reflects the number of times the B STATUS
,
! 7
screen has been refreshed since the B STATUS command was issued. ./
4-52 201lRevl.OO
You can use B USAGE to help determine whether BSERVER is configured to the most efficient level for your environment.
The B USAGE console command returns information about the following Btrieve configuration options:
To run B USAGE, enter the command in the format shown above at the server where BSERVER.VAP is loaded. You may enter the command in either upper- or lower-case characters. Insert a blank space between Band USAGE. When you execute B USAGE, Btrieve will display the following screen:
Usage for NetWare Btrieve Server VAP vS.xx Current, Max, Peak files:
Current, Max, Peak handles:
Current, Max, Peak locks:
Current, Max, Peak transactions:
nn nn nn nn nn nn nn nn nn nn nn nn
"Current" values are the values that are currently in use, and are displayed in the first column. "Max" values are the maximum values for the resource that are available in the current BSERVER configuration, and are displayed in the second column. "Peak" values reflect the highest usage of the resource since BSERVER was loaded.
2011Revl.OO 4-53