SOS TurboImage Database Detail

The TurboIMAGE Database Detail screen (Figure 20.1) provides performance data for a specific database; times and counts for all calls issued by all processes against the database. Because of the structure of a database, this screen also provides global performance data for all the datasets contained by the database.

Figure 20.1 SOS TurboIMAGE Database Detail screen

This screen is available from any other “SOS – TurboIMAGE” screen via shortcut key. From all other SOS screens the user can access this one via existing SOS Screen Selection menu.

To access the TurboIMAGE Database Detail screen from any SOS display screen:

Type S from the SOS Enter command: prompt to view the Screen Selection Menu screen or type J.

From the Screen Selection Menu screen or at Enter Screen Code: prompt, enter B (Turbo Image Database Detail Screen).

You will be prompted for the TIDBID of the database in order to access this screen. Since you might not know the TIDBID assigned by SOS to a database, this may most probably happen if you access the screen from within any other screen then Database Global Screen, the option to enter the TIDBID to be 0 (zero) is available. If the TIDBID is set to be 0, then you are prompted for the fully qualified database name in order to access the database detail screen. The TurboIMAGE Database Detail screen will display. An example of the screen is shown in Figure 20.1.

TurboIMAGE Database Detail Screen Keys

The TurboIMAGE Database Detail Screen keys are listed and explained in the following table.

Table 20.1 TurboIMAGE Database Detail Screen keys

Key	Usage
Enter	Refresh screen
B	Shortcut to Turbo Image Database Detail Screen
E	Return to Main screen
F	Screen Freeze
I	Shortcut to Turbo Image Database Main Screen
J	Jump to new screen
L	Print Hardcopy
N	Shortcut to Turbo Image Process Detail Screen
S	Jump to SOS Screen Selection menu
X	Exit
Z	Zero Cumulative Totals
!	Execute Shell Commands
:	Execute Shell Commands
?	Help System
CTRL T	Toggle Timer Status

TurboIMAGE Database Detail Screen Display Items

TurboIMAGE Database Detail

The TurboIMAGE Database Detail portion of the screen displays the data items listed in the next table.

Table 20.2 SOS TurboIMAGE Database Detail data items

Data Item	Description
DB ID	The database ID is the number uniquely assigned by SOS to the database.
Database Name	The name of the database for which the detailed information is displayed.
DS Hog	The database’s dataset for which the data access takes the greatest amount of resources.

Key Stats for Database

The Key Stats for Database portion of the screen displays the data items listed in the next table.

Table 20.3 SOS Key Stats for Database data items

Data Item	Description
CPU%	The percentage of all CPU time during the current interval used for DBI calls performed by all processes on the database.
CPU/I	The average CPU time during the current interval used per DBI call performed by all processes on the database (measured in milliseconds).
I/s	The average number of DBI calls per second performed by all processes on the database during the current interval.
Ela/I	The average completion time per DBI call performed by the any processes on the database during the current interval.

Key Stats for Hog Dataset

The Key Stats for Hog Dataset portion of the TurboIMAGE Database Detail screen displays the data items listed in Table 20.4.

Table 20.4 SOS Key Stats for Hog Dataset data items

Data Item	Description
CPU%	The percentage of utilized CPU time during the current interval used for DBI calls performed by all processes on the hog dataset.
CPU/I	The average CPU time during the current interval used per DBI call performed by all processes on the hog dataset (measured in milliseconds).
I/s	The average number of DBI calls per second performed by all processes on the hog dataset during the current interval.
Ela/I	The average completion time per DBI call performed by the any processes on the hog dataset during the current interval.

NOTE If dataset performance data collection is turned off, the values for the items in this screen are replaced by dashed lines (---).

Activity Against Database by Intrinsic

The Activity Against Database by Intrinsic portion of the screen contains performance data for DBI calls performed by all processes on the database. This portion of the screen displays the following information.

Table 20.5 SOS Activity Against Database by Intrinsic data items

Data Item	Item for which Data is Displayed
Get	DBGET intrinsic calls
Put	DBPUT intrinsic calls
Update	DBUPDATE intrinsic calls
Delete	DBDELETE intrinsic calls
Lock	DBLOCK intrinsic calls
Unlock	DBUNLOCK intrinsic calls
Open	DBOPEN intrinsic calls
Close	DBCLOSE intrinsic calls
Begin	DBBEGIN intrinsic calls
End	DBEND intrinsic calls
XBegin	DBXBEGIN intrinsic calls
XEnd	DBXEND intrinsic calls
Find	DBFIND intrinsic calls
Info	DBINFO intrinsic calls
Ctrl	DBCONTROL intrinsic calls
Rollback	DBXUNDO intrinsic calls

The counters and times for each of these data items are:

CPU/I - The average CPU time during the current interval used per DBI call performed by all processes on all databases (measured in milliseconds).

Ela/I - The average completion time per DBI call performed by the any processes on all databases during the current interval.

Int/s - The average number of calls per second, calculated for DBI calls performed by all processes on any database—a separate count for each item.

Activity Against Database by Process

The Activity Against Database by Process portion of the screen contains performance data for all processes accessing the database for which the performance data is displayed. The entries in the list (processes) are indexed by their PIN.

Table 20.6 SOS Activity Against Database by Process data items

Data Item	Description
PIN	The process identification number.
#DS	The number of databases accessed (logged) since the collection was started or since the process was created - the nearest time is considered.
I OK%	The percentage of all DBI calls performed successfully by any process on any database. A successful call is defined in this context as an intrinsic call that returned 0 in the status parameter of the call.
CPU%	The percentage of all CPU time during the current interval used by the process for DBI calls.
Int/s	The average number of calls per second performed by the process on the database.
Put/s	The average number of DBPUT intrinsic calls performed by the process on the database per second.
Del/s	The average number of DBDELETE intrinsic calls per second.
Lock/s	The average number of DBLOCK intrinsic calls per second.
Get/s	The average number of DBGET intrinsic calls per second.
Upd/s	The average number of DBUPDATE intrinsic calls per second.
Oth/s	The average number of other DBI calls.