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
  /usr/ofile
  

Overview

Command execution

pdgetcst -a USER-ID ........................1 -t TABLE01 ........................2 -l /usr/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: /usr/ofile