如何获取DB2 MQT的上次刷新时间 [英] How to get DB2 MQT last refresh time

问题描述

对于z / OS实体化查询表上的DB2，如何检索上一次刷新时间？

For a DB2 on z/OS Materialized Query Table, how can you retrieve the last refresh time?

文档指出，DB2在REFRESH期间采取的一项操作是使用刷新时间戳来填充目录。

The documentation states that one of the actions that DB2 takes during a REFRESH is to populate the catalog with a refresh timestamp.

1. 用刷新时间戳和物化查询表的基数
   更新DB2目录

哪个目录表和列包含此信息？

What catalog table and column holds this information?

我一直在寻找它，以便将时间戳记与其他资源进行比较，以查看自上次刷新以来它是否已更改。如果自上次刷新以来其他资源已更改，则必须刷新MQT。

I was looking for this in order to compare the time stamp with another resource to see if it has changed since the last refresh. If the other resource has changed since the last refresh, the MQT must be refreshed.

推荐答案

您可以在表 SYSIBM的 REFRESH_TIME 列中找到最后的刷新时间戳。 .SYSVIEWS

You can find the last refresh timestamp in the REFRESH_TIME column on the table SYSIBM.SYSVIEWS

您可以使用以下SQL检索特定表的最后刷新时间戳：

You could use the following SQL to retrieve the last refresh timestamp for a specific table:

SELECT REFRESH_TIME
FROM SYSIBM.SYSVIEWS
WHERE NAME = ?
AND CREATOR = ?
AND TYPE = 'M'

请参见有关SYSIBM.SYSVIEWS 表的IBM文档，以获取更多信息。

See the IBM documentation for the SYSIBM.SYSVIEWS table for more information.

这篇关于如何获取DB2 MQT的上次刷新时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！