DB2 - database snapshot

grofaty · #1 (**permalink**) 07-20-09, 09:07

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

Marcus_A · #2 (**permalink**) 07-20-09, 10:23

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech