The rs_status Table

The rs_status table stores information about the progress of materialization.

Column

Datatype

Description

schema varchar (255)

Owner of table being materialized

tablename varchar (255)

Name of table being materialized

action varchar (1)
  • I – initial load

  • A – autocorrection phase

  • R – replication

starttime timestamp

Time action was started

endtime timestamp

Time action completed

status varchar (1)
  • P – action in progress

  • X – execution complete

  • E – execution error

pid int Reserved
For example, if autocorrection is in progress for my_table, rs_status contains a row like this:
schema tablename action starttime               endtime status pid
------ --------- ------ ----------------------- ------- ------ ---
sys    my_table  A      2011-07-11 19:11:25.531         P      
If autocorrection is complete for my_table, rs_status contains a row like this:
schema tablename action starttime
------ --------- ------ -----------------------
sys    my_table  A      2011-07-11 19:11:25.531
endtime                 status pid
----------------------- ------ ---
2011-07-11 19:12:14.326 X      

There is no automatic cleanup of rs_status data. Before you attempt to rematerialize a table, you must delete its corresponding row from rs_status:

delete rs_status where tablename=tablename and schema=owner