(490) Learn QMirror/DB table status

Table status is kept in field TBDWFG, QMIRROR.ZAMTBF.

A– Waiting for a full table download (the table will be dropped before downloading)

B – Journal backlog processing

D – To be removed

G – Downloading

H – Hooking resources

 I – Initiating for download

Q – Running SQL QMIRROR.ZTBSQL statements

– Downloaded, ready to mirror

– Excluded from QMirror/DB

Y – Waiting for a full table download or ‘Selected Download’ if specified (the table will be cleared before downloading)

Z  – Downloaded and start mirroring, ready to use

Download Flow

For example:

1. To know which tables are not yet ready for use

SELECT * FROM QMIRROR.ZAMTBF WHERE TBDWFG<>Z’ AND TBDWFG<>’X’

2. To know which tables are excluded from QMirror/DB

SELECT * FROM QMIRROR.ZAMTBF WHERE TBDWFG=’X’

Previous (480) Large object (LOB) processing
Next (510) Grant target database privileges to users 

Table of Contents
Scroll to Top