on 08-04-2010 3:49 PM
Hi All,
File system space has been increasing very fast. We analyzed
the tables for the large size, from which we found APQD table size is
relatively very large in size in Production system. So we are planning
to delete old session logs till last 5 days from the APQD table. We
reffered the note
number "36781 - Table APQD is very large", and run the
report RSBDCCKA and RSBDCCKT and then "RSBDCREO", but found no
significant change at table level and file system as well. (attached is
the screenshot for the same).
We are planning to re-organize the APQD table, so that we can have free
size. Can you please help me to know, reorganization of APQD table will
help to gain segnificant space? We have APQD table size = 350 GB. So
the re-org will generate huge archive log files which needs to be taken
backup. To avoid this can we have other strategy to tackle this problem?
Quick help is appriciated to sort out this problem in production
environment.
-Anthony...
Hello Anthony,
> reorganization of APQD table willhelp to gain segnificant space?
Yes in the database itself, if you have deleted many of the datasets.
> To avoid this can we have other strategy to tackle this problem?
You can do several unsupported ways, but if you ask such a question i would accept the amount of redo log information and go on for a reorg.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> number "36781 - Table APQD is very large", and run the
> report RSBDCCKA and RSBDCCKT and then "RSBDCREO", but found no
> significant change at table level and file system as well. (attached is
As far as I remember, RSBDCREO is client dependent.
If you did run the report in client 000 it might not affect the old
batchinput data in your business client.
A reorg only makes sense, if you did a significant amount of deletes before.
As for filesystem space, you should see a reduced amount of files in
the batch input subdirectories in GLOBAL_DIR.
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Anthony,
Reorg table using BRTOOLs but make sure that you have sufficient space in that tablespace because reorg will create another table with # name and delete once reorg is completed. Definetly you will gain free space in database but not on OS level.
This activity will create lots of archive logs so you have to monitor it.
I did the table reorg for table RSBERRORLOG in BI system and got free space.
Regards
Jiggi
only a reorg will completely release space.
I don't see how a reorg will help increase performance.
but deleting unwanted records wil lhelp.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.