ReconfigInfoV - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Category: Operations

Database: DBC

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