Phase Log | Teradata DSA - 17.20 - Phase Log - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Last Update
2022-11-14
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)
Last Update
2022-11-14

The Phase Log displays details about database objects in running and completed backup, restore, and analyze jobs. This information is read-only. The Phase Log is available when viewing the status of a job or a repository job.

Field Description Job Type
Job Phase The job phase to which the information pertains. Backup jobs have two phases: Dictionary and Data. In addition to Dictionary and Data, restore jobs have Build and Postscript phases.
  • Backup
  • Restore
  • Analyze_Validate
Objects Number of objects processed during the phase
  • Backup
  • Restore
  • Analyze_Validate
SQL Count Number of SQL queries issued by DSMain backend
  • Backup
  • Restore
Dictionary Row Count Number of dictionary rows received from Dump SQL Response
  • Backup
  • Restore
Table Header Count Total number of objects that have a table header
  • Backup
  • Restore
Enabled Incremental Logging Count Number of times the LOGGING INCREMENTAL ON statement is submitted for an IR-enabled backup job.

If the count continues to increase, the backup job might be blocked by another user's locks.

IR-Enabled Backup
Start Date and time the phase began

Restarted restore: Start time of the first run

  • Backup
  • Restore
  • Analyze_Validate
End Date and time the phase ended

Restarted restore: Start time of the last run

  • Backup
  • Restore
  • Analyze_Validate
Average speed (Data phase)
  • Backup jobs: average speed = sum of bytes reported by DSMain for all objects / Time interval from time first byte of data received from DSMain and last object backed up, plus the refresh rate (which is 30 seconds by default). The average backup rate includes tape mount, positioning, and close time.
  • Restore jobs: average speed = sum of bytes reported by DSMain for all objects / Time interval from first receipt of data for first object from the DSA Network Client through data transfer for last object, plus the refresh rate (which is 30 seconds by default). The average restore rate includes tape mount, positioning, and close time, and the time for the concurrent table index build process while the data is being restored. The time for any remaining table index builds after the restore data transfer of the last object is completed is not included.
  • Backup
  • Restore
  • Analyze_Validate
Size (Data phase) Size of the data processed during the phase duration
  • Backup
  • Restore
  • Analyze_Validate
Total Run Time Restarted restore: Total duration of each phase Restore