cancel
Showing results for 
Search instead for 
Did you mean: 

DB reorg clarification

Former Member
0 Kudos

Hi Gurus,

I am planning to do DB reorg in our production system. The main purpose of our activity is to reduce space & fragmentation used by PSAPBTABD & PSAPBTABI tablespaces.

I am using SAPDBA for this activity and will be doing reorg using list of tables & indexes option from the reorganization menu.

My Questions are,

1. How to zero in on the tables that need to be reorganized?

2. Is there any standard formula to calculate the Initial KB, Next extend size(KB) and No.Of Extends? During DB reorg, we have to set the values for these columns in each table.

regards,

Vinodh..

Message was edited by:

Vinodh Kumar Narayanan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

SAPDBA is a bit OLD ( not supported anymore ) perhaps you should use BRSPACE that allows you to reorganize online most of the tables.

There is no standard formula to calulate, perhaps shoul dbe interesting to perform a migration to Locally Managed tablesapces, where you do not have to worry about those things.

Answers (0)