In this blog post, let’s learn about the error message “20297 The MODIFY request has completed successfully, but was directed not to start ORSERV. 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
20297 The MODIFY request has completed successfully, but was directed not to start ORSERV. Please run FUP RELOAD to reclaim free space.
Reason for the Error
The MODIFY utility was directed not to start ORSERV because the NO RECLAIM option was specified, but partitions involved in the operation require reloading.
Solution
Run FUP RELOAD manually to reclaim any free space on any partitions of the object if the D (INCOMPLETE SQLDDL OPERATION) or F (UNRECLAIMED FREE SPACE) flag is present for the partition. Use the FUP INFO or SHOWLABEL utility to see if the D or F flag is set
