Skip to Content
avatar image
Former Member

Status and action in table RS_STATUS

Does anyone know what the various status and action fields mean in table RS_STATUS. This is suppose to show what tables are in SLT replication.

I'm seeing distinct values in status like:

P

X

E

O

and in action like:

R

S

L

C

W

Mike

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 04, 2014 at 06:37 PM

    Hi Michael,

    I have been unable to find any additional information about the values used for the columns 'Status' and 'Action' in the RS_STATUS table as well. What I do know is that tables that are displayed with 'Action' is 'Replicate' are showing an 'R' and 'Status' is 'In Process' are showing a 'P'. Based on other combination I currently see I have updated your list:

    'Status':

    P = 'In Process'

    X = 'Executed'

    'Action':

    R = 'Replicate'

    L = 'Load'

    Hope this helps!

    With kind regards,

    Martijn van Foeken | Intenzz

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      How about this:


      'Status':

      P = 'In Process'

      X = 'Executed'

      E = 'Error / Aborted'

      O = 'Obtained (Scheduled')

      B = 'Blocked'

      'Action':

      N = 'Create new ERP Schema on HANA and load DD* tables'

      R = 'Load tables and start replication'

      L = 'Load tables without replication (initial load)'

      S = 'Suspend Replication, but continue queue updates'

      W = 'Resume (Wakeup) Replication'

      C = 'Stop Replication, stop queue updates'

      T = 'Create a new table'

      Q = 'Start Replication only (Replicate Only)

      M = 'Create triggers and logging tables (Record Only)'

      Mike