MonTableTransfer provides historical transfer information for tables in Adaptive Server’s active memory. It does not store information for completed transfers. MonTableTransfer provides transfer information on currently ongoing transfers of all tables, whether they are marked for incremental transfer or not, and on previous transfers on tables marked for incremental transfer.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monTableTransfer are:
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
InstanceID |
tinyint |
NOT NULL |
(Cluster environments only) Holds the instance ID of the server in which the command is running. In non-clustered servers, always holds zero. |
DBID |
smallint |
Database ID of table |
|
TableID |
int |
Unique identifier of table |
|
TableName |
varchar(255) |
NULL |
Name of table |
SequenceID |
int |
Adaptive Server-generated internal tracking ID |
|
TrackingID |
int |
NULL |
User-specified tracking ID |
PercentDone |
smallint |
Percentage of transfer work done, expressed as an integer between 0 – 100 (all completed transfers show 100) |
|
BeginTime |
datetime |
Date and time at which transfer begins |
|
EndTime |
datetime |
NULL |
Date and time at which transfer ends. Ongoing transfers show NULL. |
EndCode |
smallint |
NULL |
Ending status of transfer.
|
TransferFloor |
bigint |
Timestamp at which data can be sent |
|
TransferCeiling |
bigint |
Timestamp at which data is uncommitted and cannot be sent |
|
RowsSent |
bigint |
Number of rows sent |
|
BytesSent |
bigint |
Number of bytes sent |
|
Format |
varchar(8) |
NOT NULL |
Contains the name of the destination format: one of ase, bcp, csv, or iq. |