You can scroll or pause the information displayed on any of the sub-windows. Be aware that scrolling does not prevent SQLBase from writing new output to a sub- window. For example, if you are scrolling backwards and SQLBase has new output to write to the display, it will scroll forward to the end of the output and append the new information to the display.
To prevent SQLBase from writing new output to a window and interrupting you while scrolling, select the Pause menu command, and then select the name of the window to pause. A check mark indicates that the window is paused.
When you are finished scrolling, select the name of the window to un-pause from the
Pause menu command again. The check mark disappears, and output resumes.
Because all of the sub-windows (except the Process Activity window) display snapshots of the server’s status at any particular time, when you discontinue Pause, SQLBase updates the display with the latest information.
However, the Process Activity window displays a log, not a snapshot. It contains a record of the server’s activity over time. When you pause the display of this window, SQLBase buffers the output until you click Pause again; this un-pauses the displays. The limit to the amount of information that SQLBase can buffer is 500 lines. When the buffer becomes full, SQLBase “wraps” back to the beginning of the buffer and starts overwriting data. This means that the data being overwritten is lost. If you need to track large amounts of Process Activity data, you should log the data to a file using the File menus’ Open Log menu command.
There are seven menus in SQLBase Server Console: • File
• Pause
• Level
• Security
• Window
• Help
The following paragraphs describe these menus.
File
The File menu contains commands that control logging, GUI configuration, and exiting the server.
Open Log Opens a file and begins logging the Process Activity display to this file.
This command presents you with the File Open dialog box that lets you select an existing file, create a new file, or accept the default of sqllog.txt in the current directory. If the file you specify already exists, SQLBase asks you to confirm that you want to overwrite the file.
This command is equivalent to configuring the log keyword in the server’s SQL.INI file, or using SQLTalk’s SET
ACTIVITYLOG command. Close Log Closes the process activity log file.
Save Settings Saves the current SQLBase Server Console GUI-related settings to the server’s SQL.INI file. These settings include the:
• Position and size of the main window and all sub-windows • Display level
• Timestamp option setting
You can also use this option to save the server screen appearance between server launches.
For more about the specific keywords used in SQL.INI, read Configuration on page 5-21.
Clear Settings Removes any SQLBase Server Console GUI-related settings from the server’s SQL.INI file.
The next time you bring up the server, it uses the system defaults.
SQLBase Server Console
Database Administrator’s Guide 5-15
Display
The Display menu contains the commands that control the display of the sub- windows. If a sub-window is displayed, a check mark appears next to it on the menu.
Pause
The Pause menu controls whether each subwindow is paused. If a subwindow is paused, a check mark appears next to it on the menu.
Level
The Level menu contains commands that control the level of detail displayed on the Process Activity window. Only one of the five levels (0-4) can be active at a time. The currently-active level is indicated by a check mark next to it on the menu. These menu selections are equivalent to using SQLTalk’s SET PRINTLEVEL command.
If timestamps are enabled, a check mark appears next to the corresponding menu selection. This menu selection is equivalent to using SQLTalk’s SET TIMESTAMP ON/OFF command.
Exit Exits SQLBase Server.
If there are users connected to databases on the server, you are asked to confirm that you want to shut down the server. If you shut down the server while users are connected, all
transactions in progress are rolled back.
This menu item is disabled if SQLBase is running as an NT service.
Server Status Toggles the display of the Server Status window on and off.
Databases Toggles the display of the Databases window on and off.
Process Activity Toggles the display of the Process Activity window on and off.
System Activity Toggles the display of the System Activity window on and off.
All Displays all of the currently-closed windows.
None Closes all of the currently-displayed windows.
Level 0 Displays the installation of the server and database names on the network, as well as each database process’s creation and termination.
Note: If a database is encrypted, SQL statements will not be displayed, even though the
message level may be 1 or higher.
Security
The Security menu provides options for specifying and setting the server security password. For more, read Server security password on page 7-17.
Window
The Window menu provides options for displaying open sub-windows:
Help
Level 1 Displays all the information available at level 0 plus SQL statements and error numbers.
Level 2 Displays all the information available at level 1 plus the compile and execute processing steps, the ability to see the processing of individual cursors within a database process, and internal processing information.
Level 3 Displays all the information available at level 2 plus the fetch processing step and bind variable data. Level 4 Displays all the information at level 3 plus database
page locks.
Increase Level Increases the display level. Decrease Level Decreases the display level.
Show Timestamps Toggles the display of timestamps on the Process Activity window on and off.
Set Security Password Initially sets or specifies the server security password.
Change Security Password
Changes the server security password.
Tile Displays the sub-windows side-by-side so that the maximum amount of information is displayed.
Cascade Displays the sub-windows layered on top of one another so that only their title bars are visible (except the top-most one).
SQLBase Server Console
Database Administrator’s Guide 5-17