6 Replies Latest reply: Sep 26, 2005 9:42 AM by Patrick Rieken RSS

TCODE - $SYNC

Ravi Mahidara
Currently Being Moderated

Hi,

 

Can anybody tell me what $SYNC tcode is used for? I know that it is used for deleting the contents of the buffered tables. But under what circumstances are the contents of buffered tables deleted?

 

Thanks,

-Ravi

  • Re: TCODE - $SYNC
    Dmitry G
    Currently Being Moderated

    You are right, it flushes all caches.

    It's often used when you see that something wrong, and think that the reason is data caching.

  • Re: TCODE - $SYNC
    Ravi Mahidara
    Currently Being Moderated

    Hi Dmitry, Thanks for the reply. Actually, one of my colleague had applied a note 875825 and since then my colleague is unable to work with Transport Connection tab in RSA1. Upon clicking Transport Connection, the system throws him out of RSA1.

     

    We raised an OSS message for the problem and we were asked to run the TCODE $SYNC. Want to know how safe it is to execute the TCODE and will losing the contents of the buffered tables cause any problem in the future?

     

    Thanks,

    -Ravi

  • Re: TCODE - $SYNC
    Prasad Nannuri
    Currently Being Moderated

    Hi,

     

    It is recommend to reset the buffers using Transaction $SYNC. If the extract structure change is not communicated synchronously to the server where delta records are being created, the records are written with the old structure until the new structure has been generated.

     

    Regards-

    Siddhu

     

     

     

  • Re: TCODE - $SYNC
    Patrick Rieken
    Currently Being Moderated

    Be carefull running this in your productive BW, especcially when dataload is going on.. Why ? When generating dim's and sid's the NRIV numberranges are buffered before committing to db. So when loading data and executing $sync you take the risk of data inconsistency !

     

    Kind regards, Patrick Rieken

Actions