pdpfresh (Refresh server process)
Function
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).
Executor
HiRDB administrator
Format
pdpfresh [-s server-name] [{-f|-c}] |
Options
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.
Table 2-12 describes the process termination timing depending on whether or not the -f option is specified and the difference in possible errors.
Table 2-12 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 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.
Rules
Notes
Return code | Execution result | Remarks | |
---|---|---|---|
0 | -c option specified | Refresh processing has started. | N/A |
-c option not specified | There is no process to be refreshed. | ||
1 | -c option specified | N/A | Output only when the -c option is specified. |
-c option not specified | A process is being refreshed. | ||
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 |