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