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
Classification | Command name | Option, control file, or control statement | Description | Whether the default value has been changed | Whether the value range has been changed | Public or private | Benefit of changing the default value | Disadvantage of changing the default value | |
---|---|---|---|---|---|---|---|---|---|
Utility | pdreclaim | Option | -j or -a | Free segment release option -j: Cannot be executed concurrently with online applications. -a: Can be executed concurrently with online applications. | Y | -- | Public | There is no need to specify an option to release segments during online processing. | The processing time of pdreclaim increases. |
-o | Does not perform page compaction. | Y | -- | Private | There is no need to specify this option because whether compaction is needed is checked automatically. | None | |||
Control statement | option globalbuffer_lru | Treats the pages read into the global buffer as the oldest pages. | Y | -- | Public | Stable online | The processing time of pdreclaim increases. | ||
option io_interruption_interval | Pause interval during free page release processing | -- | -- | Private | There is no need to specify control statements during utility execution. | None | |||
pddbst | Option | -b | Protects online performance of applications from any adverse effects of executing pddbst. | Y | -- | Public | Stable online | None | |
pdrorg | Option | -j | Unloads and reloads BLOB columns | Y | -- | Public | Problems can be avoided during data migration and there is no need to specify the option. | None | |
pdload | Control statement | option file_buff_size | Size of the input buffer used when seq_range=buff is specified | Y | -- | Public | There 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 pdrorg | Control statement | report | Name of a processing performance information file | Y | -- | Private | The cause of performance problems can be identified easily. | The capacity of files under the HiRDB directory increases. | |
pdload, pdrorg, and pdrbal | Control statement | sort | Size of buffer for sorting | -- | -- | Private | There is no need to specify the operand during utility execution. | None | |
Operation command | pdsetup | Option | -k | HiRDB termination method (on or off) when the OS is shut down | Y | -- | Private | Errors caused by shutdown can be avoided. | None |
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 name | Type | Option or control statement | Version earlier than 09-50 | Version 09-50 or later | |
---|---|---|---|---|---|
Compatibility mode | Recommended mode | ||||
pdrorg | Option | -j | -j is assumed in the following cases:
| -j is assumed in the following cases:
| Same as the left |
pddbst | Option | -b | The -b option is not assumed. | If the -s option is omitted, the -b option is assumed. | Same as the left |
pdreclaim | Option | -j or -a | The -j or -a option is not assumed. | The -j or -a option is not assumed (-Z is assumed). | The -a option is assumed. |
Control statement | option globalbuffer_lru | yes | Same as the left | no | |
pdload | Control statement | option file_buff_size | The pd_utl_file_buff_size operand value in the system definition is assumed. | 1024 | Same as the left |
pdload and pdrorg | Control statement | report | Processing performance information files are not output. | Processing performance information files are output under $PDDIR/spool/utlrpt. | Same as the left |
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 name | Type | Option or control statement | Version earlier than 09-50 | Version 09-50 or later | |
---|---|---|---|---|---|
Compatibility mode | Recommended mode | ||||
pdload pdrorg | Control statement | report | Tuning information is not output. | Tuning information is output. | |
pdreclaim | Option | -o | Page compaction is performed on tables. | See Table J-4 Default value of the pdreclaim -o option in version 09-50 or later | |
pdsetup | Option | -k | off | on |
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 mode | Recommended mode | |
ALL is specified or the specification is omitted. | Table page compaction is not performed (the -o option is assumed to be specified). | |
NONE | Table page compaction is performed (the -o option is assumed to be omitted). |
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 name | Type | Option or control statement | Version earlier than 09-50 | Version 09-50 or later | |
---|---|---|---|---|---|
Compatibility mode | Recommended mode | ||||
pdload pdrorg pdrbal | Control statement | sort [,size-of-buffer-for-sorting] | 1024 | Same as the left | |
pdreclaim | Control statement | option io_interruption_interval | There will be no pause during free page release processing. | Same as the left |