Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is FREEPAGE and PCTFREE in TABLESPACE creation?



What is FREEPAGE and PCTFREE in TABLESPACE creation?..

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.

Is This Answer Correct ?    11 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is meant by concurrency?

1 Answers  


What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,


Explain the function of data manager.

0 Answers  


What is a view? Why use it?

2 Answers  


Can any one tell me about Restart logic in DB2.

2 Answers  


Explain correlated sub-queries.

0 Answers  


How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,


what is a collection?

2 Answers  


What is host variable in db2 cobol?

0 Answers  


What are the functions in DB2?

3 Answers   Satyam,


what is the name of the default db2 catalog database?

3 Answers   IBM,


what are the bind parameters?

5 Answers   IBM,


Categories