cancel
Showing results for 
Search instead for 
Did you mean: 

Best practise for Table reorganization

Former Member
0 Kudos

Hi Experts,

We have done a archive with some objects and we found there are huge deleted rows in tcode DB12. And it is showing the wasted space(about 30 GB) also. Now we need to reorganized the tables from which we removed the data. What is the best practice for it? I feel comfort in IBM I access navigator.

It is difficult to have downtime in our SAP System, I want to get wasted space by using online reorganization. I want to put the tick mark on all the options under Table partition option. Please let me know what will be the best case.

Thanks

Asad

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Asad,

I think you can have a look at sap note 84081, it includes both online and offline reorganization.

84081 - IBM i: Reorganization of database tables (RGZPFM)

Best regards,

Daniel

Answers (0)