ReconfigInfoV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Category: Operations

Database: DBC

View Column Data Type Format Comment
ReconfigId INTEGER NOT NULL -(10)9 Returns the unique identification number for a reconfiguration. Every reconfiguration operation is automatically assigned this number.
Description VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the description of the reconfiguration.
ReconfigType BYTEINT NOT NULL -(3)9 Returns the type of reconfiguration.
BeginTimeStamp TIMESTAMP(0) NOT NULL YYYY-MM-DDBHH:MI:SS Returns the timestamp at the start of the reconfiguration.
EndTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at the end of the reconfiguration.
BeginRedistTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which the reconfig Redistribution phase begins.
EndRedistTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which the reconfig Redistribution phase ends.
BeginDelTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which the reconfig Deletion phase begins.
EndDelTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which the reconfig Deletion phase ends.
Status CHAR(10) LATIN NOT CASESPECIFIC NOT NULL X(10) Returns the current status of the Reconfig.
CurrByteCount FLOAT NOT NULL ----,---,---,---,--9 Returns the number of bytes reconfig processed so far.
CurrTabRedistCount FLOAT NOT NULL ----,---,---,---,--9 Returns the number of tables reconfig redistributed so far.
CurrTabDeleteCount FLOAT NOT NULL ----,---,---,---,--9 Returns the number of tables reconfig deleted so far.
EstRemainRedistSecs FLOAT NOT NULL ----,---,---,---,--9 Returns the estimated remaining time (in seconds) for the Redistribution phase.
EstRemainDeleteSecs FLOAT NOT NULL ----,---,---,---,--9 Returns the estimated remaining time (in seconds) for the Deletion/Rebuild NUSI phase.
AddAmpCount SMALLINT -(5)9 Returns the number of AMPs added.
DelAmpCount SMALLINT -(5)9 Returns the number of AMPs reconfig deleted.
MovAmpCount SMALLINT -(5)9 Returns the number of AMPs moved.
ModAmpCount SMALLINT -(5)9 Returns the number of modified AMPs.
NodeCount SMALLINT NOT NULL -(5)9 Returns the number of nodes in the new Config map.
TotTaskCount SMALLINT NOT NULL -(5)9 Returns the total number of tasks involved in the Reconfig.
TotTableCount INTEGER NOT NULL -(10)9 Returns the total number of tables processed.
TotByteCount FLOAT NOT NULL ----,---,---,---,--9 Returns the total number of bytes processed during the time period defined by BeginTimeStamp and EndTimeStamp.
TotCatchUpByteCount FLOAT NOT NULL ----,---,---,---,--9 Returns the total number of bytes processed for catch-up.
TotJournalByteCount FLOAT NOT NULL ----,---,---,---,--9 Returns the ReconfigJournalTbl size.
ActualRedistSecs FLOAT NOT NULL ----,---,---,---,--9 Returns the actual elapsed time in seconds for the Redistribution phase.
ActualDeleteSecs FLOAT NOT NULL ----,---,---,---,--9 Returns the actual elapsed time in seconds for the Deletion/NUSI Rebuild phase.
EstRedistSecs FLOAT NOT NULL ----,---,---,---,--9 Returns the estimated Redistribution phase time in seconds.
EstDeleteSecs FLOAT NOT NULL ----,---,---,---,--9 Returns the estimated Deletion/NUSI Rebuild elapsed time.
BeginCalcHBTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 1 (Calculate Hash Buckets) begins.
EndCalcHBTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 1(Calculate Hash Buckets) ends.
BeginWrSpaceTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.1(Store Database Space Info) begins.
EndWrSpaceTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.1 (Store Database Space Info) ends.
BeginWrCfgTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.7 (Update Current Configuration Map) begins.
EndWrCfgTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.7 (Update Current Configuration Map) ends.
BeginWrCfgNewTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.8 (Update New Configuration Map) begins.
EndWrCfgNewTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.8 (Update New Configuration Map) ends.
BeginWrBkupIdTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.9 (Update Backup-IDs-Array) begins.
EndWrBkupIdTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.9 (Update Backup-IDs-Array) ends.
BeginInsUpdMapRowTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4 Insert/Update DBC.Maps ends.
EndInsUpdMapRowTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4 Insert/Update DBC.Maps begins.
BeginWrBMTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.9.1 (Update BMHashTbl GDO) begins.
EndWrBMTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which reconfig Phase 4.9.1 (Update BMHashTbl GDO) ends.
BeginVProcCfgTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which the reconfig final phase (update VprocCfg GDO) begins.
EndVProcCfgTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the timestamp at which the final reconfig phase (Update VprocCfg GDO) ends.