List Replication Status for Accelerated Tables using RC/Query
search cancel

List Replication Status for Accelerated Tables using RC/Query

book

Article ID: 447978

calendar_today

Updated On:

Products

DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

What is the process to check for the replication status for the DB2 Accelerated tables. To see individual tables and check for their load status.

Environment

DB2

RC/QUERY

Resolution

Steps to View Status:

  1. Navigate to RC/Query
  2. Select DB2 Object ===> T
  3. Select Option ===> AC to enter the RC/Q Table Accelerator list screen
  4. To retrieve additional details from the accelerator stored procedure, set the following report fields:
    Where => N
    Table Name ===> #### (or use * for all tables)
    Creator ===> ####
    AccName ===> ####
    GetInfo ===> Y
  5. View the list of tables and their statuses. Use the window right command to view all available columns, including the load and replication status.

Additional Information
By default, the system retrieves basic information from SYSACCELERATEDTABLES. Setting GetInfo to Y ensures a comprehensive snapshot of the current status for all accelerated tables in a single view.

Powered by Wolken Software