15.10 - Handling Errors - Teradata Index Wizard

Teradata Index Wizard User Guide

prodname
Teradata Index Wizard
vrm_release
15.10
category
User Guide
featnum
B035-2506-035K

You can control the way errors are handled during the import process. You do this by setting error handling options before you import a workload.

1 In the Import File dialog box, click Error Handling.

2 The Error Handling dialog box opens.

3 Fill in the dialog box. The following table describes the options in this dialog box.

 

Option

Description

General

Log only failures in Summary Report

Logs failed operations into the summary report. Consult the log file for the cause of any failures.

Ignore database errors

Teradata Database error messages are ignored during import. If you clear this check box, all Teradata Database error messages are displayed.

Automatically grant missing access privileges

Automatically generate the SQL statement to grant the necessary access rights.

If selected, the Grant Access Privilege dialog box does not appear. Instead, the SQL statement required to grant the necessary access rights is automatically generated and submitted.

Revoke access privileges

Revoke the access privileges granted from the application.

Grant access privileges on database

Generates an SQL statement to grant the necessary access rights on the required database instead of an object reported on a missing access privilege error.

Import

Display Failed SQL statement dialog

Displays the SQL Statement Failed dialog box. This dialog box allows you to abort the import, ignore the error, or enter SQL to correct insufficient privileges or permanent space errors. Teradata Database errors that can be retried include: 2644, 2843, 3250, 3523, or 3524.

If you clear this check box, errors are automatically ignored.

Display Object exists dialog

Shows a message that the object already exists on the machine and gives you the option to overwrite.

If you clear this check box, the Option drop-down box is enabled and you can choose the following:

Yes To All drops all existing objects and recreate all exported objects.

No To All does not drop existing objects and continue with the import operation.

Cancel automatically aborts the import operation if any objects already exist.

Prompt to create non-existing QCDs

Displays a message to create a QCD if the target QCD doesn't exist.

If you clear this check box, a target QCD is created automatically.

Display duplicate primary key error

Random AMP samples

Opens a dialog box that allows you to enter a new system name/RAS tag if a duplicate prime key error occurs while importing Random AMP Samples.

If you clear the Random AMP Samples check box and if the rows already exist on the import system, the import operation will fail with duplicate prime key errors.

Select Use the new tag for the rest of the RAS import if you want the new RAS tag used if duplicate primary key errors occur in the rest of the import of the RAS rows. If you clear this check box, the same dialog box displays for all RAS tags when the duplicate primary key error occurs.

Workloads

Opens a dialog box that allows you to enter a new workload name if a duplicate prime key error occurs while importing workloads.

If you clear the Workloads check box and a workload already exists in the target QCD, the import operation will fail with duplicate prime key errors.

Cost Parameters, DBSControl and Cost Profile records

Opens a dialog box that allows you to enter a new cost tag if a duplicate prime key error occurs while importing cost parameters.

If you clear the Cost Parameters check box and rows already exist on the import system, the import operation will fail due to any duplicate prime key errors.

If you select this check box, Teradata Index Wizard will also export DBSControl records and active or inactive cost profiles.

4 Click OK to return to the Import File dialog box.