Listing server-managed tables

Managed tables fall into three categories: site data tables; merchant data tables; mixed site and merchant data tables.

To list the tables that are managed by the staging or authoring server:

Procedure

  1. Start a database command prompt session.
  2. Connect to the staging or authoring database.
  3. Issue one of the following SQL commands, depending on the category for which you want to see the list of managed tables:
    OptionDescription
    Site data select tabname from STGSITETAB
    Merchant data select tabname from STGMERTAB
    Mixed site and merchant data select tabname from STGMRSTTAB
    Attention: Some of the server-managed tables that are returned by the SQL commands do not have staging triggers associated with them. Any changes that you make to these tables in the staging database are not captured in the STAGLOG table. When you run the stagingprop utility, changes in these non-staged tables are not propagated from the staging database to the production database.
    To view a list of tables that contain staging triggers, issue the following SQL command:
    • DB2select trigname, tabname from syscat.triggers where trigname like 'STAG%'

      The list of tables with staging triggers can be found in the tabname column of the result set.

    • For IBM i OS operating systemselect trigger_name, event_object_table from qsys2.systriggers where trigger_name like 'STAG%'
    • Oracleselect object_name from user_objects where object_type = 'TRIGGER' and object_name like '%STG_%;
      For Oracle staging triggers, it has this format: 
      <X>STG_<tableName>
      where:
      • X = I for insert, U for update, or D for delete
      • tableName = the name of the table that owns the trigger.