Procedure Using the Visual EXPLAIN Utility
Perform the following procedure to create the tables and other database objects for the query capture database using Visual EXPLAIN.
If you do not have the Visual EXPLAIN tool, then see “Procedure Using BTEQ” on page 397.
1 Start Visual EXPLAIN.
2 Pull down the Tools menu and select Control Center.
3 Select the Manage QCD tab.
4 Select the Setup QCD button.
5 Select the Create all QCF database objects (tables and macros) radio button.
6 Type the name of the database owner in the Owner selection box.
7 Specify the Perm Space parameter in the Perm Space selection box.
8 Specify the Spool Space parameter in the Spool Space selection box.
9 Check the Fallback check box depending on your requirements.
10 Select the Create button.
11 Secure the QCD tables by granting the appropriate privileges to the users who will be analyzing its data.
You can implement additional secured access by creating views on QCD.
12 Populate the QCD tables using the appropriate tools.