APQD table size is fastly increasing with huge size

[Former Member]

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...

[stefan_koehler · Accepted solution]

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

[Former Member]

This message was moderated.

[volker_borowski2]

> 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

[Former Member]

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

[former_member204746]

only a reorg will completely release space.

I don't see how a reorg will help increase performance.

but deleting unwanted records wil lhelp.