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 |
---|---|
|
Maximum of 32 characters |
|
Maximum of 32 characters, alphanumeric plus "-", "_", and "." The first character must 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 "." First character must 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. |
fabric_name | Maximum of 32 characters: alphanumeric and "-" and "_". The first character must be alphanumeric (a-z, A-Z, and 0-9) only. |
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 "." and ":" 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 |
media_server | Maximum of 32 characters: alphanumeric and "-", "_", and "." First character must be alphanumeric (a-z, A-Z, and 0-9) only. |
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 | Maximum of 32 characters, alphanumeric and "-", "_", and "." First character must 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 "-" 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 "." The first character of the name can be alphanumeric (a-z, A-Z, and 0-9) only. |
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 plus "-" and "_" |
threshold_units | Accepted values: MB, GB |
track_empty_tables | Accepted values: true, false. Default is false. |