Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    85

    Unanswered: REFRESH DEFERRED (SUMMARY) MQTs

    If I have a GUI tool which will eventually be querying the base tables and I want to ensure that the "DEFERRED" MQT will be used, and there's no way that the tool will issue a SET CURRENT REFRESH AGE ANY, how do I tell DB2 to use the MQT without going directly against the MQT table in the query?

  2. #2
    Join Date
    Sep 2003
    Posts
    85
    Simplest answer would be to issue an update db cfg for "dbalias" using DFT_REFRESH_AGE ANY.
    I think that another solution might be to update the workstation using the GUI in its db2cli.ini CurrentRefreshAge=ANY .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •