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
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.
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:
|
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:
|
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. |
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.
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:
|
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:
|
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:
|
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. |
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.
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:
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:
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:
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. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center