What Are The Levels Of Isolation Available With Db2v4?

1.	What Are The Levels Of Isolation Available With Db2v4?
Answer» CS RR UR( ADDED new for DB2V4 which stands for uncommited read which allows to retreive RECORDS from the space which has EXCLUSIVE locks also but data integrity will be affected if this OPTION is USED )The best available option for data integrity & data concurrency is CS. CS RR UR( added new for DB2V4 which stands for uncommited read which allows to retreive records from the space which has exclusive locks also but data integrity will be affected if this option is used )The best available option for data integrity & data concurrency is CS.

Answer»

CS RR UR( ADDED new for DB2V4 which stands for uncommited read which allows to retreive RECORDS from the space which has EXCLUSIVE locks also but data integrity will be affected if this OPTION is USED )The best available option for data integrity & data concurrency is CS.

CS RR UR( added new for DB2V4 which stands for uncommited read which allows to retreive records from the space which has exclusive locks also but data integrity will be affected if this option is used )The best available option for data integrity & data concurrency is CS.

Discussion

No Comment Found

Related InterviewSolutions

How Many Subqueries Can You Combine Together ?
What Is Join And Different Types Of Join?
How Many Bufferpools Are There In Db2 And What Are They?
B37 Abend During Spufi?
What Is The Command Used By Tso Users To Invoke Db2?
What Should Be Specified Along With A Cursor In Order To Continue Updating Process After Commit?
What Is The Name Of The Default Db2 Catalog Database?
When Can You Be Sure That A Query Will Return Only One Row?
What Is The Difference Between Join And Union?
What Is A Corelated Subquerry?