Chat now with support
Chat with Support

Spotlight on DB2 6.10 - User Guide

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release Getting started with Spotlight on IBM DB2 LUW Desktop features specific to Spotlight on IBM DB2 LUW Spotlight on IBM DB2 LUW drilldowns
About Spotlight on IBM DB2 LUW drilldowns Buffer Pool Analysis drilldown Client Application Analysis drilldown Database Analysis drilldown Database Manager Summary drilldown Diagnostic Log drilldown FCM Analysis drilldown Tablespace Analysis drilldown Top SQL drilldown Operating System drilldown Workload Management Analysis drilldown
Spotlight on IBM DB2 LUW alarms Spotlight on IBM DB2 LUW Options Tuning SQL statements in Spotlight on IBM DB2 LUW
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Find Text

To find a specified string of text in a Spotlight grid

  1. Open the Find dialog.

    Toolbar Menu Shortcut
    Click Right click the grid data and

    select Find.

    N/A
  2. Use the controls:

    Control Description

    Text to find

    Enter or paste in the text you want to find.

    Match case

    Select to match the case of the text exactly. When selected a search for the string AbC will not find the string abc.

    Match entire cell contents

    Select to match the contents of the table cell exactly. When selected a search for the string Spot will not find the string Spotlight.

    Up

    Search upwards from the current location then stop.

    Down

    Search downwards from the current location then stop.

    Search all columns

    Search all columns of the table.

    Search selected column only

    Search only the highlighted column.

    Find next

    Find the next occurrence of the text in the grid.

Note: The Find function may be of limited use in dynamic columns (Elapsed time is one example) whose values are continually updated.

 

Related Topics

Sort The Grid

To sort the grid according to the contents of a column

Click the column header. An arrow appears to the right of the header  .

Notes: 

  • The arrow points down when the column is sorted in descending order, up when the column is sorted in ascending order.
  • Click the arrow to alternate ascending / descending order.
  • Click a different header to select a different column to sort by.
  • To sort by a column that is hidden, right-click the header row and select Arrange by | column name .

To sort the grid according to the contents of multiple columns

Keep the SHIFT key depressed when sorting by the second or later column.

For example, to sort the grid in the Alarm Log page by severity and then, within that sort, by action:

  1. Click the Severity header.
  2. While keeping the SHIFT key depressed, click the Action header.

 

Related Topics

Tree View

The first column in a Spotlight grid may show data as a simple text string or (if available) a hierarchical tree structure.

Simple Text String Hierarchical Tree Structure (Tree view)

Note: When you sort a table in tree view, the table is sorted first according to the highest level in the tree. The individual branches and sub-branches of the tree are sorted separately in the same order. Sort the Grid

Tree View in Drilldowns Tree View in Alarm Pages
Click

to toggle Tree View on or off.

Drilldown grids with this button on their toolbar can be viewed as a simple text string or a hierarchical tree structure.

Alarm pages Spotlight Today and Alarms by Time are displayed in a tree structure when Group By Connection or Group By Alarm is applied .

To manage the Tree View display, right click on the grid content and select Collapse or Expand.

 

Related Topics

Spotlight Today

Show, Hide & Order Columns

To hide a column

Right-click the column header and select Hide Column.

To reorder a column

Click-and-drag the column header to its new location.

To open the Column Organizer

Use the column organizer to show or hide columns and choose the order in which to display columns.

Right - click the grid header row and select Organize columns

Control Description

Available columns

Hidden columns.

Selected columns

Visible columns in the order they appear in the grid.

Add

Adds the columns selected in Available columns to the Selected columns list.

Add All

Adds all columns in the Available columns list to the Selected columns list.

Remove

Moves the columns selected in the Selected columns list to the Available columns list.

Remove All

Moves all columns in the Selected columns list to the Available columns list.

Move Up

Moves the selected columns in the Available columns list further up the list.

Move Down

Moves the selected columns in the Available columns list further down the list.

Tip: To choose multiple columns in the Available columns and Selected columns lists, use the shortcut key combinations CTRL+click or SHIFT+click.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating