OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4

Chapter 6. Custom Database Monitor Analysis 209

Example 6-28 Isolation level summary

select qvc41, count(qvc41) from mydbmon

WHERE QQRID = 1000

GROUP BY qvc41 order by 2 desc;

Figure 6-26 shows the results of the query in Example 6-28.

Figure 6-26 Isolation level summary

The values can be translated using the following codes:

RR Repeatable Read. In the SQL 1999 Core standard, Repeatable Read is called

serializable.

RS Read Stability. In the SQL 1999 Core standard, Read Stability is called

Repeatable

Read

.

CS Cursor Stability. In the SQL 1999 Core standard, Cursor Stability is called

Read

Committed

.

CSKL Cursor Stability KEEP LOCKS.

UR Uncommitted Read ...