Datatid 1999 #6/Datatid_1999-06.iso/internet/Tango352Promo/P.SQL/PTKPKG.1/OS2DBMON.HLP

OS/2 Help File | 1998-09-30 | 18.6 KB | 754 lines

ΓòÉΓòÉΓòÉ 1. 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


ΓòÉΓòÉΓòÉ 2. General Help ΓòÉΓòÉΓòÉ

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.


ΓòÉΓòÉΓòÉ 3. Settings Dialog ΓòÉΓòÉΓòÉ

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.


ΓòÉΓòÉΓòÉ 4. About Dialog ΓòÉΓòÉΓòÉ

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


ΓòÉΓòÉΓòÉ 5. Microkernel Active Files Dialog ΓòÉΓòÉΓòÉ

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 File's Handles:
Shows the number of active handles for the selected file. A handle is one
instance of a file being opened.

Current File's 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 engine's 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.


ΓòÉΓòÉΓòÉ 6. Microkernel Active User Dialog ΓòÉΓòÉΓòÉ

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
engine's 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 User's Handles:
Shows the number of active handles for the selected user. A handle is one
instance of a file being opened.

Selected User's 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 refreshtime 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 MircoKernel users.

Refresh Button:
Manually refreshes the information.

Close Button:
Closes the dialog.

Help Button:
Shows help for this dialog.


ΓòÉΓòÉΓòÉ 7. Microkernel Resource Usage Dialog ΓòÉΓòÉΓòÉ

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 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.


ΓòÉΓòÉΓòÉ 8. Microkernel Communication Statistics Dialog ΓòÉΓòÉΓòÉ

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).

Worker 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.


ΓòÉΓòÉΓòÉ 9. SQL Active Users Dialog ΓòÉΓòÉΓòÉ

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 session's login. Contains either `Database Name' or
`Dictionary Location'.

Database Name:
Either the Database Name or the Dictionary Location used on this session's
login.

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.


ΓòÉΓòÉΓòÉ 10. SQL Resource Usage Dialog ΓòÉΓòÉΓòÉ

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.


ΓòÉΓòÉΓòÉ 11. SQL Communications Statistics Dialog ΓòÉΓòÉΓòÉ

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.


ΓòÉΓòÉΓòÉ 12. Connect Dialog ΓòÉΓòÉΓòÉ

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.


ΓòÉΓòÉΓòÉ 13. Disconnect Dialog ΓòÉΓòÉΓòÉ

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.