Feedback
Did this article resolve your question/issue?

   

Article

How to reorg a table without taking database down?

« Go Back

Information

 
TitleHow to reorg a table without taking database down?
URL NameHow-to-reorg-a-table-without-taking-database-down
Article Number000198527
EnvironmentProduct: OpenEdge
Version: 12.3
OS: All supported platforms
Other: Database Administration
Question/Problem Description
How to reorg a table without taking database down?
Reorg tables within its current storage area with one command.
Steps to Reproduce
Clarifying Information
Database has to be set with Storage Area Type II.
 
Error Message
Defect Number
Enhancement Number
Cause
Resolution
In OpenEdge 12.3, the new PROUTIL TABLEREORG qualifier allows the fragmented data to be reorganize record data while the associated table remains accessible to OLTP (Online transaction processing) operations. The new process replaces lengthy dump and load operations, index rebuilds of associated indexes, and replication target rebase. Eligible record data must all be located within the same Type II storage area. Partitioned and multi-tenant tables are supported.

To do an online reorg, perform the following steps:
  1. Open proenv 
  2. proserve sports2020
  3. prodb sports2020 sports2020
  4. proutil sports2020 -C TABLEREORG customer
OpenEdge Release 12.3 as of Thu Sep 10 19:02:23 EDT 2020
Commit total - trans: 1, recs 100, last rowid: 100657, partition: 0 trid: 6815 (20064)
Commit total - trans: 2, recs 200, last rowid: 101156, partition: 0 trid: 6816 (20064)
Commit total - trans: 3, recs 300, last rowid: 101649, partition: 0 trid: 6817 (20064)
Commit total - trans: 4, recs 400, last rowid: 102144, partition: 0 trid: 6818 (20064)
Commit total - trans: 5, recs 500, last rowid: 9259, partition: 0 trid: 6819 (20064)
Commit total - trans: 6, recs 600, last rowid: 9753, partition: 0 trid: 6820 (20064)
Commit total - trans: 7, recs 700, last rowid: 53256, partition: 0 trid: 6821 (20064)
Commit total - trans: 8, recs 800, last rowid: 53554, partition: 0 trid: 6822 (20064)
Commit total - trans: 9, recs 900, last rowid: 54049, partition: 0 trid: 6823 (20064)
Commit total - trans: 10, recs 1000, last rowid: 54545, partition: 0 trid: 6824 (20064)
Commit total - trans: 11, recs 1100, last rowid: 55041, partition: 0 trid: 6825 (20064)
Commit total - trans: 12, recs 1117, last rowid: 55058, partition: 0 trid: 6826 (20064)
Total records processed: 1117. (20060)
Table reorganization operation reorg completed successfully. (20043)

Progress Information Hub -> Manage the OpenEdge Database -> PROUTIL Utility -> 
PROUTIL TABLEREORG qualifier
Workaround
Notes
Last Modified Date12/22/2021 8:18 AM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.