Delete 'Defective sessions' to make Table APQD free

[Former Member]

Hi All,

We checked and found that We have one table APQD in our ECC 6.0 system which is taking 39.54 GB space.

We found OSS Note 36781 - Table APQD is very large which says to run report RSBDCREO.

We ran report RSBDCREO and it only deleted 10 entries out of 9.771.379 entries then we checked Note 18307 - Batch input

logs and reorganization which says report RSBDCREO deletes processed sessions (that is, sessions that have been processed successfully) and their logs from the system.

Only these sessions are deleted, but no 'Sessions still to be processed' or 'Defective sessions' and so on.

We have lot of defective sessions in our system and we need to delete them.

Please suggest the way to delete 'Defective sessions' also from table APQD.

Regads,

Shivam Mittal

[jairo_pedroza · Accepted solution]

Hello Shivam,

Please use program RSBDCTL6 in order to clean all Batch Inputs.

After first clean, you can replace RSBDCREO or leave as second step in your job.

SAP Note 970025 - Batch input RSBDCTL6 enhancement

Regards,

Jairo Pedroza