Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557

    Unanswered: Over head on the MQT

    For those of you who have been working with MQT's. have you experienced any issues with doing REFRESH IMMEDIATE? Please take in consideration that we would be updating base tables once a day on the middle of the night at the down time 98% of the time.

    8.2 aix 5.1
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    REFRESH IMMEDIATE is an overhead .. How much, depends on the MQT Definition ..

    Why not try this :

    Define the MQT as REFRESH IMMEDIATE .. This ensures that Static SQLs also can make use of the immediate updates
    Before the night build, alter table drop the mqt definition ..
    After the build, create the MQT definition ...
    REFRESH the table

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Thank you Sathyaram
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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