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.

What is dbrm in db2 database?

580

---

Define predicate?

639

---

What is db2 bind process?

748

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

574

---

What are db2 objects?

633

---

---

How to access db2 tables in mainframe?

611

---

What's The Percentage Free Space ?

760

---

What is a collection in db2?

577

---

What do you mean by between and in? Is between inclusive of specified range values?

661

---

What is cascading rollback?

615

---

What is null value in db2?

557

---

Why do we bind in db2?

621

---

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

695

---

What is the difference between using bind () and rebind () methods of naming class?

782

---

What is the purpose of using commit?

612

---