How to reorg TBTCO table

[Former Member]

Guys,

Please let me know how I can reorg TBTCO table as it contains millions of entries and causing RSA1 transaction to load very slowly

Thanks

Santosh

[Former Member]

Hi

You should delete old jobs.. Usually customer would like to keep 15-30 days of job logs.. Else in the worst case one quarter..

You should schedule background job to run program RSBTCDEL / RSBTCDEL2 to delete old jobs..

And you should perform reorg via sapdba/brtools.. Online reorg should also be fine to reduce space and get performance benefits.

Regards

Madhu

[Former Member]

Hello Santosh,

Are you doing the reorganization of your old jobs.Please do that and TBTCO will have lesser entries.

Regards.

Ruchit.

[Former Member]

my question is how I can reorg TBTCO???

[Former Member]

Hello Santosh,

I do indeed know what your question is.

TBTCO is the master table for SAP jobs. As you delete old jobs entries in TBTCO will get deleted. If you plain simply want to reorganize TBTCO then you might write a piece of ABAP code

Regards.

Ruchit.

[Former Member]

Ruchit,

I just want to delete/reduce entries in TBTCO table(which are 1.8 millions)

Appreciate your help

Thanks

Santosh