Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    Unanswered: is snapshot functions same as snapshot

    Hi all

    I want to know Snapshot table functions are same as snapshot

    If i take snapshot on database it may cause some performance issue
    like that if use snapshot function also

    Thanks Regards

  2. #2
    Join Date
    May 2003
    The performance is no different, and snapshot funcitons may be a little more resource intensive since it writes data to a table instead of a file.

    However, there seem to be problems with the some of the snapshot functions in terms of reporting accurate data, or at least in terms of reporting data that is expected. This may be because you cannot reset the monitors like you can with regular snapshots (until the database becomes deactivated).
    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