TOCPREVNEXTINDEX

Lund Performance Solutions


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.

    Lund Performance Solutions
    www.lund.com
    Voice: (541) 812-7600
    Fax: (541) 812-7611
    info@lund.com
    TOCPREVNEXTINDEX