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

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.

What are the full forms of spufi and dclgen and why are they used?

0 Answers  

---

What information is held in SYSIBM.SYSCOPY?

1 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

What is dbrm? When it will be created?

0 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---

Update command

1 Answers  

---