Show TOC

rs_statusLocate this document in the navigation structure

Stores information about the progress of materialization.

The <rs_status> table is stored in each SAP 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

SAP IQ:

varchar (255)

HANA DB:

NVARCHAR (128)

SAP IQ: Owner of table being materialized

HANA DB: Schema name
tablename

SAP IQ:

varchar (255)

HANA DB:

NVARCHAR (128)

SAP IQ: Name of table being materialized

HANA DB: Table name
action

SAP 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

SAP IQ:

varchar (1)

HANA DB:

NVARCHAR (1)

  • P – action in progress

  • X – execution complete

  • E – execution error

  • C – replication completed (HANA DB only)
pid

SAP IQ:

int

HANA DB:

INTEGER		 Reserved
tabletype NVARCHAR (1)

Reserved (HANA DB only)
comment NVARCHAR (1000) Reserved (HANA DB only)