Procedure Using BTEQ
Perform the following procedure to create the tables for the query capture database using BTEQ. This procedure does not create the macros that the Visual EXPLAIN utility needs to work with a QCD. You must create these macros from the Visual EXPLAIN Control Center before the utility can visualize or load QCD query plans.
The procedure assumes that you have already created QCD_database_name.
1 Start BTEQ.
2 Change your current database or user to the database in which the QCD tables are to be created as follows.
where QCF_database_name is the name of the database you created for the QCD tables.
3 Perform the following steps in the indicated order.
a .SET WIDTH 254
b .EXPORT FILE = file_name
c SELECT TabDefinitionFROM systemfe.CreateQCFORDER BY SeqNumber;
d .EXPORT FILE = file_name
e .RUN FILE = file_name
where file_name is the name of the file you create to contain the output of the SELECT request executed in step c.
4 Secure QCD by granting the appropriate privileges to the users who will be analyzing its data.
To use the BEGIN QUERY CAPTURE request to insert data into the QCD tables in TDQCD, you must have the ALL privilege.
See SQL Data Control Language for information about how to implement column‑level and row‑level security for your tables.
You can implement additional secured access by creating views on QCD.
5 Populate the QCD tables using the appropriate tools.
Client tools like Visual EXPLAIN and the Teradata Index Wizard access QCD tables using the views and macros created using the Control Center feature of Visual EXPLAIN.