Answer / abhishek kale

PCTFREE indicates to DB2 what percentage of each page in
the table space or index to leave free when either loading
or reorganizing the data. DB2 will then use that free space
when inserting new rows and index entries.

FREEPAGE indicates to DB2 how often to leave a full page of
free space when either loading or reorganizing the data.
For example, if you specify FREEPAGE 5, DB2 will allocate a
page of free space after filling five pages with data.

What is the difference between oracle and db2?

0 Answers  

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

how can we find nth max salary from A table

5 Answers   IBM,

---

Which is faster delete or truncate?

0 Answers  

---

---

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

select 100 records from million records ?

2 Answers   Verizon,

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---