Answer Posted / shailendra

extent means not a continious memory allocation.
its means the number of gap between the memory allocation
is possible when data is going to store.
if the extent is full then just run the jcl
with

space=(cyl or blk,(primary,secondary,directory,3),rlse)

it will increase the no extent by 3*16
previously it was 1*16.

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2167

---

Why cursor is used in db2?

985

---

How do you find the maximum value in a column in db2?

1052

---

What is rebind in db2?

999

---

What is release/acquire in bind?

1057

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

---

What is the purpose of rollback and commit?

1086

---

What is iseries database?

990

---

Which isolation level provides highest data integrity?

1039

---

What is db2 bind?

1016

---

Explain dclgen.

1144

---

What is the use of value function?

1074

---

What is the connection string to connect to the DB2 Database ?

1059

---

Which component is responsible for db2 startup and shutdown?

980

---

What is db2 stogroup?

1095

---