The pdpfresh command refreshes the server process. Refreshing means terminating the active process and starting a new process.
This command is applicable to single servers, back-end servers, and dictionary servers.
HiRDB administrator
pdpfresh [-s server-name] [{-f|-c}] |
Specifies the name of the server to be refreshed.
You can specify a single server for a HiRDB/Single Server or a back-end server or dictionary server for a HiRDB/Parallel Server (you cannot specify a front-end server).
When this option is omitted, the command assumes all servers (except front-end servers).
Specifies that the server is to be refreshed forcibly.
The table below describes the process termination timing depending on whether the -f option is specified and the difference in possible errors.
Table 2-15 Process termination timing depending on whether or not the -f option is specified and difference in possible errors (pdpfresh command)
Process | -f option | |
---|---|---|
Not specified | Specified | |
Single server, back-end server, or dictionary server process during utility's internal processing | If the pdpfresh command is executed during utility execution, the server process terminates with an error (return code = 6) without being refreshed. This has no effect on the utility's processing. | The server process is forcibly terminated when the transaction ends. In this case, the utility may terminate abnormally. |
Processes of the following servers:
| The server process is not forcibly terminated. The process is terminated when it no longer satisfies the conditions listed at left or the next time DISCONNECT occurs. In the case of a single server, a connection error may occur between HiRDB client and HiRDB server. For a back-end server, no error occurs. Note that server process refreshing is not completed as long as the these processes exist. | The server process is terminated forcibly when the transaction ends. Thereafter, all SQL statements executed on this process will result in a connection error. |
Process of the back-end server that is using the BES connection holding facility | If a transaction is being processed, the process is refreshed after the transaction ends. If no transaction is being processed, the process is refreshed after the next transaction ends. | The server process is terminated forcibly when the transaction ends. Thereafter, all SQL statements executed on these processes will result in an SQL connection error. |
Specifies that the command is to check whether or not all processes that received the process termination request have terminated. Specify this option when you want to monitor the process refreshing status using a batch file.
You can obtain the result from the pdpfresh command's return code (the result is also displayed in the KFPS00730-I message).
To check each process's refreshing status, execute the pdls -d prc -c command.
Return code | Execution result | Remarks | |
---|---|---|---|
0 | -c option specified | There is no process to be refreshed. | N/A |
-c option not specified | Refresh processing has started. | ||
1 | -c option specified | A process is being refreshed. | Output only when the -c option is specified. |
-c option not specified | N/A | ||
4 | Terminated with warning (error occurred at one ore more servers).# | Output only for a HiRDB/Parallel Server. | |
6 | Terminated without executing refresh processing because a utility was executing. | Output only when the -f option is not specified. | |
8 | Abnormal termination | N/A |
Order of execution of pdpfresh command and utility | Processes allocated by utility execution | pdpfresh command execution results |
---|---|---|
Executing the utility first, and then the pdpfresh command | -- | Termination with an error (return code = 6) |
Executing the pdpfresh command first, and then the utility | Processes subject to refreshing#1 | Normal termination (return code = 0) |
Refreshed processes#2 |