Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: DB2 - database snapshot

    Hi,
    I have run database snapshot and got the following result

    Code:
    Commit statements attempted                = 6881526
    Rollback statements attempted              = 559558
    Dynamic statements attempted               = 18806473
    Static statements attempted                = 50175189
    Failed statement operations                = 9705
    Select SQL statements executed             = 15690032
    Xquery statements executed                 = 0
    Update/Insert/Delete statements executed   = 4397575
    DDL statements executed                    = 768
    I am just wondering why "Dynamic statements attempted" + "Static statements attempted" is not the same as sum
    "Select SQL statements executed" + "Update/Insert/Delete statements executed"?

    Regards

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Each line of a stored procedure is a separate SQL statement. There are also many other statements such as value, grant, etc that are probably being executed.
    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
  •