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.
When executing updatable online reorganization, you can use the pdpfresh command to create the status in which no user server process is accessing a target server's RDAREAs even if the RDAREAs' open attribute is INITIAL or DEFER (status that enables RDAREAs to be disconnected).
HiRDB administrator
pdpfresh [-s server-name] [{-f|-c}] |
Specifies the name of the server to be refreshed.
In a HiRDB parallel server configuration, you can specify a back-end server or dictionary server (but not a front-end server). When this option is omitted, the command assumes all servers (except front-end servers).
In a HiRDB single server configuration, the command assumes the single server regardless of the -s option.
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-25 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. |
Back-end server process that is using the local buffer for each AP | 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 might occur between the HiRDB client and HiRDB server. For a back-end server, no error occurs. Note that server process refreshing is not completed as long as these processes exist. | The server process is forcibly terminated when the transaction ends. If SQL statements are executed thereafter, a new connection is established with the process and the processing is performed. |
The following server processes:
| The server process is forcibly terminated when the transaction ends. If SQL statements are executed thereafter, a new connection is established with the process and the processing is performed. | |
Back-end server process 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 forcibly terminated when the transaction ends. If SQL statements are executed thereafter, a new connection is established with the process and the processing is performed. |
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 shell.
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 configuration. | |
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 |