Collection of optimization information by retrieval

 
pdgetcst [-u authorization-identifier] [-a authorization-identifier]
         [-p password] -t {table-identifier|ALL}
         [-c {lvl1|lvl2}]
         [-l output-result-file]
         [-q generation-number]
         [-W execution-monitoring-interval]
 

Deletion of optimization information

 
 pdgetcst -d -t {table-identifier|ALL}
 
              [-u authorization-identifier][-a authorization-identifier][-p password]
 
              [-l output-result-file]
 
              [-W execution-monitoring-interval]
 

Registration of optimization information from optimization information parameter file

 
pdgetcst [-u authorization-identifier] [-a authorization-identifier]
         [-p password] -t table-identifier
          -s optimization-information-parameter-filename
         [-l output-result-filename]
         [-v space-conversion-level]
         [-W execution-monitoring-interval]
 

Saving optimization information in an optimization information parameter file

 
 pdgetcst -e optimization-information-parameter-filename -t table-identifier
 
              [-u authorization-identifier][-a authorization-identifier][-p password]
 
              [-W execution-monitoring-interval]
 

The table below shows the combinations of the -c, -d, -s, and -e options that can and cannot be specified. In the following cases, the KFPN00100-E message is displayed and an error results:

• The same option is specified more than once
• Mutually exclusive options are specified.
  

  Table 16-1 Combinations of the -c, -d, -s, and -e options that can and cannot be specified

  Option		-c option		-d option	-s option	-e option
  		lvl1	lvl2
  -u authorization-identifier		O	O	O	O	O
  -a authorization-identifier		O	O	O	O	O
  -p password		O	O	O	O	O
  -t	table-identifier	M	M	M	M	M
  	ALL		N		N	N
  -d		N	N	N	N	N
  -c	lvl1	N	N	N	N	N
  	lvl2	N	N	N	N	N
  -s optimization-information-parameter-filename		N	N	N	N	N
  -l output-result-filename		O	O	O	O	I
  -q generation-number		O	O	I	I	I
  -v space-conversion-level		N	N	N	O	N
  -e optimization-information-parameter-filename		N	N	N	N	N
  -W execution-monitoring-interval		O	O	O	O	O

Legend:

M: Specification is mandatory

O: Specification is optional

N: Specification is not permitted

I: Specification is ignored, but does not result in an error

If the -c, -d, -s, and -e options are all omitted, the command is executed as if the -c lvl2 option were specified.