Truncate tables TRBAT and TRJOB on DB level

[Former Member]

Hi!

I am facing with hanging SPAM patch of SAPKB 13 -16.

Now It is not possible to log onto SAP system

The error is: syntaxerror in program SAPLSFES.

Now I would like to truncate the both tables TRBAT and TRJOB.

I connected to SAP DB via "dbmcli commando" and can see the both tables with commando:

>sql_execute select * from tables where TABLENAME='TRBAT'

Can some one please tell me the right procedure/DB-command to truncate both tables?

Thank you very much!

Thom

[Former Member]

Hi Thom,

The system is inconsistent, as the main import is canceled.

At the end of the import logs / usr/sap/trans/log/SAPKB70013.ERB. at the end of this as SPAM is haging you might have tablespace issue . check your log file and increase tablespace.

Then do the following:-

start main import at OS level will the follwowing command:-

"tp r3i SAPKB79913 ERB tag = SPAM

Let us know the results.

Regards,

Atil

[Former Member]

In my case the command:

tp r3i all <sid> tag=spam pf=/usr/sap/trans/bin/TP...PFL

has solved this problem