TOCPREVNEXTINDEX

Lund Performance Solutions


SOSLOGX

The Historical Performance Data Extraction Utility

SOSLOGX is the historical data counterpart to sos. It provides the means for reviewing performance data stored in the log files that soslogd has collected. The user interface is similar in many ways to sos. The main difference is that the SOSLOGX screens do not display current samples of online performance data. Instead, they display historical data collected by SOSLOGD.
The primary functions of SOSLOGX are:
  • To browse through the data recorded in your log files using a variety of screen reports. This is usually done to identify periods of system activity that may require further analysis.
  • To prepare logged performance data from the log files for Performance Gallery Gold, a 32-bit, full-color graphical analysis and reporting application from Lund Performance Solutions.
  • Getting Started

    To run SOSLOGX:
  • From your home directory, enter soslogx (lowercase) at the prompt. The initial SOSLOGX screen will display (see Figure 44.1)


  •  
    NOTE To view the screen without soft function keys, add the -k command key switch.



    .


    Figure 44.1 SOSLOGX initial screen
  • When SOSLOGX is run for the first time on a system, it creates a catalog of the SL files located in the working directory. The catalog is saved as a file (.sllogcat) in the same location as the SL files. At subsequent startups, SOSLOGX will check to see if the catalog exists. It will create a new catalog if the previous catalog cannot be found.
  • Enter the following information as prompted:
  • The start date of the initial sample using the format mm/dd/yy. If you do not provide a date, the program will retrieve the earliest sample date recorded by default. Press Enter.
  • The start time using the format hh:mm. If you do not provide a start date, the program will retrieve the start time of the earliest sample data recorded, by default.
  • The first SOSLOGX data report, the CPU Summary screen, will display. Information about each SOSLOGX report is provided in "SOSLOGX Reports".
    The SOSLOGX commands and menus are described in "SOSLOGX Menus and Options".

    Command Line Switches

    Use command line switches to modify the SOSLOGX configuration. Enter soslogx -h at the shell prompt of your home directory to view all available command line switches. The functions of each command line switch is summarized in Table 44.1.
    Table 44.1 SOSLOGX command line switch functions
    Switch
    Function
    -h
    Displays available command line switches.
    -j
    Forces SOSLOGX into job mode.
    NOTE When input is redirected from a pipe or a file (not from a terminal), SOSLOGX is forced into job mode regardless of whether or not the -j command line switch is used.
    -k
    Disables function keys (when function keys are available).
    -o
    Displays configuration options on startup (batch mode).
    -u<filename>
    Specifies alternate user configuration filename.
    -x
    Enables process export file report.
    -y<filename>
    Specifies alternate system configuration filename.
    -z
    Disables the "Are you sure you want to exit?" dialog.
    .

    Browsing SOSLOGX Reports

  • The first SOSLOGX report displayed is the CPU Summary report. Begin by scrolling through this report using the commands keys.
  • The commands shown in the SOSLOGX Main Commands screen are discussed in "SOSLOGX Menus and Options".
  • Look for points within the data that show high CPU utilization percentages and/or high response time rates.
  • Compare the CPU data with information displayed in other SOSLOGX reports, which can be selected from the SOSLOGX Report Format Selection Menu.
  • The Report Format Selection Menu is explained in "SOSLOGX Menus and Options".
  • Each SOSLOGX report is described in "SOSLOGX Reports".
  • The appearance of the reports displayed can be modified. Use the display options described in "SOSLOGX Menus and Options".
  • Preparing Logged Data for Export

    The data logged by SOSLOGD can be prepared in SOSLOGX for export to either Performance Gallery Gold or another third-party application.

    Exporting Data to Performance Gallery Gold

    Setting the Performance Gallery Configuration

    If needed, you can change the configuration of the export file with the options provided in SOSLOGX.
  • From any SOSLOGX report display, type o to access the SOSLOGX MAIN OPTION MENU.
  • Select the Performance Gallery configuration (SUBMENU) option.
  • Select the Export Data configuration (SUBMENU) option.
  • Check the configuration of the export data. Make modifications as needed. (For more information about this configuration menu, see "Export Data configuration Submenu".) Press the Enter key to exit the submenu.
  • From the Performance Gallery configuration submenu, select the Export Thresholds configuration (SUBMENU) option.
  • Set the export thresholds. (The options in the Export Thresholds configuration submenu are described in "Export Thresholds configuration Submenu".) Press the Enter key to exit the submenu.
  • Press the Enter key to exit the Performance Gallery configuration submenu.
  • Press the Enter key again to exit the SOSLOGX MAIN OPTION MENU.
  • Creating the PGG Export File

    From any SOSLOGX report display, type P to start the process. Respond to the following prompts:
  • Enter Performance Gallery export file
  • Enter start date for Performance Gallery (mm/dd/yy)
  • Enter start time for Performance Gallery (hh:mm)
  • Enter end date for Performance Gallery (mm/dd/yy)
  • Enter end time for Performance Gallery (hh:mm)
  • SOSLOGX will read the log files that meet the date and time criteria entered, then write the eligible data to the specified export file. If a directory path is not given for the export file, the file will be written to the current working directory.

    Exporting Data to Third-party Applications

    Setting the Export File Configuration

    If needed, you can change the configuration of the export file with the options provided in SOSLOGX.
  • From any SOSLOGX report display, type o to access the SOSLOGX MAIN OPTION MENU.
  • Select the Export file configuration (SUBMENU) option.
  • Check the configuration of the export data. Make modifications as needed. (For more information about this configuration menu, see "Export Data configuration Submenu".) Press the Enter key to exit the submenu.
  • Press the Enter key again to exit the SOSLOGX MAIN OPTION MENU.
  • Creating the Export File

    From any SOSLOGX display, type R to start the process. Reply to the following prompts:
  • Enter data export file
  • Enter start ascii dump date (mm/dd/yy)
  • Enter start ascii dump time (hh:mm)
  • Enter end ascii dump date (mm/dd/yy)
  • Enter end ascii dump time (hh:mm)
  • Single record extract (Y/N)
  • SOSLOGX will read the log files that meet the date and time criteria entered, then write the eligible data to the specified export file. If a directory path is not given for the export file, the file will be written to the current working directory.

    Creating Custom Reports

    The log reports generated by SOSLOGX are user-configurable.
    To create a custom SOSLOGX report, create an ASCII report configuration file that defines the report, then use the sosrcom report compiler to compile the ASCII files into a master report definition file called reprtdef.


     
    NOTE The sosrcom report compiler must be run in the lps file structure in order to update the report definition file, reprtdef, used by SOSLOGX.


    The sosrcom report compiler uses the commands listed in the following table.
    Table 44.2 sosrcom report compiler commands
    Command
    Description
    ADD <file name>
    Adds the specified configuration file to the master report definition file, reprtdef.
    DEL <report name>
    Deletes the specified configuration file from reprtdef.
    DUMP <report name>
    Dumps existing report internal information.
    EXIT
    Exits the report compiler, sosrcom.
    HELP
    Displays the online help information.
    LIST
    Displays a brief list of all reports in the reprtdef file.
    REBUILD
    Rebuilds the report configuration file.
    UPDATE <file name>
    Updates the existing configuration file to reprtdef.

    SOSLOGX Report Configuration Rules

    Delimiters

    In all file specification lines, blanks and commas can be used interchangeably for delimiters. Blank lines can be inserted anywhere except in the text specifications associated with $HEAD and $TEXT lines.

    Order of Items

    Items must be specified in the following order:
  • TITLE, KEY, LENGTH, and LINES
  • HEAD specifications, if any
  • TEXT specifications, if any
  • ITEM and BAR specifications
  • Syntax of Specification Lines

    The various specification lines are formatted using the following syntax.
    $TITLE "<report name>"
    Required. This line specifies the name of the report.
    $KEY "<line 1>," "<line 2>," <keycode>
    Required. This line specifies the function key used to select this report format (when function keys are available).
  • <line 1> is the first function key label line.
  • <line 2> is the second function key label line.
  • <keycode> is the two-digit code that specifies which function key should be used. The first digit specifies the keyset. The second digit identifies a function key with that keyset (1-5). This field is optional. If not entered, the default is the first available function key.
  • $LENGTH <length>
    Optional. This line specifies the maximum report line length. The <length> value cannot exceed 132. The default is 80.
    $LINES <lines>
    Optional. This line specifies the number of lines required for each log report. The default value for <lines> is the number of lines specified for $TEXT. If there is no $TEXT specification, the default is 1 (one).
    $HEAD <start>
    ...text lines...
    $END
    Optional. This line specifies the report heading text lines. <start> specifies the column in which the specified text starts. The default is 1 (one).


    This is used to facilitate entry of long hardcopy report lines with 80-character screen editors. The number of heading lines is defined by the first $HEAD specification encountered— subsequent $HEAD specifications may not exceed this number of lines.
    $TEXT <start>
    ...text lines...
    $END
    Optional. These lines specify the fixed text label lines to appear in the log report. <start> specifies the column in which specified text starts. The restrictions for $HEAD also apply to $TEXT.
    $DEFINE <identifier> <expression>
    Optional. This line associates as an identifier with a string or numeric expression value. The identifiers can be used as item qualifiers in the next section.
  • <identifier> is any string sequence up to 32 characters, starting with an alphabetical character.
  • <expression> is one of the following:
  • A decimal, hexadecimal, or octal constant.
  • A sequence of up to 4 numerical constants, separated by periods.
  • A string of consecutive, non-blank characters, starting with a non-numeric character.
  • A quoted string, using either double or single quotation marks.
  • <item-name>[:<qualifier>]<row> <col> <length> <label>
    This line specifies on item display.
  • <item-name> is the name of the item. Global block items cannot have an item qualifier. All other items must have one.
  • <qualifier> is a value that identifies which block in a multiple-block-type item is requested. This can be:
  • The word "Total" (the case must match).
  • A decimal, hexadecimal, or octal constant.
  • An identifier defined in a previous $DEFINE statement.
  • <row> is the row in which the item should be displayed.
  • <col> is the column in which the item should be displayed.
  • <length> is the width of the field displayed.
  • <label> is the unique text string (optional). It is not used by the log reporting program, but will be used by the report editor.
  • $BAR <row>,<col>,<length>,<label>,<item-name>,"<code>"
    $END <scale>
    This set of lines specifies a horizontal bar chart display, in which:
  • <row> is the row in which the bar should be displayed.
  • <col> is the column in which the bar should be displayed.
  • <length> is the length of the bar chart displayed.
  • <label> is a unique text string (optional). This is not used by the log reporting program, but will be used by the report editor.
  • <item_name> is the name of the item to display. Disk and workload group items must be qualified. If multiple items are specified, they must all contain the same number of decimal places. This is generally not a problem, because only similar items will be combined in one bar graph, and similar items will all have the same number of decimal places.
  • <code> is a single character to be used to represent this item in the bar graph. This can be blank.
  • <scale> is the scaling factor. In other words, the total cumulative item value which completely fills the bar chart. It can contain as many decimal places as the specified items.
  • SOSLOGX Report File Example

    There are several SOSLOGX reports stored in /etc/opt/lps/rpt/reprtdef. An example is provided here, for your convenience.


    $TITLE "Global Summary"
    $KEY " GLOBAL ","SUMMARY ",12
     
    $TEXT
    *** hh:mm **********************************************************************
    +---------------- CPU Utilization % ----------------+-------- CPU Misc --------+
    | TOTAL BUSY: nnn.n HIGH PRI: nnn.n | Capture nnn.n |
    | User nnn.n Sys nnn.n Vflt nnn.n | RunQ Avg nnn.n |
    | Real nnn.n Intr nnn.n Idle nnn.n | 5 Min RunQ Avg nnn.n |
    | Nice nnn.n C Sw nnn.n | RunQ Busy % nnn.n |
    | NNice nnn.n Trap nnn.n | |
    |-------------------------- Global MEM/VM Statistics --------------------------|
    | Read Hit % nnn.n Page Outs nn.n/s Mem Used % nn.n |
    | Write Hit % nnn.n Deact Byte nnnnn/s VM Used % nn.n |
    |--------------------------- Global Misc Statistics ---------------------------|
    | #Sessions:nnnnn #Procs: nnnnn #Wait IO: nnnnn Ttyin: nnnnnn(nnnnn) |
    | #Active: nnnnn #Active:nnnnn #Deact: nnnn Avg Response Time: nnnn.n |
    |--------------------------- Global Disk Statistics ---------------------------|
    |Disk:Rt/IO%/QL c0t5d0: nn/nnn/nnnn.n c0t6d0: nn/nnn/nnnn.n |
    +------------------------------------------------------------------------------+
    $END
     
    $DEFINE D1 c0t5d0
    $DEFINE D2 c0t6d0
     
    TIME 1, 5, 5
     
     
    CPU-BUSY% 3, 19, 5
    CPU-HIGH-PRI-BUSY% 3, 42, 5
     
    CPU-USER% 4, 11, 5
    CPU-REAL% 5, 11, 5
    CPU-NICE% 6, 11, 5
    CPU-NNICE% 7, 11, 5
     
    CPU-SYS% 4, 28, 5
    CPU-INTR% 5, 28, 5
    CPU-CSW% 6, 28, 5
    CPU-TRAP% 7, 28, 5
     
    CPU-VFLT% 4, 45, 5
    CPU-IDLE% 5, 45, 5
     
    CPU-CAPTURE 3, 72, 5
    CPU-QUEUE-LEN 4, 72, 5
    CPU-QUEUE-5M 5, 72, 5
    CPU-QUEUE-BUSY% 6, 72, 5
     
    VM-READ-HIT% 9, 17, 5
    VM-WRITE-HIT% 10, 17, 5
    VM-PAGE-OUT-RATE 9, 45, 4
    VM-DEACT-BPS 10, 44, 5
    VM-USED-MEM% 9, 74, 4
    VM-USED-VM% 10, 74, 4
     
    MISC-SESSIONS 12, 13, 5
    MISC-ACT-SESSIONS 13, 13, 5
    MISC-PROCESSES 12, 28, 5
    MISC-ACT-PROCESSES 13, 28, 5
    MISC-PROC-BLOCK-IO 12, 46, 5
    MISC-PROC-DEACT 13, 47, 4
    MISC-TTYIN-COUNT 12, 66, 6
    MISC-TTYIN-RATE 12, 73, 5
    MISC-RESP-TIME 13, 72, 6
     
    DISC-IO-RATE:D1 15, 31, 2
    DISC-IO%:D1 15, 34, 3
    DISC-QUEUE-LEN:D1 15, 38, 6
     
    DISC-IO-RATE:D2 15, 64, 2
    DISC-IO%:D2 15, 67, 3
    DISC-QUEUE-LEN:D2 15, 71, 6



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