Category: TDMaps
Database: TDMaps
View Column | Data Type | Format | Comment |
---|---|---|---|
ZoneName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Zone name |
JobNumber | INTEGER | -(10)9 | Job number specified by user calling ManageMoveTablesSP, which is optional |
JobStartTime | TIMESTAMP(6) WITH TIME ZONE | YYYY-MM-DDBHH:MI:SS.S(6)Z | Starting time of Mover Manager |
Action | VARCHAR(24) LATIN NOT CASESPECIFIC | X(24) | Type of action to perform on the table |
Status | VARCHAR(24) LATIN NOT CASESPECIFIC | X(24) | Current status of the action |
DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Database on which the action applies |
TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Table on which the action applies |
GroupOrder | DECIMAL(18,2) | --Z(15)9.99 | Priority rank of an action within its group. Applicable only for rows whose Action value is 'Alter' |
SourceMap | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The map of the table prior to performing the action |
DestinationMap | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The target map used to perform the action |
ActionSQLText | VARCHAR(10000) UNICODE NOT CASESPECIFIC | X(10000) | The SQL text of the DDL statement that would perform this action |
ActionListName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Named list of actions of which this action is a member of |
TableSize | BIGINT | -(19)9 | Approximate size of table in bytes |
FractionOfPermDBFree | FLOAT | -9.99999999999999E-999 | Fraction of PERM DB free |
Issues | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | 'Y' or 'N'. If 'Y', it indicates there is something that administrator may want to check |
PrevGroupsBytesPerSec | DECIMAL(38,6) | --(32).9(6) | Previous Group bytes per second |
EstElapsedTimeInSecond | DECIMAL(38,6) | --(32).9(6) | Estimated elapsed time for executing action |
ElapsedTime | DECIMAL(38,6) | --(32).9(6) | Actual elapsed time for executing action |
StartTime | TIMESTAMP(6) WITH TIME ZONE | YYYY-MM-DDBHH:MI:SS.S(6)Z | Action start timestamp |
EndTime | TIMESTAMP(6) WITH TIME ZONE | YYYY-MM-DDBHH:MI:SS.S(6)Z | Action end timestamp |
ErrorCode | INTEGER | --,---,---,--9 | DBS Error code if failure occurred. Otherwise, zero or NULL |
RunUID | BYTE(4) | X(8) | User who executed this action |
ActionsTblDescription | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | Advisor generated comment providing further explanation for the recommended action |
Description | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | Additional info describing the completed or failed action |
WorkerId | INTEGER | -(10)9 | The ID of the worker who performs action on the table. 0 for serial worker. 1,2... for parallel workers |
HostId | INTEGER | -(10)9 | Host Id of the worker who performs action on the table |
SessionId | INTEGER | -(10)9 | Session Id of the worker who performs action on the table |