Show Children Hide Children

Tables

  • DB schema:
    oracle-schema3_4.png

t_channel

column description comments
channel_name Name of the channel It should be unique
source_site Source site name Format described in LCG/FtsChannelResolution
dest_site Destination site name Format described in LCG/FtsChannelResolution
contact Email contact of the channel responsibile Informational only
bandwidth Maximum bandwidth, capacity, in Mbits/s Informational only
nostreams The target number of concurrent streams on the network -
nofiles The target number of concurrent files on the network -
tcp_buffer_size Default TCP Buffer Size for the transfer -
nominal_throughput The target throughput for the system (Mbits/s) Informational only
channel_state The state of the channel See possible values
last_active The time the channel was last active -
message The Message concerning Last Modification -
last_modification Last Modification time -
admin_dn The DN of the administrator who did last modification -
se_limit per-SE limit on channel -
channel_type DEDICATED, NONDEDICATED -
blocksize the block size to be used during the transfer -
http_to HTTP timeout -
tx_loglevel Transfer log level. Allowed values are (DEBUG, INFO, WARN, ERROR) -
urlcopy_put_to urlcopy put timeout urlcopy channels only
urlcopy_putdone_to urlcopy putdone timeout urlcopy channels only
urlcopy_get_to urlcopy get timeout urlcopy channels only
urlcopy_getdone_to urlcopy getdone timeout urlcopy channels only
urlcopy_tx_to urlcopy transfer timeout urlcopy channels only
urlcopy_txmarks_to urlcopy transfer markers timeout urlcopy channels only
srmcopy_direction srmcopy direction srmcopy channels only; values are "PUSH" or "PULL" (null -> PULL)
srmcopy_to srmcopy transfer timeout srmcopy channels only
srmcopy_refresh_to srmcopy refresh timeout (timeout since last status update) -
target_dir_check ensure existence of target directory -
url_copy_first_txmark_to The parameter to set after how many seconds to mark the first transfer activity -
new with schema version 3.3.0 (FTS 2.2)
tx_to_per_mb size-based transfer timeout, in seconds per MB -
no_tx_activity_to maximum interval with no activity detected during the transfer, in seconds -
preparing_files_ratio value by which nofiles is multiplied to get the number of transfers in the preparation phase. Default = 2. urlcopy channels only

channel_state values

Value Allocate Fetch Description
Active ok ok -
Inactive ok - Allocate jobs to the channel but do not start transfers.
Drain - ok Channel must be emptied: finish current transfers but do not allocate new ones.
Halted ok - Same as Inactive but should be used e.g. by monitoring scripts to signal a problem (while Inactive is set by the administrator for maintenance). It is disable by default.
Stopped - - No job allocation, no new transfers started (transfer agent should not even start).
Archived - - The channel does not exist anymore (but the entry in the table must be kept).

t_channel_vo_share

Stores the permissions for a VO on a channel.

column description comments
channel_name the name of the channel -
vo_name The name of the VO -
channel_share The percentage of the channel resources associated to the VO See description.
channel_limit The limit (i.e. cap) in the number of concurrent transfers for this VO It's an absolute number
channel_vostate The VO specific state (ON/OFF/PAUSE) See description.

channel_share

For a couple CHANNEL_NAME / VO_NAME the CHANNEL_SHARE value has the following meaning:
  • The value does not exist: the VO cannot use the channel. The VO is anyway authorized to use another channel.
  • 0: it is possible to allocate but not to start new jobs. Deprecated: better use CHANNEL_VOSTATE.
  • > 0: it is possible to allocate and to start new jobs.

channel_vostate

Value Allocate Fetch Comments
ON ok ok -
OFF no, allows fallback ok like drain
PAUSE ok - -
DENY no, does not allow fallback ok (if jobs are present, allow draining the channel) used to deny a VO the permission to execute transfers between a site/cloud and another

t_job

column description comments
job_id the job_id UUID in string form.
job_state The state the job is currently in -
cancel_job Canceling flag. Allowed values are Y, (N), NULL
job_params Transport specific parameters -
source Source site name - the source cluster name -
dest Dest site name - the destination cluster name -
source_se Source SE host name -
dest_se Dest SE host name -
user_dn the DN of the user starting the job -
agent_dn the DN of the agent currently serving the job -
user_cred the user credentials passphrase. -
cred_id The user's credential delegation id -
voms_cred Blob to store user capabilites and groups -
vo_name The VO that owns this job -
channel_name the name of the transfer channel for this job -
reason The reason the job is in the current state -
submit_time job submission time -
finish_time time when the job reached a terminal state -
priority Priority for Intra-VO Scheduling -
submit_host Submitting FTS hostname -
max_time_in_queue Maximum time in queue before start of transfer (in seconds) -
space_token The Space token to be used for the destination files -
storage_class The Storage Service Class to be used for the destination files the destination token description
myproxy_server The endpoint of the MyProxy server that should be used if the legacy cert retrieval is used -
src_catalog The endpoint of Source Catalog to be used in case logical names are used in the files -
src_catalog_type The type of the the Source Catalog to be used in case logical names are used in the files -
dest_catalog The endpoint of the Destination Catalog to be used in case logical names are used in the files -
dest_catalog_type The type of the Destination Catalog to be used in case logical names are used in the files -
internal_job_params Internal job parameters,used to pass job specific data from the WS to the agent -
overwrite_flag Overwrite flag for job -
job_finished this timestamp will be set when the job enter in one of the terminal states (Finished, FinishedDirty, Failed, Canceled). Use for table partitioning -
source_space_token Source space token -
source_token_description Source space token description -
new with schema version 3.3.0 (FTS 2.2)
copy_pin_lifetime pin lifetime of the copy of the file created after a successful srmPutDone or srmCopy operations, in seconds -
lan_connection use "LAN" as ConnectionType (FTS by default uses WAN). Default value is false. -
fail_nearline fail the transfer immediately if the file location is NEARLINE (do not even start the transfer). The default is false. -

* FTS History tables:
oracle_schema_history3_4.png

  • Plugins tables:
    oracle_schema_plugin3_4.png

Last edit: RosaGarciaRioja on 2009-02-25 - 15:14
Number of topics: 1

Maintainer: PaoloTedesco


Topic attachments
I Attachment History Action Size Date Who Comment
PNGpng oracle-schema3_4.png r1 manage 45.8 K 2009-01-26 - 10:19 RosaGarciaRioja FTS DB schema
PNGpng oracle_schema_history3_4.png r1 manage 6.1 K 2009-01-23 - 18:01 RosaGarciaRioja FTS History tables
PNGpng oracle_schema_plugin3_4.png r1 manage 4.6 K 2009-01-23 - 18:01 RosaGarciaRioja Plugins tables
Edit | Attach | Watch | Print version | History: r8 < r7 < r6 < r5 < r4 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r8 - 2009-02-25 - RosaGarciaRioja
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    EGEE All webs login

This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Ask a support question or Send feedback