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|
What are the abend codes occour in ur latest PROJECT in DB2
What is cloudant database?
Explain the function of data manager.
Define db2 and its databases?
What is the maximum No of rows per page?
How would you find out the total number of rows in a db2 table?
Why cursor is used in db2?
What is explain plan in db2?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
How do you stop a db2 database in linux?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
can any body explain about plan and pakage in detail....