<% @ Language="JScript" %> <% Server.Execute("/Server_Scripts/UpdateEntryCounter.asp"); %> "In-place" vs. "Unload/Reload" Reorg


Tech Tips


"In-place" vs. "Unload/Reload" Reorg


Description Details: Database area has 50% in primary pages 50% in overflow pages. If no changes are made to the physical record size can an in place reorg be executed to reassign database area to maximum amount of records in primary pages and a minimum amount in overflow pages? Or is an Unload then Reload then fix pointers necessary to change the number of primary and overflow pages to an area?

Answer: You need to do an unload/reload. The "in-place" choice only generates a DMS MODIFY which will not cause records to be moved.

If you have requirements that are not a standard UTS function key, such as, cursor to end of display, you can record a script and assign an action key to the script that will cause that script to be executed. For example:




Information on the KMSYS Worldwide web server is Copyright (c) 1983-2013. All rights reserved.
All copyrights and trademarks are the property of their respective owners.
For information regarding this site, or to report a problem pertaining to the site, please contact support
License Agreements and Policies Privacy and Cookie Statements