In this blog post, let’s learn about the error message “20296 The MODIFY request has completed successfully, but ORSERV might not have completed successfully. Please run FUP RELOAD to reclaim free space.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20296 The MODIFY request has completed successfully, but ORSERV might not have completed successfully. Please run FUP RELOAD to reclaim free space.
Reason for the Error
The MODIFY utility encountered failures after it started all ORSERVs (the FUP RELOAD operation) successfully. The failures are reported in separate error messages. If the failures were caused by the MODIFY process being killed inadvertently, the warning message is issued by the RECOVER utility during the recovery.
Solution
Run FUP RELOAD manually to reclaim any free space on the specified partitions if the D flag (INCOMPLETE SQLDDL OPERATION), or F flag (UNRECLAIMED FREE SPACE) is present for the partitions. Use the FUP INFO or SHOWLABEL utility to see if the D or F flag is set
