Status and action in table RS_STATUS

[former_member205400]

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

[Former Member · Accepted solution]

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

[former_member205400 · Accepted solution]

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