Isolation level in db2expln

[finditout]

From where db2expln utility takes isolation level ? As I am changing isolation level on session level and on db as well but still output of db2expln shows me no change in isolation level.

[finditout]

Just to put it in other way:-

Changed Isolation to RR and taken explain. Still explain is showing CURSOR STABILITY .

$ db2 terminate
DB20000I The TERMINATE command completed successfully.
$ db2 change isolation to RR
DB21053W Automatic escalation will occur when you connect to a database that
does not support RR.
DB20000I The CHANGE ISOLATION command completed successfully.
$ db2 connect to testx

Database Connection Information

Database server = DB2/AIX64 9.1.5
SQL authorization ID = DB2INST3
Local database alias = TESTX

$ db2expln -d testx -g -t -q "select count(*) from test.table1"

DB2 Universal Database Version 9.1, 5622-044 (c) Copyright IBM Corp. 1991, 2006
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL and XQUERY Explain Tool

DB2 Universal Database Version 9.1, 5622-044 (c) Copyright IBM Corp. 1991, 2006
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL and XQUERY Explain Tool

******************** DYNAMIC ***************************************

==================== STATEMENT ==========================================

Isolation Level = Cursor Stability
Blocking = Block Unambiguous Cursors
Query Optimization Class = 3

Partition Parallel = No
Intra-Partition Parallel = No

SQL Path = "SYSIBM", "SYSFUN", "SYSPROC", "SYSIBMADM",
"DB2INST3"


Statement:

select count(*)
from test.table1


Section Code Page = 1208

Estimated Cost = 0.015853
Estimated Cardinality = 1.000000

Access Table Name = TEST.TABLE1 ID = 5,86
| Index Scan: Name = TEST1.IND_TEST ID = 2
| | Regular Index (Not Clustered)
| | Index Columns:
| | | 1: COL2 (Ascending)
| #Columns = 0
| #Key Columns = 0
| | Start Key: Beginning of Index
| | Stop Key: End of Index
| Index-Only Access
| Index Prefetch: None
| Lock Intents
| | Table: Intent Share
| | Row : Next Key Share
| Sargable Index Predicate(s)
| | Predicate Aggregation
| | | Column Function(s)
Aggregation Completion
| Column Function(s)
Return Data to Application
| #Columns = 1

End of section


Optimizer Plan:

RETURN
( 1)
|
GRPBY
( 2)
|
IXSCAN
( 3)
/ \
Index: Table:
TEST1 TEST
IND_TEST TABLE1

-Shri

[finditout]

Any update Experts !!!

[prakash56]

two options
1. db2expln -d testx -g -t -q "select count(*) from test.table1 with rr"

2. A. db2 set current isolation rrB. db2expln -d testx -g -t -q "select count(*) from test.table1"

cheers

[finditout]

Thanks.. but both of your solutions failed and not working.. and the question is.. From where db2 takes this value. As in my earlier example, I have changed isolation level just before taking explain still the explain report hasn't shown updated level.