Skip to Content
avatar image
Former Member

Truncate tables TRBAT and TRJOB on DB level


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!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 01, 2008 at 10:10 AM

    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.



    Add comment
    10|10000 characters needed characters exceeded