Example 1 shows an example of using the optimizing information collection utility.

(a) Example 1

Collect optimization information for the following table and output the result to the following output results file:

• Table identifier
  TABLE01
  
• Output results file
  c:\hirdb\pdgetcst\ofile
  

Overview

Command execution

pdgetcst -a USER-ID ........................1 -t TABLE01 ........................2 -l c:\hirdb\pdgetcst\ofile ........3

Explanation:

1. Authorization identifier of the table subject to collection of optimization information: USER-ID
2. Identifier of the table subject to collection of optimization information: TABLE01
3. File for output of the execution result of the optimizing information collection utility: c:\hirdb\pdgetcst\ofile