If you manipulate any of the server windows to a customized setting, you can save this configuration. You can also save specific display levels and timestamp settings. To save these configurations, use the Save Settings option of the server’s File menu.
Scrolling and pausing
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.
GUI Server Interface
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 on 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 six menus on the SQLBase Server Display: • File • Display • Pause • Level • Window • Help
The following paragraphs describe these menus.
File
The File menu contains commands that control logging, sql.ini configuration settings, 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.
Display
The Display menu contains the following 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.
Save Settings Saves the current GUI server-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 PM server screen appearance between server launches.
Clear Settings Removes any GUI server-related settings from the server’s sql.ini file.
The next time you bring up the server, it uses the system defaults.
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.
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.
GUI Server Interface
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.
Window
The Window menu provides options for displaying open sub-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.
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 & Level 4
Displays all the information available at level 2 plus the fetch processing step and bind variable data.
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.
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).
Help
The Help menu provides the following information: