Answer / s

May be asking about pageset.

Pageset is nothing but the datasets pertaining to a
tablespace. DB2 refers to tablespace as pagesets.

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

What is ibm db2 connect?

0 Answers  

---

How to find schema of a table in db2?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What is meant by a unit of recovery?

1 Answers  

---

What are the isolation levels possible ?

3 Answers  

---

How to get the ddl of a table in db2?

0 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

What is page size in db2?

0 Answers  

---

What is lock contention?

1 Answers  

---