Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 17082 Views
- I also Faced
- E-Mail Answers
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 is the usage of open cursor command?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
Why select is not preferred in embedded sql programs?
Which are the db2 tools to protect integrity of the database?
How many buffer pools are there in DB2?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
When Can you be sure that a query will return only one row?
Can one database have multiple instances?
What is a precompiler?
What is the command used by TSO users to invoke DB2?
List down the data types in the db2 database.
What is the maximum length of sqlca?
COBOL 
