HPE NonStop SQL/MX Error – 20297 The MODIFY request has completed successfully, but was directed not to start ORSERV. Please run FUP RELOAD to reclaim free space.

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

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, let’s learn about the error message “1104 Default value string is too long for column column-name.”...
  • Data
  • December 3, 2024
In this blog post, let’s learn about the error message “3165 The precision or exponent value specified in value was...
  • Data
  • December 3, 2024
In this blog post, let’s learn about the error message “2051 Either control optionoption name or value ‘value’is not valid.”...
  • Data
  • December 3, 2024