15.11 - Values for XML Elements - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

prodname
Data Stream Architecture
vrm_release
15.11
created_date
December 2016
category
User Guide
featnum
B035-3150-026K

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
  • netbackup_media_server
  • 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.
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.
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 ".", ":"
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
netmask Maximum of 64 characters, alphanumeric plus ".", ":"
node_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.

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 Maximum of 256 characters
query_band Maximum of 2,048 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.
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.
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.
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 30 characters, alphanumeric and "-", "_"
threshold_units Accepted values: MB, GB