Contains information for DTS DTTransfer objects. dts_dttransfer is part of the DTS Transfers Object Repository (TOR)
| Column Name | Column Datatype | Column Null Option | Column Comment |
| object_id | integer | not null | Unique primary key. No other object in the TOR will have the same object id |
| name | nvarchar(10) | with null | Name field for OBJ/TNG WV API compatability |
| label | nvarchar(100) | with null | Label field for OBJ/TNG WV API compatability |
| description | nvarchar(150) | with null | Description for this filter object |
| user_data1 | nvarchar(255) | with null | To store client data |
| user_data2 | nvarchar(255) | with null | To store client data |
| max_parcel_size | integer | with null | The size (bytes) of the parcel that the DTA should use for this transfer. |
| session_retry_interval | integer | with null | Time (seconds) between attempts to retry a transfer |
| start_time | integer | with null | Time the transfer was started - number of seconds elapsed since midnight (00:00:00), January 1, 1970, coordinated universal time (UTC). |
| end_time | integer | with null | The time that the transfer completed - number of seconds elapsed since midnight (00:00:00), January 1, 1970, coordinated universal time (UTC). |
| restart_time | integer | with null | Time the transfer was restarted - number of seconds elapsed since midnight (00:00:00), January 1, 1970, coordinated universal time (UTC). |
| total_parcels | integer | with null | Total number of parcels that this transfer will be broken into. |
| no_parcels_xferd | integer | with null | The number of parcels that have already been transfered. |
| session_retry_limit | integer | with null | Maximum number of retries each time the connection is broken |
| session_retry_count | integer | with null | Number of retries that have been attempted since the connection was broken |
| flags | integer | with null | Legacy, backwards compatibility support |
| failure_code | integer | with null | The failure code of the transfer |
| throttle_factor | integer | with null | The throttling factor for the transfer |
| license_code | integer | with null | Licence code for the transfer |
| bytes_transferred | integer | with null | The number of bytes transferred for this transfer |
| alternative_routes | integer | with null | The alternative route last tried |
| alternative_routes_count | integer | with null | The number of alternative routes to try |
| discreet_delivery_period | integer | with null | The amount of time that a discreet transfer has before it becomes urgent |
| discreet_expiry_period | integer | with null | The amount of time that a discreet transfer has to complete before the transfer is aborted. |
| auto_resume | nchar(1) | with null | Should the transfer automatically resume incase of connection failure |
| ckp_restart | nchar(1) | with null | Check-point-restart - enable transfers to restart where they previously failed |
| commit_to_disk | nchar(1) | with null | Force flushing to disk |
| direction | nchar(1) | with null | Pull or push transfers |
| default_tob | nchar(1) | with null | Is this a default Transfer Object (TOB) |
| output_mode | nchar(1) | with null | Text/binary |
| delconv | nchar(1) | with null | Convert filename/path delimeters |
| i_use_trust | nchar(1) | with null | Initiator use Trusted Security domains |
| r_use_trust | nchar(1) | with null | Responder use Trusted Security domains |
| trusted_user | nchar(1) | with null | Trusted security domains - trusted user |
| update_uuid_from_nos | nchar(1) | with null | Use the machine name to find the uuid in the COR |
| input | nvarchar(255) | with null | The source file/dir to be transferred |
| output | nvarchar(255) | with null | The destination file/dir to be transfered |
| initiator | nvarchar(50) | with null | The name of the initiator agent |
| responder | nvarchar(50) | with null | The name of the responder agent |
| initiator_naddr | nvarchar(50) | with null | The network address of the initiator agent |
| responder_naddr | nvarchar(50) | with null | The network address of the responder agent |
| originator_naddr | nvarchar(50) | with null | The network address of where the transfer originated |
| initiator_sec_token | nvarchar(100) | with null | Encrypted initiator security token - username and password |
| responder_sec_token | nvarchar(100) | with null | Encrypted responder security token - username and password |
| p2m_naddr | nvarchar(50) | with null | Point to Many network address |
| originator | nvarchar(50) | with null | Name of the originator of this transfer |
| owner_name | nvarchar(50) | with null | User that owns this transfer |
| hop_pos | nvarchar(10) | with null | Position in a multi-hop transfer |
| hop_file | nvarchar(45) | with null | The name of the hop file that is being used |
| parent | nvarchar(10) | with null | The parent object of this TOB |
| next_tob | nvarchar(10) | with null | Next TOB in the hierarchy |
| root_id | nvarchar(10) | with null | The object_id of the root of this hierarchy |
| group_id | nvarchar(10) | with null | The ID of the group that this TOB is a member of |
| fanout_protocol | nvarchar(32) | with null | The protocol that is to be used for fanout transfers |
| p2p_protocol | nvarchar(32) | with null | The protocol that is to be used for Point-to-Point transfers |
| p2m_protocol | nvarchar(32) | with null | The protocol that is to be used for Point-to-Many transfers |
| appl_id | nvarchar(80) | with null | The ID of the application that created this Transfer Object |
| state | nvarchar(20) | with null | The state of this transfer |
| state_further_info | nvarchar(40) | with null | More detailed state information |
| transfer_type | nvarchar(16) | with null | Type of this transfer object eg. user TOB or implemenation |
| dta_id | nvarchar(18) | with null | Transfer id dta-generated |
| osname | nvarchar(16) | with null | Os name of sender |
| initiator_priority | nvarchar(10) | with null | Initiator priority of the transfer |
| responder_priority | nvarchar(10) | with null | Responder priority of the transfer |
| originator_uuid | nvarchar(40) | with null | Host uuid of the originator of the transfer |
| initiator_uuid | nvarchar(40) | with null | Host uuid of the initiator |
| responder_uuid | nvarchar(40) | with null | Host uuid of the responder |
| i_notify | nchar(1) | with null | Is the initiator a notifing agent |
| r_notify | nchar(1) | with null | Is the responder a notifing agent |
| udt_mechanism | nvarchar(40) | with null | Used to determine if the transfer should be handed off to ADT. ADT handles other types of transfers - MLINK, FTP |
| route_resolution | nchar(1) | with null | Used to enable or disable transfer route resolution. |
| udt_cam_queue_name | nvarchar(40) | with null | The name of the ADT CAM queue. If ADT is handling this transfer, status and control will be forwarded to this queue. |
| udt_cam_queue_location | nvarchar(40) | with null | The location of the ADT CAM queue. If ADT is handling this
transfer, this is the location of the queue that will be
used. |
| responder_uasset_uuid | nvarchar(40) | with null | The uuid of the ca_discovered_hardware asset for the responder |
| initiator_uasset_uuid | nvarchar(40) | with null | The uuid of the ca_discovered_hardware asset for the initiator |
| calendar | nvarchar(10) | with null | Name of the Unicenter Calendar to be used for time based routing |
| calendar_server | nvarchar(50) | with null | The server where the Schedule Object Server (SOS) is located. The SOS is used to establish and control scheduling requests that determine when transfers should occur. Name of the Unicenter calender to be used for time based routing. |
| has_children | integer | with null | Does this TOB have children in the implementation hierarchy. |
| child_states | nvarchar(128) | with null | The current state of this transfers children.
Used to store the state of child objects in the implementation hierarchy. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table