DIAGNOSTIC DUMP SAMPLES
Purpose
Extracts random AMP samples from a target system and writes the samples to SystemFE.Opt_RAS_Table on that system.
Syntax
where:
|
Syntax element … |
Specifies … |
|
target_system_name |
a name used to designate the target (production) system from which random AMP sample information is to be estimated. For information on object naming, see SQL Fundamentals. target_system_name is not case sensitive and can be up to 63 characters in length. Names that contain pad characters or nonstandard characters must be enclosed in APOSTROPHE (U+0020) characters. The primary key for the sample row in the table SystemFE.Opt_RAS_Table is target_system_name + database_name + table_name. |
|
database_name |
the name of the database in which table_name is defined. If the name contains pad characters or non-standard characters, it must be demarcated by APOSTROPHE characters. |
|
table_name |
the name of the table for which random AMP sample statistics emulation is to be performed. If the name contains pad characters or non-standard characters, it must be demarcated by APOSTROPHE characters. |
ANSI Compliance
DIAGNOSTIC DUMP SAMPLES is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have INSERT privileges on SystemFE.Opt_RAS_Table to dump random AMP samples.
DIAGNOSTIC DUMP SAMPLES and Target Level Emulation
DIAGNOSTIC DUMP SAMPLES does not require Target Level Emulation to be enabled in order to extract target system random AMP samples.
Session Mode Restrictions
You cannot perform DIAGNOSTIC DUMP SAMPLES in ANSI session mode or within explicit transaction boundaries in Teradata session mode.
Example
Dump the random AMP statistical samples on the current system for the payroll table in the employee database to SystemFE.Opt_RAS_Table. In this example, production_1 is the current system.
DIAGNOSTIC DUMP SAMPLES Production_1 TABLE Employee.Payroll;
For More Information
For more information about random AMP samples, see: