rs_status

Stores information about the progress of materialization.

The rs_status table is stored in each Sybase IQ user database or HANA DB instance, not in the RSSD. The rs_status table is one of six objects created in the HANA DB when a Replication Server connection is created.
Note: For direct load materialization, Replication Server creates a table named rs_mat_status in the replicate database. This table is for internal use only and is therefore not documented.

Column

Datatype

Description

schema

Sybase IQ:

varchar (255)

HANA DB:

NVARCHAR (128)

Sybase IQ: Owner of table being materialized

HANA DB: Schema name

tablename

Sybase IQ:

varchar (255)

HANA DB:

NVARCHAR (128)

Sybase IQ: Name of table being materialized

HANA DB: Table name

action

Sybase IQ:

varchar (1)

HANA DB:

NVARCHAR (1)
  • I – initial load

  • A – autocorrection phase

  • C – finished autocorrection phase, still in catch-up phase (HANA DB only)

  • R – replication

starttime timestamp

Time action was started

endtime timestamp

Time action completed

status

Sybase IQ:

varchar (1)

HANA DB:

NVARCHAR (1)
  • P – action in progress

  • X – execution complete

  • E – execution error

  • C – replication completed (HANA DB only)

pid

Sybase IQ:

int

HANA DB:

INTEGER
Reserved
tabletype NVARCHAR (1)

Reserved (HANA DB only)

comment NVARCHAR (1000) Reserved (HANA DB only)