Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    17

    Red face Unanswered: Working with views

    My problem is twofold :

    I have created views in DB2 , but lately they seems to be obtaining the requested data from a cache, ie : the view isn't being refreshed. I know this, because as soon as I drop the view and re-create it again, the data I'm looking for is there.

    So could anyone help me with A) Checking to see what code was used to create a specific view, B) How to fix the caching problem.

    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Working with views

    I'm not sure if I understand your problem ...

    AFAIK, a view is never materialized and cached ... The view is stored in dB2 as a definition only .... Whenever a view is referred, using the defn db2 gets the table from the bufferpool or disk to build the resultset ...

    To see the view definition, use SYSCAT.VIEWS

    HTH

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

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Are you talking about materialized query tables or DB2 views?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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