What is db2 isolation?
Answers were Sorted based on User's Feedback
Answer / mohammadanis
DB2 Isolation is locking technqiue for tables.It can given
while binding the programs. There are several Isolation
levels are there,
1 CS(cursor stability)
2 RR(repeatable read)
3 RS(READ Stability)
4 UR(Uncommited read also known as Dirty read
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / bala
Isolation by its name explains the level by which two or more concurrent transactions are isolated from each other to maintain the data integrity in the database.
for example transaction A and transaction B are concurrent transactions, then it defines if A can read/update the data being modified by B or not and vice versa.
These Isolation levels will be used based on the business logic.
Is This Answer Correct ? | 2 Yes | 0 No |
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
Where could you look if you had a question about whether a column has been defined as an index?
Define declaration generator (dclgen).
Explain about mirror activator disk mirroring?
How can you display the current date & current time ?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What is the meaning concurrency in the db2 database?
what is differnece between DROP TABLE & DELETE TABLE .
Explain what are the various isolation levels possible?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??