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

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.05
Published
September 2020
Language
English (United States)
Last Update
2021-04-02
dita:mapPath
ihc1599061140065.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities

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 items enabled for incremental restore. This number must match Table Header Count for incremental restore to occur.

If Enabled Incremental Logging Count does not match Table Header Count, full backup and restore are done.

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