on 05-16-2007 9:47 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.