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