Nonstop Database, HiRDB Version 9 Command Reference
This subsection discusses the specification of RDAREAs in operation commands and utilities.
You can choose the following methods to specify RDAREAs in operation commands and utilities:
You can specify one or more RDAREA names directly on the command line.
You can use the method described below to specify RDAREAs in operation commands in the batch mode. This method enables you to specify a group of RDAREAs.
Table 1-5 Specifying a group of RDAREAs in the batch mode
Item | Example of character string pattern | Description | Example of specification |
---|---|---|---|
Right truncation | nnn* | The command searches for RDAREAs whose names begin with nnn. | RDUSER* The command searches for RDAREAs whose names begin with RDUSER. |
nnn*mmm* | The command searches for RDAREAs whose names begin with nnn and contain mmm. | RD*USER* The command searches for RDAREAs whose names begin with RD and contain USER. |
|
nnn*mmm | The command searches for RDAREAs whose names begin with nnn and end with mmm. | RD*USER The command searches for RDAREAs whose names begin with RD and end with USER. |
|
Right and left truncation | *nnn* | The command searches for RDAREAs whose names contain nnn. | *RDUSER* The command searches for RDAREAs whose names contain RDUSER. |
*nnn*mmm* | The command searches for RDAREAs whose names contain nnn and mmm. | *RD*USER* The command searches for RDAREAs whose names contain RD and USER. |
|
Left truncation | *nnn | The command searches for RDAREAs whose names end with nnn. | *RDUSER The command searches for RDAREAs whose names end with RDUSER. |
*mmm*nnn | The command searches for RDAREAs whose names contain mmm and end with nnn. | *RD*USER The command searches for RDAREAs whose names contain RD and end with USER. |
|
.nnn | The command searches for RDAREAs whose names end with nnn preceded by any one character for each period (.) that is specified. This method is supported only for pdcopy and pdrstr. | ..RDUSER The command searches for RDAREAs whose names consist of 8 characters and end with RDUSER. |
When ALL is specified, the processing is performed on all RDAREAs.
When you use ALL, it must be specified at the beginning of the arguments. Neither direct specification nor batch specification can be used together with an ALL specification.
Table 1-6 Support of direct specification, batch specification, and ALL specification
Operation command or utility | Specification method | |||
---|---|---|---|---|
Direct | Batch | ALL | ||
pdhold | Y | Y | Y | |
pdrels | Y | Y | Y | |
pdopen | Y | Y | Y | |
pdclose | Y | Y | Y | |
pddbls | Y | Y | Y | |
pddbchg | Y | Y | Y | |
pddbfrz | Y | Y | Y | |
pdmemdb | Y | Y | Y | |
pdbufmod | Y | N | N | |
pdorbegin | Y | Y | N | |
pdorcheck | Y | Y | Y | |
pdrdrefls | Y | Y | Y | |
pdorcreate | Y | N | N | |
pdrorg | Y | N | N | |
pdreclaim | Y | N | N | |
pdpgbfon | Y | N | N | |
pddbst | Predicting reorganization time | N | N | Y |
Accumulating condition analysis results | Y | Y | Y | |
Logical analysis of RDAREA | Y | Y | Y | |
Physical analysis of RDAREA | Y | Y | Y | |
pdcopy | Y | Y | N | |
pdrstr | Y | Y | N |
Table 1-7 Maximum number of RDAREAs that can be specified
Operation command or utility | Maximum number of RDAREAs with duplicates eliminated | Maximum number of RDAREAs that can be processed | |
---|---|---|---|
pdhold | 4,096 | No limit | |
pdrels | 4,096 | No limit | |
pdopen | 4,096 | No limit | |
pdclose | 4,096 | No limit | |
pddbls | 4,096 | No limit | |
pddbchg | 4,096 | No limit | |
pddbfrz | 4,096 | No limit | |
pdmemdb | 4,096 | No limit | |
pdbufmod | 4,096 | 4,096 | |
pdorbegin | 4,096 | 4,096 | |
pdorcheck | No limit | No limit | |
pdrdrefls | No limit | No limit | |
pdorcreate | When -o is specified: 1 When -r is specified: 4,095 |
When -o is specified: 1 When -r is specified: 4,095 |
|
pdrorg | 1 | 1 | |
pdreclaim | 1 | 1 | |
pdpgbfon | 1 | 1 | |
pddbst | Predicting reorganization time | 1 | No limit |
Accumulating condition analysis results | 4,096 | No limit | |
Logical analysis of RDAREA | 4,096 | No limit | |
Physical analysis of RDAREA | 4,096 | No limit | |
pdcopy | No limit | No limit | |
pdrstr | No limit | No limit |
Table 1-8 Operation command or utility processing when an RDAREA name is duplicated
Operation command or utility | Processing when an RDAREA name is duplicated | |
---|---|---|
pdhold |
|
|
pdrels | Does not eliminate the duplicates and performs the processing as many times as the RDAREA name is specified. | |
pdopen | ||
pdclose | ||
pddbls | ||
pddbchg | Eliminates the duplicates. | |
pddbfrz | Does not eliminate the duplicates and performs the processing as many times as the RDAREA name is specified. | |
pdmemdb | Eliminates the duplicates. | |
pdbufmod | Not applicable | |
pdorbegin | Eliminates the duplicates. | |
pdorcheck | ||
pdrdrefls | Eliminates the duplicates. | |
pdorcreate | Not applicable | |
pdrorg | Not applicable | |
pdreclaim | ||
pdpgbfon | ||
pddbst | Predicting reorganization time | |
Accumulating condition analysis results | Eliminates the duplicates. | |
Logical analysis of RDAREA | ||
Physical analysis of RDAREA | ||
pdcopy | ||
pdrstr |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.