how can u0131 remove TBTCO and TBTCP

[Former Member]

Hı all

My tbtco and tbtcp tables have total 4 million record so SAP_REORG_JOBS runing a long time .

how can ı remove this records ? or can ı remove ?

[Former Member]

Use the standard job SAP_REORG_JOBS to cleanup TBTCO and TBTCP

Also read the attached note.

Link: [Note 666290 - Deleting "orphaned" job logs]

There is a new program available RSTS0024, which deletes orphaned jobs logs.

Link: [Note 1293277 - Report RST0024 runs for a very long time]

Link: [Note 756604 - Program RSTS0024 terminates after long runtime]

Also perform SM65 -> goto -> additional tests and cleanup the inconsistencies.

[Former Member]

Moved from ABAP solutions to NW Admin tools...

Cheers,

Julius

[raymond_giuseppi]

Check

- [Note 784969 - The RSBTCDEL2 program|https://service.sap.com/sap/support/notes/784969]

- [Note 706478 - Preventing Basis tables from increasing considerably|https://service.sap.com/sap/support/notes/706478]

Floor is crowded.

Regards,

Raymond

[Former Member]

before anybody else suggests anything dangerous to the OP ...

... search in SMP (OSS) for notes on the SAP standard-reorg jobs. They are known to fail every now and then for several reasons (upgrades, conflicts of other sorts etc.). Look for a note suitable for your release and support package level.

... tipp: post such a question in the NW-admin forum next time.

[SuhaSaha]

> before anybody else suggests anything dangerous to the OP ...

ROFL ...

[Former Member]

>

> ROFL ...

you can laugh all you want - I have seen threads in SDN's ABAP_GENERAL where people advised archiving tables using SE16(N) ... this seemed a likely candidate for such advise, so ...

[ThomasZloch]

Yes, lots of dangerous stuff here sometimes. Unfortunately one cannot assign minus 5 points to such replies.

By the way, we are running RSBTCDEL2 regularly to get rid of old batch jobs.

Thomas

[ThomasZloch]

Not ABAP related, will try to have it moved to SAP Netweaver administrator.

Might well be a FAQ there, because I assume you need to run a ... SAP reorg job

Thomas