15.10 - ReconfigInfoV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

ReconfigId

INTEGER

NOT NULL

ZZZZZZZZZ9

ReconfigInfoTbl.ReconfigId (UPI)

Description

VARCHAR(512)

UNICODE

NOT CASESPECIFIC

X(512)

ReconfigInfoTbl.Description

ReconfigType

BYTEINT

NOT NULL

ZZ9

ReconfigInfoTbl.ReconfigType

BeginTimeStamp

TIMESTAMP(0)

NOT NULL

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginTimeStamp

EndTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndTimeStamp

BeginRedistTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginRedistTime
Stamp

EndRedistTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndRedistTime
Stamp

BeginDelTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginDelTimeStamp

EndDelTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndDelTimeStamp

Status

CHAR(10) LATIN

NOT CASESPECIFIC

NOT NULL

X(10)

ReconfigInfoTbl.Status

CurrByteCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.CurrByteCount

CurrTabRedistCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.CurrTabRedistCount

CurrTabDeleteCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.CurrTabDeleteCount

EstRemainRedistSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.EstRemainRedistSecs

EstRemainDeleteSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.EstRemainDeleteSecs

AddAmpCount

SMALLINT

ZZZZ9

ReconfigInfoTbl.AddAmpCount

DelAmpCount

SMALLINT

ZZZZ9

ReconfigInfoTbl.DelAmpCount

MovAmpCount

SMALLINT

ZZZZ9

ReconfigInfoTbl.MovAmpCount

ModAmpCount

SMALLINT

ZZZZ9

ReconfigInfoTbl.ModAmpCount

NodeCount

SMALLINT

NOT NULL

ZZZZ9

ReconfigInfoTbl.NodeCount

TotTaskCount

SMALLINT

NOT NULL

ZZZZ9

ReconfigInfoTbl.TotTaskCount

TotTableCount

INTEGER

NOT NULL

ZZZZZZZZZ9

ReconfigInfoTbl.TotTableCount

TotByteCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.TotByteCount

TotCatchUpByteCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.TotCatchUpByte
Count

TotJournalByteCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.TotJournalByteCount

ActualRedistSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.ActualRedistSecs

ActualDeleteSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.ActualDeleteSecs

EstRedistSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.EstRedistSecs

EstDeleteSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigInfoTbl.EstDeleteSecs

BeginCalcHBTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginCalcHBTime
Stamp

EndCalcHBTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndCalcHBTime
Stamp

BeginWrSpaceTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginWrSpaceTime
Stamp

EndWrSpaceTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndWrSpaceTime
Stamp

BeginPHBNewTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginPHBNewTime
Stamp

EndPHBNewTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndPHBNewTime
Stamp

BeginFBHBNewTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginFBHBNewTimeStamp

EndFBHBNewTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndFBHBNewTime
Stamp

BeginWrPHBTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginWrPHBTime
Stamp

EndWrPHBTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndWrPHBTime
Stamp

BeginWrFBHBTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginWrFBHBTime
Stamp

EndWrFBHBTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndWrFBHBTime
Stamp

BeginWrCfgTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginWrCfgTime
Stamp

EndWrCfgTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndWrCfgTimeStamp

BeginWrCfgNewTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginWrCfgNewTimeStamp

EndWrCfgNewTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndWrCfgNewTime
Stamp

BeginWrBkupIdTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginWrBkupIdTimeStamp

EndWrBkupIdTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndWrBkupIdTime
Stamp

BeginWrBMTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginWrBMTime
Stamp

EndWrBMTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndWrBMTimeStamp

BeginDelHBNewTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginDelHBNewTimeStamp

EndDelHBNewTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndDelHBNewTimeStamp

BeginVProcCfgTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.BeginVProcCfgTime
Stamp

EndVProcCfgTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigInfoTbl.EndVProcCfgTime
Stamp

This view provides the end user a way to access the ReconfigInfoTbl. Users with the appropriate privileges can SELECT or DELETE from the base table using the view.

Note: Only SELECT and/or DELETE privileges should be granted to users by user DBC.

Possible Values for ReconfigType

 

Value

Description

1

Online Reconfig

2

Offline Reconfig

Possible Values for Status

  • Start
  • Redist
  • Delete
  • Checktable
  • Abort
  • Idle
  • Pause
  • Offline
  • Complete
  • RedistFail
  • DeleteFail
  • RcoFail