Chatee ahora con Soporte
Chat con el soporte

Spotlight on DB2 6.9.3 - Getting Started Guide

Database Analysis drilldown 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.

 

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación