monTableTransfer

Provides historical transfer information for tables in the SAP ASE 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.

Columns

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`		Internal tracking ID generated by the SAP ASE server
`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. 0 – successful transfer. NULL – ongoing transfer. Error code – failed 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`.