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 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. |
block_level_compression | Accepted values: DEFAULT, ON, OFF. Must be entered in uppercase letters. |
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 "-", ".", ";", ":", 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 ".", ":" |
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 |
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 |
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. |
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_devices | Maximum of 3 characters, numeric range between 1-999 |
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. |