While using Apptune, finding applications failing with thousands of -811’s.
Singleton selects are being used versus program cursor. I am trying to find out how DB2 handles the logic as well as cycles and I/O’s that may be used.
See Additional info:
Additional Problem or Contact Information: When a Singleton select is executed, does DB2 have to do a I/O to produce a answer set and send the first (4K) page of data for DB2 to read and apply the -811 logic. If this is true, I’m trying to justify the overhead of Singleton selects versus program cursor. To give you an example, there are application packages that produce -811’s as high as 30 – 40k times during a time frame. ? – How and what are the series of events DB2 goes through during the -811 error checking process. Any feedback would be appreciated.