Category: TDMaps
Database: TDMaps
| View Column | Data Type | Format | Description |
|---|---|---|---|
| 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 before 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 to 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'. 'Y' indicates something 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 running action |
| ElapsedTime | DECIMAL(38,6) | --(32).9(6) | Actual elapsed time for running 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 ran 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 | ID of worker who performs action on table. 0 for serial worker. 1, 2, and so on 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 |