75 ways to demystify DB2 #70: Techtip :How to check the status of table which was altered with not logged initially on primary after takeover in HADR environment
MikeZhang 270007JCJ2 Visits (6548)
On primary database, if some tables were altered with not logged initially, after takeover, how to figure out which tables are currently under inaccessible state?
DB2 *does not* record the status of tables altered with not logged initially in catalog tables and query for status in syscat.tables is always NORMAL, thus the status of these tables cannot be queried by SQL.
One solution is using "load query table" command to check the status of the table.