on 07-03-2007 7:10 AM
Hi
I have 2/3 clients in System. I want to see the size of all these clients. How to see it?? If I delete any client, database size will remain the same and requires reorganization to reduce the database size. Is it correct???
regards
Sachin
Hi,
Please check OSS notes 118823 for this purpose
Regards,
Sowmya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sachin,
Yes, there is a report called YSTABSIZ which can calculate the size of the client.
1. Login to the target client ( for which the client size to be calculated)
2. Run SE38 , execute YSTABSIZ by selecting the table *
3. Execute the report in background
Once the client is deleted, the space which is free can be used to fill in with newly added data but if you want to see the actual space reduction in DB02,it can be acheived only with DB reorganization.
regards,
Vinodh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.