Values for XML Elements - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product
Data Stream Architecture
Release Number
16.10
Published
August 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
mbk1487616377418.ditamap
dita:ditavalPath
3150_DSA_UG_1610.ditaval.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities

Many DSA commands read an XML file that specifies setup information or job details by specifying values for XML elements.

The following table indicates accepted values, case sensitivity, and character number restrictions for XML element values. These are in accordance with typical XML standards for Teradata Database.
XML Element Requirements
  • bar_media_server
  • policy_class_name
  • saveset_accountid
  • saveset_password
  • saveset_user
  • source_media
  • target_entity
  • target_media
  • target_name
  • target_tdpid
Maximum of 32 characters
  • media_server_name
  • target_group_name
Maximum of 32 characters, alphanumeric and "-", "_", and "."

The first character of the name can be alphanumeric (a-z, A-Z, and 0-9) only.

auto_retire Accepted values: true, false. Must be entered in lowercase letters.
barnc_logging_level Accepted values: Error, Info, Debug, Warning.
blob_container Maximum of 63 characters. Must be entered in lowercase letters.
block_level_compression Accepted values: DEFAULT, ON, OFF. Must be entered in uppercase letters.
config_map_name Optional, maximum of 128 characters.
concurrent_bid_per_tbl Default is 5.
database_name Maximum of 50 characters
database_query_method Accepted values: BASE_VIEW, EXTENDED_VIEW. Must be entered in uppercase letters.
data_phase Accepted values: DATA, DICTIONARY. Must be entered in uppercase letters.
disable_fallback Accepted value: false. Must be entered in lowercase letters.
True is not an available value for the disable_fallback XML command. Enter the value as follows: <disable_fallback>false</disable_fallback>.
dsc_logging_level Accepted values: Error, Info, Debug, Warning.
dsc_name Maximum of 22 characters: alphanumeric, "-", and ".".

The first character of the name can be alphanumeric (a-z, A-Z, and 0-9) only.

dsmain_logging_level Accepted values: Error, Info, Debug, Warning.
enable_temperature_override Accepted values: true, false. Must be entered in lowercase letters.
frequency_units Accepted values: DAYS, WEEKS. Must be entered in uppercase letters.
frequency_value Value must be between 1-999. Defaults to 7.
ip_address Maximum of characters 64, alphanumeric plus ".", ":"

Do not use link-local IPv6 addresses (beginning with fe80) for media servers.

is_delete_after Accepted values: Y/N. Must be entered as an uppercase letter.
is_enabled Accepted values: true, false. Must be entered in lowercase letters.
is_encrypted Accepted values: Y/N. Must be entered as an uppercase letter.
job_description Maximum of 256 characters
job_name Maximum of 128 characters
job_type Accepted values: BACKUP, RESTORE, ANALYZE_VALIDATE, ANALYZE_READ. Must be entered in uppercase letters.
job_owner [Deprecated] Maximum of 64 characters
map_to Maximum of 128 characters
netbackup_media_server Maximum of 64 characters, alphanumeric and "-", "_", and "."

The first character of the name can be alphanumeric (a-z, A-Z, and 0-9) only.

netmask Maximum of 64 characters, alphanumeric plus ".", ":"
node_name [Deprecated] Maximum of 32 characters, alphanumeric and "-", "_", and "."

The first character of the name can be alphanumeric (a-z, A-Z, and 0-9) only.

nosync Accepted values: true, false. Must be entered in lowercase letters.
nowait Accepted values: true, false. Must be entered in lowercase letters.
object_name Maximum of 128 characters
object_type Must be entered in uppercase letters. Accepted values are: AGGREGATE_FUNCTION, AUTHORIZATION, COMBINED_AGGREGATE_FUNCTIONS, CONTRACT_FUNCTION, DATABASE, EXTERNAL_PROCEDURE, GLOP_SET, HASH_INDEX, INSTANCE_OR_CONSTRUCTOR_METHOD, JAR, JOIN_INDEX, JOURNAL, MACRO, NO_PI_TABLE, ORDERED_ANALYTICAL_FUNCTION, QUEUE_TABLE, SERVER_OBJECT, STANDARD_FUNCTION, STATISTICAL_FUNCTION, STORED_PROCEDURE, TABLE, TABLE_FUNCTION, TABLE_OPERATOR, TRIGGER, USER, USER_DEFINED_METHOD, USER_DEFINED_DATA_TYPE, USER_INSTALLED_FILE, VIEW
online Accepted values: true, false. Must be entered in lowercase letters.
parent_name Maximum of 128 characters
parent_type Accepted values: DATABASE, USER. Must be entered in uppercase letters.
partition_name Maximum of 63 characters
policy_class_name Maximum of 128 characters, alphanumeric and "-", "_"
port Maximum of 5 digits. Must be between 1 and 65535
port_number Port number range 1-2147483647
prefix_name Maximum of 256 characters
queen_node [Deprecated] Maximum of 256 characters
query_band Maximum of 2,048 characters
rename_to Maximum of 128 characters
reset_node_limit Accepted values: true, false. Must be entered in lowercase letters.
retire_units Accepted values: DAYS, WEEKS. Must be entered in uppercase letters.
role_name AWS only. IAM Role. Maximum of 64 characters. Alphanumeric only.
run_as_copy Accepted values: true, false. Must be entered in lowercase letters.
schema_name Maximum of 63 characters
skip_archive Accepted values: true, false. Must be entered in lowercase letters.
skip_force_full Accepted values: true, false. Must be entered in lowercase letters.
skip_stats Accepted values: true, false. Default is false.
start_am_pm Accepted values: AM, PM. Must be entered in uppercase letters.
start_time Maximum of 5 characters. Values must be between 1:00 and 12:00 (AM and PM are entered in the start_am_pm element )
storage_account Maximum of 24 characters. Must be entered in lowercase letters.
storage_devices Maximum of 3 characters, numeric range between 1-999
storage_type Accepted values: cool, hot. Must be entered in lowercase letters.
stream_softlimit Optional, range is 1- max soft limit of the stream soft limit, where max is the number of AMPs per node in the system.
system_name Maximum of 32 characters, alphanumeric and "-", "_", and "."

If the first character of the system name is "-", for example -test, enter the system name at the Enter the System Name prompt.

table_name Maximum of 63 characters
target_accountid Maximum of 30 characters
temperature_override Accepted values: DEFAULT, HOT, WARM, COLD. Must be entered in uppercase letters.
third_party_media_type Accepted value: net_backup. Must be entered in lowercase letters.
third_party_server_name Maximum of 32 characters, alphanumeric and "-", "_"
threshold_units Accepted values: MB, GB
track_empty_tables Accepted values: true, false. Default is false.