Microkernel Monitor Help Content
MicroKernel Monitor Help Contents

The following Help Topics are available:

Main Window

General information about the Monitor utility.

MicroKernel Active Files Dialog

All files currently opened by the MicroKernel engine.

MicroKernel Active Users Dialog

All users currently accessing the MicroKernel engine.

MicroKernel Resource Usage Dialog

General MicroKernel resource usage statistics.

MicroKernel Communications Statistics Dialog

Resource usage by the MicroKernel communications component.

Settings Dialog

View / Change current settings for the Monitor utility.

About Dialog

Product information about the Monitor utility.

For Help on Help, Press F1


Pervasive Software Monitor Help Content
Pervasive Software Monitor Help Contents

The following Help Topics are available:

Main Window

General information about the Monitor utility.

MicroKernel Active Files Dialog

All files currently opened by the MicroKernel engine.

MicroKernel Active Users Dialog

All users currently accessing the MicroKernel engine.

MicroKernel Resource Usage Dialog

General MicroKernel resource usage statistics.

MicroKernel Communications Statistics Dialog

Resource usage by the MicroKernel communications component.

SQL Active Sessions Dialog

Active sessions logged into the Scalable SQL engine.

SQL Resource Usage Dialog

General Scalable SQL resource usage statistics.

SQL Communications Statistics Dialog

Resource usage by the Scalable SQL communications component.

Settings Dialog

View / Change current settings for the Monitor utility.

Connect Dialog

Connect to remote file server.

Disconnect Dialog

Disconnect from remote file server.

About Dialog

Product information about the Monitor utility.

For Help on Help, Press F1


Microkernel Main Help
MicroKernel Database Engine Monitor

The MicroKernel Database Engine Monitor utility enables you to monitor various resources being used by the MicroKernel. These resources include:

- Detailed information about open files

- Detailed information about active users

- Current, peak, and maximum values for files, handles, locks, transactions,  etc.

- Current, peak, and maximum values for various remote communications statistics

The right-hand portion of the tool bar at the botton of the main window indicates which server is being monitored.  When the local server is being monitored, Local is displayed. When connected to a remote server, the name of the remote server is displayed.

See the Help Contentsfor a brief description of all of the dialog boxes available in the Monitor utility. You can view many of these dialogs at the same time. You can display and move between several dialog boxes at one time. Each dialog enables you to manually or automatically refresh the information.


SQL Main Help
Pervasive Software Monitor

The Pervasive Software Monitor utility allows you to monitor various resources being used by the Scalable SQL and MicroKernel engines. These resources include:

- Detailed information about active sessions, files, users

- Current, peak, and maximum values for open dictionaries, views, sessions, etc.

- Current, peak, and maximum values for various remote communications statistics

The right-hand portion of the tool bar at the botton of the main window indicates which server is being monitored.  When the local server is being monitored, Local is displayed. When connected to a remote server, the name of the remote server is displayed.

See the Help Contents for a brief description of all of the dialog boxes available in the Monitor utility. You can display and move between many of these dialogs at the same time. Each dialog allows you to either manually or automatically refresh the information.


Settings Dialog Help

The Settings dialog enables you to view or change several Monitor utility configuration options. To adjust database-specific settings, use the Setup utility. Below is a description of each of the Monitor utility settings:

Save Settings on Exit:

Select this check box to save all configuration settings when you close the Monitor utility. The Monitor utility saves both the settings in this dialog and the automatic-refresh option in the various dialog boxes.

Save Window Layout on Exit:

Select this check box to save the state (open or closed) and screen location of all open windows. When you start the Monitor utility again, these windows are automatically opened and positioned for local file server monitoring. This enables you to easily reproduce your preferred layout.

Refresh Rate:

This option allows you to specify how often the Monitor utility updates the information on any open dialogs where the automatic-refresh option is enabled.

OK Button:

Saves the selected settings.

Cancel Button:

Closes without saving any changed settings.

Help Button:

Shows help for this dialog.


About Dialog Help

The About dialog displays various product information, including the name, version, and copyright of the Monitor utility.


MicroKernel Active Files

The Active Files dialog shows information about all files which are currently opened by the MicroKernel engine.

Active MicroKernel Files:

Shows the number of active files.

Active MicroKernel Files List:

Contains the complete path of all open files. Select the file from this list for which you want to see detailed information.

File Information:

Contains file specific information for the currently selected file in the Files list.

Page Size:

Shows the internal page size of the selected file.

Read-Only Flag:

Indicates whether the file is marked read-only by the operating system.

Record Locks:

Indicates whether or not any of the active handles for the selected file have record locks. Any application can read a locked record, but only the application that placed the lock can modify or delete the record. A record lock exists only as long as the application that opened the file is updating a record. Yes indicates that one or more record locks are applied to the file; No indicates that no records are locked.

Transaction Lock:

Indicates whether any of the active handles for the selected file have a transaction lock. A transactional file lock exists only as long as the application that opened the file is processing a transaction.

Current Files Handles:

Shows the number of active handles for the selected file. A handle is one instance of a file being opened.

Current Files Handles List:

Contains the active handles associated with the selected file. Each handle is represented by either a user name (typically the login ID of the user) or an index into the engines client (user) list.  Select the handle from this list for which you want to see detailed information.

Handle Information:

Contains handle-specific information for the currently selected handle in the Handle list.

Connection Number:

Displays the network connection number of the client. If the client does not have a network connection, this field displays NA (for not applicable).

Task Number:

Contains the process-supplied task number for the processes originating at the file server, a Windows workstation, or an OS/2 workstation. For DOS workstations, this field displays the dynamic socket number.

Site:

Displays the location of the user process (local or remote).

Network Address:

Displays an identifier representing the location of the calling process on the network. If the calling prossess is SPX, the network node/network address will be preceded by S:.  For example,

S: 65666768 00000000001.  If the calling process is TCP/IP, the dotted-decimal notation will be preceded by T:.  For example, T: 180.150.1.24.

Open Mode:

The method the application uses to open the specified handle to the file. Possible methods include:

- Accelerated

- Exclusive

- Normal

- Read-only

- Verify.

When applicable, the open modes are specified as non-transactional or shared locking.

Record Lock Type:

Indicates the type of record lock(s) currently held by this handle. Possible values include:

- Single

- Multiple

- None.

Wait State:

Indicates whether the user is waiting due to some type of lock on this handle.  Possible values include:

- Waits for File Lock

- Waits for Record Lock

- None.

Transaction State:

Indicates the current type of transaction lock held by this handle. Possible values include:

- Concurrent

- Exclusive

- None.

Automatic Refresh Checkbox:

Select this check box to automatically update the information in the dialog every few seconds. You can change the refresh time for all dialogs in the Settings Dialog .

Refresh Button:

Manually refreshes the information.

Close Button:

Closes the dialog.

Help Button:

Shows help for this dialog.


Microkernel Active User
MicroKernel Active Users

The Active Users dialog shows information about all users currently accessing the MicroKernel engine.

Active MicroKernel Users:

Shows the number of active clients.

Active MicroKernel Users List:

Contains all of the active clients using the engine. Each client is represented by either a user name (typically the login ID of the user) or an index into the engines client (user) list.

Select the client from this list for which you want to see detailed information.

User Information:

Contains client (user) specific information. This information corresponds to the currently selected user in the User list.

Connection Number:

Displays the network connection number of the client. If the client does not have a network connection, this field displays NA (for not applicable).

Task Number:

Contains the process-supplied task number for the processes originating at the file server, a Windows workstation, or an OS/2 workstation. For DOS workstations, this field displays the dynamic socket number.

Site:

Displays the location of the user process (local or remote).

Network Address:

Displays an identifier representing the location of the calling process on the network. If the calling prossess is SPX, the network node/network address will be preceded by S:.  For example,

S: 65666768 00000000001.  If the calling process is TCP/IP, the dotted-decimal notation will be preceded by T:.  For example, T: 180.150.1.24.

Locks Used:

The number of locks currently being used by this user.

Transaction State:

Indicates the current type of transaction lock held by this handle. Possible values include:

- Concurrent

- Exclusive

- None.

Records Read:

The number of records this user has read since they first opened a file.

Records Inserted:

The number of records this user has inserted.

Records Deleted:

The number of records this user has deleted.

Records Updated:

The number of records this user has updated.

Disk Accesses:

The number of times this user has required a disk access.  You will not see any information for disk accesses for files that have just been opened.

Cache Accesses:

The number of times this user has required a cache access.

Selected Users Handles:

Shows the number of active handles for the selected user. A handle is one instance of a file being opened.

Selected Users Handles List:

Contains the active handles associated with the selected user. Each handle is represented by the filename associated with that handle.

Handle Information:

Contains handle specific information for the currently selected handle in the Handle list.

Open Mode:

The method the application uses to open the specified handle to the file. Possible methods include:

- Accelerated

- Exclusive

- Normal

- Read-only

- Verify.

When applicable, the open modes are specified as non-transactional or shared locking.

Record Lock Type:

Indicates the type of record lock(s) currently held by this handle. Possible values include:

- Single

- Multiple

- None.

Wait State:

Indicates whether the user is waiting due to some type of lock on this handle.  Possible values include:

- Waits for File Lock

- Waits for Record Lock

- None.

Transaction State:

Indicates the current type of transaction lock held by this handle. Possible values include:

- Concurrent

- Exclusive

- None.

Automatic Refresh Checkbox:

Select this check box to automatically update the information in the dialog every few seconds. You can change the refresh time for all dialogs in the Settings Dialog .

Delete Current User Button:

Deletes the currently selected user.

Delete All Users Button:

Deletes all of the current MicroKernel users.

Refresh Button:

Manually refreshes the information.

Close Button:

Closes the dialog.

Help Button:

Shows help for this dialog.


MicroKernel Resource Usage

The Resource Usage dialog shows information about various resources used by the MicroKernel engine. The maximum, peak, and current values are shown for each statistic.

Files:

Indicates the number of active files. You set the maximum for this field when configuring the MicroKernel with the Setup utility (Open Files option).

Handles:

Indicates the number of active handles. The MicroKernel creates a handle each time a user opens a file; therefore, a single user can have several handles for the same file. You set the maximum for this field when configuring the MicroKernel with the Setup utility (Handles option).

Clients:

Indicates the number of clients accessing the MicroKernel. A workstation can have multiple clients accessing the engine simultaneously. You set the maximum for this field with the Setup utility (Active Clients option).

Worker Threads:

Indicates the number of concurrent MicroKernel processes. You set the maximum for this field when configuring the MicroKernel with the Setup utility (Worker Threads option).

Licenses in Use:

Indicates the number of users as defined by your licensing agreement. In this case, the maximum shows the number of users your licensing agreement allows.

Transactions:

The number of transactions currently in use.  The maximum for this field is unlimited.

Locks:

Indicates the number of record locks.  The maximum for this field is unlimited.

Automatic Refresh Checkbox:

Select this check box to automatically update the information in the dialog every few seconds. You can change the refresh time for all dialogs in the Settings Dialog .

Refresh Button:

Manually refreshes the information.

Close Button:

Closes the dialog.

Help Button:

Shows help for this dialog.


Microkernel Communication Statistics
MicroKernel Communications Statistics

The Communications Statistics dialog shows information about communication between the MicroKernel and remote clients. A total for all protocols and  protocol specific information is displayed.  You can view protocol specific information for  SPX, TCP/IP and a second SPX or TCP/IP.  The second SPX or TCP/IP will be displayed as SPX(2) or TCP/IP(2).  Below is a list of the controls in this dialog and their function:

Total Requests Processed:

Indicates the number of requests the Communications Server handles from workstations or remote, server-based applications for all communication protocols.  Total indicates the number of requests processed since the Communications server was loaded.  Delta indicates the number of requests since you first invoked the Communications Statistics dialog. To reset this number to zero, click the Reset Delta button.

SPX Requests Processed:

Indicates the number of requests the Communications Server handles from workstations or remote, server-based applications for SPX.  Total indicates the number of requests processed since the Communications server was loaded.  Delta indicates the number of requests since you first invoked the Communications Statistics dialog. To reset this number to zero, click the Reset Delta button.

TCP/IP Requests Processed:

Indicates the number of requests the Communications Server handles from workstations or remote, server-based applications for TCP/IP.  Total indicates the number of requests processed since the Communications server was loaded.  Delta indicates the number of requests since you first invoked the Communications Statistics dialog. To reset this number to zero, click the Reset Delta button.

Communications Threads:

Indicates the number of remote requests that the MicroKernel is currently processing. Local requests are not included in this statistic. For the total number of remote and local threads being processed, see the Resource Usage dialog. You set the maximum for this field when configuring the Communications Server with the Setup utility (the Number of Communications Threads option).

Communications threads are also used to process Monitor utility requests, so you may not see the number of current worker threads drop below one. This is normal.

Total Remote Sessions:

Indicates the number of remote workstations connected to the Communications Server for all communication protocols. You set the maximum for this field when configuring the Communications Server with the Setup utility (the Number of Sessions option).

SPX Remote Sessions:

Indicates the number of remote workstations connected to the Communications Server through SPX.

TCP/IP Remote Sessions:

Indicates the number of remote workstations connected to the Communications Server through TCP/IP.

Automatic Refresh Checkbox:

Select this check box to automatically update the information in the dialog every few seconds. You can change the refresh time for all dialogs in the Settings Dialog .

Refresh Button:

Manually refreshes the information.

Reset Delta Button:

Manually resets the Delta count to zero for Total Requests Processed, SPX Requests Processed and TCP/IP Requests Processed.

Close Button:

Closes the dialog.

Help Button:

Shows help for this dialog.


SQL Active Users
SQL Active Sessions

The Active Sessions dialog displays information about all currently active sessions.

Active Sessions List:

A list of the user names associated with each active session. Because a user can have multiple sessions, the names in this list are not necessarily unique. Selecting an item in this list will update the information in the Session Information Group box. You can view all active sessions or filter them based upon the Database Name or Dictionary Location logged into the active sessions.

Filter Sessions by Login Access:

To filter the active sessions, select the Filter Sessions by Login Access check box. You can now select either all sessions from one database name or from one dictionary. Simply click the database name in the Database Names list or the dictionary location in the Dictionary Locations list, and the corresponding active sessions appear in the Active Sessions list. (Dictionary locations list the full pathname and appear in alphabetic order.)

If you clear the Filter Sessions by Login Access check box, the dialog displays all sessions and disables the database name and dictionary location controls.

Database Names:

Only enabled if the Filter Sessions check box is selected. Contains a list of all of the Database Names logged into by any currently active sessions.

Dictionary Locations:

Only enabled if the Filter Sessions check box is selected. Contains a list of all of the Dictionary Locations logged into by any currently active sessions.

Session Information:

The top of the Active Sessions box displays the number of active Scalable SQL sessions for the currently selected username in the Active Sessions list. If you have applied a filter, then the number of active sessions displayed only pertains to the specified database name or dictionary. A session is formed when an application or task logs in to a database.

Login Time:

The time at which this session was created via a Scalable SQL login operation.

Login Access:

The access path for this sessions login. Contains either Database Name or Dictionary Location.

Database Name:

The contents of this field is based on the Login Access.  If the login is based on a database name, this field displays the database name specified on the login.  If the login is based on a dictionary path and the dictionary is not asscociated with a database name, this field will be empty.  If the login is based on a dictionary path and the dictionary is associated with a single database, this field will show the database name.  If the login is based on a dictionary path and the dictionary is associated with multiple database names, then this field will be empty.

Dictionary Location:

The contents of this field is based upon the Login Access.  If the login is based on a database name, this field will display the path that is associated with the database name.  If the login is based on a dictionary path, this field will display the path that the engine used to login to the database.

Compatibility Mode:

Displays the compatibility mode being used in the current session. Possible values are 3.01 (for Scalable SQL v3.01 compatibility) or 4.0.

Integrity Enforcement:

Indicates whether or not integrity constraints are enforced on the database for the current session.

Bound:

Indicates whether or not the database currently accessed by the current session is a bound database.

Current Operation:

Indicates the SQL API function most recently called by this session.

MicroKernel Calls:

The number of function calls this session has made to the MicroKernel engine.

Active Transactions:

Indicates whether or not this session is currently within a transaction.

Network Address:

Displays an identifier representing the location of the calling process on the network. If the calling prossess is SPX, the network node/network address will be preceded by S:.  For example,

S: 65666768 00000000001.  If the calling process is TCP/IP, the dotted-decimal notation will be preceded by T:.  For example, T: 180.150.1.24.

Number of Views:

Indicates the number of active views, which are shown in the list box.

View Information:

The View Information box displays current information about all the views the selected session is accessing.

View Name:

The name of the stored view, if one has been recalled.

Temporary Sort:

Indicates with a Yes or No whether or not a temporary sort order is active for that view.

Explicit Lock:

Indicates with a Yes, No or Pending whether or not explicit locks have been issued for that view.

Table Names:

Lists the number of tables and the name of each table in the specified view.

Automatic Refresh Checkbox:

Select this check box to automatically update the information in the dialog every few seconds. You can change the refresh time for all dialogs in the Settings Dialog .

Refresh Session List Button:

Manually refreshes the session information.

Delete Session Button:

Delete Session  removes the currently selected session; the Scalable SQL engine kills the session you delete.

Close Button:

Closes the dialog.

Help Button:

Shows help for this dialog.


SQL Active Resources
SQL Resource Usage

The Resource Usage dialog shows information about various resources used by the Scalable SQL engine. The maximum, peak, and current values are shown for each statistic.

Sessions:

The total number of active Scalable SQL sessions. Each session corresponds to a login operation.

Dictionaries:

The number of databases with at least one active session.  The maximum number of dictionaries is unlimited.

Views:

The total number of active views.  The maximum number of views is unlimited.

Active Requests:

The number of concurrent requests being processed.

Total Logins:

The total number of sessions since the Scalable SQL engine was loaded. Each login operation corresponds to a session.

Automatic Refresh Checkbox:

Select this check box to automatically update the information in the dialog every few seconds. You can change the refresh time for all dialogs in the Settings Dialog .

Refresh Button:

Manually refreshes the information.

Close Button:

Closes the dialog.

Help Button:

Shows help for this dialog.


SQL Communications Statistics

The Communications Statistics dialog shows information about communication between the Scalable SQL engine and remote clients. A total for all protocols and  protocol specific information is displayed.  You can view protocol specific information for  SPX, TCP/IP and a second SPX or TCP/IP.  The second SPX or TCP/IP will be displayed as SPX(2) or TCP/IP(2).  Below is a list of the controls in this dialog and their function:

Total Requests Processed:

The number of SQL requests handled by the communications component for all communication protocols since it was loaded. The Delta is the count since the last time this screen was displayed or since the delta was reset.

SPX Requests Processed:

The number of SQL requests handled by the communications component for SPX since it was loaded. The Delta is the count since the last time this screen was displayed or since the delta was reset.

TCP/IP Requests Processed:

The number of SQL requests handled by the communications component for TCP/IP since it was loaded. The Delta is the count since the last time this screen was displayed or since the delta was reset.

Communications Threads:

The number of remote requests currently being processed by the Scalable SQL engine. Note that there may also be local requests being processed which are not included in this statistic.

Communications threads are also used to process Monitor utility requests, so you may not see the number of current communications threads drop below one. This is normal.

Total Remote Sessions:

The number of remote workstations connected to the communications component for all communication protocols.

SPX Remote Sessions:

The number of remote workstations connected to the communications component through SPX.

TCP/IP Remote Sessions:

The number of remote workstations connected to the communications component through TCP/IP.

Automatic Refresh Checkbox:

Select this check box to automatically update the information in the dialog every few seconds. You can change the refresh time for all dialogs in the Settings Dialog .

Refresh Button:

Manually refreshes the information.

Reset Delta Button:

Manually resets the Delta count to zero for Total Requests Processed, SPX Requests Processed and TCP/IP Requests Processed.

Close Button:

Closes the dialog.

Help Button:

Shows help for this dialog.


Connect Dialog
Connect Dialog Help

The Connect dialog allows the user to enter a server name and connect to a remote file server for monitoring.  By default, the monitor utility connects to the local server.

If dialogs are currently open in the Monitor utility window, the Connect... menu command is unavailable, and you cannot connect to a remote server. Close the open dialogs and then choose the Connect... menu command.

Server Name:

Enter the server name in the Server Name text box and click OK. Click Cancel if you do not want to connect to a remote server.

OK Button:

Connects to the server listed in the Server Name text box.  The server name will appear in the lower right corner of the status bar.

Cancel Button:

Closes without connecting to a remote server. The Monitor utility continues monitoring the local server.


Disconnect Dialog
Disconnect Dialog Help

The Disconnect dialog asks the user if they want to disconnect from the remote file server to which they are currently connected.

If dialogs are currently open in the Monitor utility window, the Disconnect... menu command is unavailable, and you cannot disconnect from the remote server. Close the open dialogs and then choose the Disconnect... menu command.

Yes Button:

Clicking Yes issues a disconnect to the remote file server. Upon completing, the Monitor utility monitors the local file server.

No Button:

Clicking No cancels the disconnect to the remote file server. The Monitor utility continues monitoring the remote file server.