Appendix J. Options and Control Statements Whose Default Value Has Changed or that Do Not Need To Be Specified Any Longer After Upgrading

The following table lists and describes the options and control statements for the utilities and operation commands that have been changed in version 09-50 and later.

Table J-1 Options and control statements for the utilities and operation commands that have been changed in version 09-50 and later

ClassificationCommand nameOption, control file, or control statementDescriptionWhether the default value has been changedWhether the value range has been changedPublic or privateBenefit of changing the default valueDisadvantage of changing the default value
UtilitypdreclaimOption-j or -aFree segment release option
-j: Cannot be executed concurrently with online applications.
-a: Can be executed concurrently with online applications.
Y--PublicThere is no need to specify an option to release segments during online processing.The processing time of pdreclaim increases.
-oDoes not perform page compaction.Y--PrivateThere is no need to specify this option because whether compaction is needed is checked automatically.None
Control statementoption
globalbuffer_lru
Treats the pages read into the global buffer as the oldest pages.Y--PublicStable onlineThe processing time of pdreclaim increases.
option io_interruption_intervalPause interval during free page release processing----PrivateThere is no need to specify control statements during utility execution.None
pddbstOption-bProtects online performance of applications from any adverse effects of executing pddbst.Y--PublicStable onlineNone
pdrorgOption-jUnloads and reloads BLOB columnsY--PublicProblems can be avoided during data migration and there is no need to specify the option.None
pdloadControl statementoption
file_buff_size
Size of the input buffer used when seq_range=buff is specifiedY--PublicThere is no need to specify the operand when the automatic numbering facility is used to load data.The process private memory for single servers, back-end servers, and utility servers increase.
pdload and pdrorgControl statementreportName of a processing performance information fileY--PrivateThe cause of performance problems can be identified easily.The capacity of files under the HiRDB directory increases.
pdload, pdrorg, and pdrbalControl statementsortSize of buffer for sorting----PrivateThere is no need to specify the operand during utility execution.None
Operation commandpdsetupOption-kHiRDB termination method (on or off) when the OS is shut downY--PrivateErrors caused by shutdown can be avoided.None
Legend:
Y: Changed
--: No change

Organization of this section
(1) Options and control statements whose default value has been changed
(2) Options and control statements that do not need to be specified any longer, but whose default values have been changed
(3) Options and control statements that do not need to be specified any longer and whose default values are unchanged

(1) Options and control statements whose default value has been changed

The default values of some options and control statements have been changed.

If you will be upgrading your HiRDB, check the table below and, if necessary, revise the specified values. If a change to a default value introduces problems, specify the corresponding option and control statement explicitly. If you are configuring a new HiRDB system, there is no need to revise the specification.

Table J-2 Options and control statements whose default value has been changed

Command nameTypeOption or control statementVersion earlier than 09-50Version 09-50 or later
Compatibility modeRecommended mode
pdrorgOption-j-j is assumed in the following cases:
  • Reorganizing, unloading, or reloading in units of schemas (-t all)
  • Exporting (-W -w)
-j is assumed in the following cases:
  • Reorganizing, unloading, or reloading in units of schemas (-t all)
  • Exporting (-W -w)
  • Using unload data files as the input data file for the database load utility or by UAPs (-W)
Same as the left
pddbstOption-bThe -b option is not assumed.If the -s option is omitted, the -b option is assumed.Same as the left
pdreclaimOption-j or -aThe -j or -a option is not assumed.The -j or -a option is not assumed (-Z is assumed).The -a option is assumed.
Control statementoption
globalbuffer_lru
yesSame as the leftno
pdloadControl statementoption
file_buff_size
The pd_utl_file_buff_size operand value in the system definition is assumed.1024Same as the left
pdload and pdrorgControl statementreportProcessing performance information files are not output.Processing performance information files are output under $PDDIR/spool/utlrpt.Same as the left

(2) Options and control statements that do not need to be specified any longer, but whose default values have been changed

The default values have been changed for some of the options and control statements that do not need to be specified any longer.

If you will be upgrading your HiRDB, check the table below and, if necessary, revise the specified values. If a change to a default value introduces problems, specify the corresponding option and control statement explicitly. If you are configuring a new HiRDB system, there is no need to revise the specification.

Table J-3 Options and control statements that do not need to be specified any longer, but whose default values have been changed

Command nameTypeOption or control statementVersion earlier than 09-50Version 09-50 or later
Compatibility modeRecommended mode
pdload
pdrorg
Control statementreportTuning information is not output.Tuning information is output.
pdreclaimOption-oPage compaction is performed on tables.See Table J-4 Default value of the pdreclaim -o option in version 09-50 or later
pdsetupOption-koffon

Table J-4 Default value of the pdreclaim -o option in version 09-50 or later

System common definition (pd_dbreuse_remaining_entries specification)Version 09-50 or later
Compatibility modeRecommended mode
ALL is specified or the specification is omitted.Table page compaction is not performed (the -o option is assumed to be specified).
NONETable page compaction is performed (the -o option is assumed to be omitted).

(3) Options and control statements that do not need to be specified any longer and whose default values are unchanged

The default values are unchanged for some of the options and control statements that do not need to be specified any longer.

If you will be upgrading your HiRDB, check the table below and, if necessary, revise the specified values. If you are configuring a new HiRDB system, there is no need to revise the specification.

Table J-5 Options and control statements that do not need to be specified any longer and whose default values are unchanged

Command nameTypeOption or control statementVersion earlier than 09-50Version 09-50 or later
Compatibility modeRecommended mode
pdload
pdrorg
pdrbal
Control statementsort [,size-of-buffer-for-sorting]1024Same as the left
pdreclaimControl statementoption
io_interruption_interval
There will be no pause during free page release processing.Same as the left