Nonstop Database, HiRDB Version 9 System Definition
| Error information obtained | Output destination |
|---|---|
|
These files are output in $PDDIR/spool/save of the server machine on which the utility was running. |
|
These results are output to the directory specified by the pd_tmp_directory operand of the server machine from which the utility command was entered. If the pd_tmp_directory operand is omitted, these results are output to the directory specified in the TMPDIR# environment variable. If the TMPDIR# environment variable is also omitted, they are output in /tmp. However, if the HiRDB administrator executes the command, these results are also output in $PDDIR/spool/save. The file names are as follows: command-nameYYYYMMDDHHMMSSpid.txt
|
Table 2-1 TableOperation commands and utilities targeted by the pd_cmd_exec_time operand
| No. | Operation command or utility | Monitoring start message | Monitoring end message | Timeout detection message | Timeout detection abort code |
|---|---|---|---|---|---|
| 1 | pdacunlck | KFPD00041-I | KFPD00042-I | KFPD00043-E | Pd00009 |
| 2 | pdbufls | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 3 | pdbufmod | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 4 | pdclose | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 5 | pdcopy | KFPR26092-I | KFPR26093-I | KFPR26091-E | Pra0001 |
| 6 | pddbchg | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 7 | pddbfrz | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 8 | pddbls | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 9 | pddbst | KFPK10452-I | KFPK10453-I | KFPK10021-E | Pu02004 |
| 10 | pdexp | KFPX28414-I | KFPX28415-I | KFPX28416-E | Pu02004 |
| 11 | pdgetcst | KFPN00500-I | KFPN00501-I | KFPN00502-E | Pu02004 |
| 12 | pdhold | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 13 | pdlistls | KFPD00041-I | KFPD00042-I | KFPD00043-E | Pd00009 |
| 14 | pdload | KFPL00901-I | KFPL00902-I | KFPL24511-E | Pu02004 |
| 15 | pdmemdb | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 16 | pdmod | KFPS05629-I | KFPS05630-I | KFPS05631-E | Pscm271 |
| 17 | pdopen | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 18 | pdorbegin | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 19 | pdorchg | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 20 | pdparaload | KFPL00901-I | KFPL00902-I | KFPL24511-E | Pu02004 |
| 21 | pdpgbfon | KFPL00901-I | KFPL00902-I | KFPL24511-E | Pu02004 |
| 22 | pdrbal | KFPL00901-I | KFPL00902-I | KFPL24512-E | Pu02004 |
| 23 | pdreclaim | KFPL00901-I | KFPL00902-I | KFPL24511-E | Pu02004 |
| 24 | pdrels | KFPH27067-I | KFPH27068-I | KFPH27069-E | Phu0009 |
| 25 | pdrorg | KFPL00901-I | KFPL00902-I | KFPL24511-E | Pu02004 |
| 26 | pdrstr | KFPR26292-I | KFPR26293-I | KFPR26291-E | Pra0001 |
| No. | Obtained information | Output destination |
|---|---|---|
| 1 | core file | They are output to $PDDIR/spool/save, on the server that has the process used by the utility. |
| 2 | .deb files | |
| 3 | .ext.deb files |
Figure 2-1 FigureExample when multiple operation commands and utilities are executed
Figure 2-2 FigureMonitoring scope of this operand
Table 2-2 TableOperation commands and utilities to which this facility is applied
| No. | Operation commands and utilities |
|---|---|
| 1 | pdacunlck (removes the consecutive certification failure account lock state) |
| 2 | pdclose (closes RDAREAs) |
| 3 | pdconstck (integrity check utility) |
| 4 | pdcopy (database copy utility) |
| 5 | pddbchg (switches the replica status for a replica RDAREA) |
| 6 | pddbfrz (freezes the update of HiRDB files in user LOB RDAREAs that are filled with data) |
| 7 | pddbls (displays RDAREA statuses) |
| 8 | pddbst (database condition analysis utility) |
| 9 | pddefrev (generates definition SQLs) |
| 10 | pdexp (dictionary import/export utility) |
| 11 | pdbufls (displays global buffer information) |
| 12 | pdbufmod (dynamically updates the global buffer) |
| 13 | pdgetcst (optimizing-information collection utility) |
| 14 | pdhold (shuts down RDAREAs) |
| 15 | pdinit (database initialization utility) |
| 16 | pdload (database load utility) |
| 17 | pdmod (database structure modification utility) |
| 18 | pdopen (opens RDAREAs) |
| 19 | pdorbegin (commits a database for online reorganization) |
| 20 | pdorchg (switches over the current RDAREA for online reorganization) |
| 21 | pdorend (performs reflection processing for online reorganization) |
| 22 | pdparaload (performs parallel loading) |
| 23 | pdrbal (rebalancing utility) |
| 24 | pdrels (releases RDAREAs from shutdown status) |
| 25 | pdrorg (database reorganization utility) |
| 26 | pdreclaim (free page release utility) |
| 27 | pdpgbfon (global buffer residence utility) |
| 28 | pdrstr (database recovery utility) |
| 29 | pdvrup (upgrades the HiRDB version) |
| 30 | pdlistls (displays list definition information) |
| 31 | pdmemdb (command related to in-memory data processing) |
| 32 | pdreginit (registry facility initialization utility) |
| Cause of server process abnormal termination | Inclusion in abnormal termination count | |||
|---|---|---|---|---|
| Single server process | Front-end server process | Dictionary server process | Back-end server process | |
| PDCWAITTIME operand value of the client environment definition has been exceeded | Y | Y | N#1 | N#1 |
| pdcancel command | N | N#2 | N | N |
| Internal forced termination (HiRDB internally issues SIGKILL and terminates a process) | Y#3 | Y#3 | N#1 | N#1 |
| Abort | Y | Y | Y | Y |
One of the following:
|
Y | Y | N | N |
| Abnormal termination of process other than those described here | Y | Y | Y | Y |
| Monitored resource | Message that is output |
|---|---|
| Maximum number of concurrent connections specified by the pd_max_users operand# | KFPS05123-W |
| Concurrently accessible base tables count specified by the pd_max_access_tables operand | |
| Maximum number of RDAREAs specified by the pd_max_rdarea_no operand | |
| Maximum number of HiRDB files comprising an RDAREA specified by the pd_max_file_no operand | |
| Usage of HiRDB file system area for work table files, as specified by the pdwork operand | |
| Maximum number of users who can own lists concurrently, as specified by pd_max_list_users | |
| Maximum number of lists that a user can create, as specified by pd_max_list_count | |
| Number of audit trail files that cannot be specified as swappable targets | |
| Number of lists created within a server | KFPH22023-W |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.