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. |