Chatta subito con l'assistenza
Chat con il supporto

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

Configuration tab

The Configuration tab on the Database Analysis drilldown contains all the database level parameters available to your DB2 system.

Right-click any column heading to view the configuration parameters you can display on the Configuration tab. A checkmark appears in front of the parameters that are currently displayed. Select or de-select parameters to change the display.  

The parameter list grid contains the following information about the parameters on the system:

  • Database Parameter Description—A brief description of the parameter

  • Database Parameter—The parameter name

  • Node nn —The value of the parameter on each partition

 

History tab

The History tab on the Database Analysis drilldown shows the command history for all partitions of a database. The information is taken from the database history file. You can check this tab to see when database objects were created, altered, or dropped; when tables were reorganized; when a database was backed up or restored; when tablespaces or tables were quiesced; and more.

When a database row is selected, the tab shows the command history for all partitions. When a partition row is selected, the tab shows the history for that partition.

Note: By default, commands are listed in chronological order, from oldest to most recent. You can reverse that order by clicking the Start Time column header.

Columns in the History tab

All columns available for the History tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.

Column

Description

Command Text

The SQL statement for an operation.

Name

The name of the tablespace or table for which an operation was performed.

Operation

The operation that was performed by a SQL statement. One of the following can be shown:

  • Add table space

  • Alter tablespace

  • Archive logs

  • Backup

  • Drop tablespace

  • Load

  • Load copy

  • Quiesce

  • Reorganize table

  • Rename tablespace

  • Restore

  • Rollforward

  • Unload

Operation Type

The action identifier for an operation. This identifies how an operation was performed. For example, action identifiers for the reorganize operation indicate whether it was online or offline. Action identifiers for the quiesce operation indicate whether it was quiesce share, quiesce update, quiesce, or quiesce reset.

Partition

The partition number of the database partition in which an operation was performed.

Schema

The schema of the table for which an operation was performed.

SQL Code

The SQL return code for an operation. This is taken from the SQLCODE field of the SQLCA (SQL communications area). One of the following can be shown:

  • 0 (zero) is shown for successful execution

  • A positive integer is shown for successful execution with a warning condition.

  • A negative integer is shown for execution with an error condition.

SQL State

The SQL return code that indicates the outcome of the most recently executed operation statement. This is taken from the SQLSTATE field of the SQLCA (SQL communications area).

Start Time

The timestamp for the start of an operation. This includes year, month, date, and hour, in that order.

 

Utilities tab

The Utilities tab on the Database Analysis drilldown shows the status of running utilities for a database or partition. You can use it to monitor the status and progress of backup, load, rebalance, restore, runstats, crash recovery, and rollforward recovery operations. You can also use it to determine whether a utility is degrading database performance.

Columns in the Utilities tab

All columns available for the Utilities tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.

Column

Description

Completed Units

The number of work units that have been completed for the current phase. The value is a running count of completed work units. If the value does not increase over a long period of time, this might indicate that a utility is stalled. (A value is not shown for some utilities.) Check the Work Metric column to see the type of unit used, for example bytes or extents. Check the Total Units column to see the total amount of work for a phase.

Curr Seq

The number of the current phase of a multiphase utility. A number is only shown if a utility contains multiple sequential phases.

ID

The unique identifier for a utility job. An example of the format that might be used for an ID is userid.jobname .

Invoker

The invoker type for a utility. One of the following is shown:

  • User is shown if a utility was invoked by a user.

  • Auto is shown if a utility was invoked automatically by DB2.

Phase Description

A description of the work performed during a utility phase. Phase descriptions include Delete, Load, and Redo.

Phase Start Time

The timestamp for the start of a utility phase. This includes year, month, date, and hour, in that order.

Priority

Utility priority specifies the amount of relative importance of a throttled utility with respect to its throttled peers. A priority of 0 implies that a utility is executing unthrottled . Non-zero priorities must fall in the range of 1-100, with 100 representing the highest priority and 1 representing the lowest.

Start

The timestamp for the time a utility was invoked. This includes year, month, date, and hour, in that order.

State

The current state of a utility. One of the following is shown:

  • Execute is shown when a utility is executing

  • Wait is shown when a utility is waiting for an event to occur before continuing.

  • Error is shown when an error has occurred.

Total Units

The total number of work units in a phase. A value is not shown for some utilities. It is continuously updated for utilities that cannot quantify the total amount of work. Check the Work Metric column to see the type of unit used, for example, bytes or extents. 

Type

The class of a utility. One of the following is shown:

  • Rebalance

  • Backup

  • Runstats

  • Reorg

  • Restore

  • Crash recovery

  • Rollforward recovery

  • Load

  • Restart recreate index

Utility Description

A description of the work being performed by a utility. The format used for a description depends on a utility's class. For example, the description for rebalancer might read "Tablespace ID: 3" to indicate that a rebalancer is working on a tablespace with an ID of 3.  

Work Metric

The type of unit used to measure completed work and total work for a utility. Possible units include bytes and extents. A value is not shown for some utilities.

 

Reorgs tab

The Reorgs tab on the Database Analysis drilldown allows you to monitor table reorganizations for a database. The reorganizations include those that are currently in progress as well as those that are paused, stopped, or completed. For reorganizations that are in progress, the tab shows how much work has been completed so far and the phase currently being performed. For all reorganizations, the tab shows reorg type, status, start and end times, number of rows compressed, and the names of the table spaces involved.

Columns in the History tab

All columns available for the Reorgs tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.

Column

Description

Completion

The completion status of a table reorganization:

  • Success is shown if a reorganization completed successfully.

  • Fail is shown if a reorganization did not complete successfully.

If a reorganization failed, check the History tab for diagnostic information. This is shown in the SQL Code and SQL State columns.  

Counter

A measure that indicates how much of a reorganization has been or was completed. Check the Max Counter column to see the total amount of work for a reorganization.  

End

The timestamp for the end of a table reorganization. This includes year, month, date, and hour, in that order.

Index ID

The ID of the index used for ordering table rows during reorganization. If an index was not specified for sorting, None is shown.

Long Tbsp ID

The identifier of the tablespace used for reorganizing long objects (those with LONG VARCHAR or LOB data). For partitioned tables, this is the tablespace used for each partition's LONG VARCHAR or LOB.

Max Counter

A measure that indicates the total amount of work for a reorganization. Check the Counter column to see the progress of a reorganization that is currently being performed.

Max Phase

The maximum number of phases for a reorganization. This value only applies to classic (offline) reorganizations.

Name

The name of the table that is being reorganized or was reorganized.

Page Reorgs

The number of page reorganizations performed for a table.

Partition

The ID of the data partition for which information is shown in other columns. This value only applies to partitioned tables.  

Phase

The phase of a table reorganization currently being performed or last performed. One of the following can be shown:  

  • Sort

  • Build

  • Replace

  • Index Recreate

This value only applies to classic (offline) table reorganizations.

Phase Start

The timestamp for the start of a certain phase of a table reorganization. This includes year, month, date, and hour, in that order.

Reorg Type

The method and settings specified for a reorganization. Multiple settings can be shown. The settings determine whether a reorganization is in-place (online) or classic (offline). They also determine whether write or read access is allowed during reorganization; whether data is reclustered in the order of a certain index; whether LOB data is reorganized; and whether space is reclaimed.

Rows Compressed

The number of rows compressed in a table during reorganization. If a reorganization is currently in progress, the value shown is a running count of rows that have been compressed. If a reorganization is complete, the value might not be equal to the total number of rows in a table. This is because some rows might have been rejected for compression. For more information, see the description for Rows Rejected.

Rows Rejected

The number of rows rejected for compression. Rows are not compressed during reorganization when their record length less than or equal to the minimum record length. If a reorganization is currently in progress, the value shown is a running count of rows that do not meet the compression requirement.

Schema

The schema of the table that is being reorganized or was reorganized.

Start

The timestamp for the start of a table reorganization. This includes year, month, date, and hour, in that order.

Status

The status of a table reorganization. One of the following states is shown:  

  • Started/Resumed

  • Paused

  • Stopped

  • Completed

  • Truncate

This value only applies to in-place (online) table reorganizations.

Tbsp ID

The identifier of the tablespace used for reorganizing a table. For partitioned tables, this is the tablespace used for each partition.

 

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione