What is FREEPAGE and PCTFREE in TABLESPACE creation?
Answer Posted / 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 View All Answers
How can we retrieve the total number of records in RPG & CLLE?
Can we insert update delete in view?
Explain correlated sub-queries.
What is copy pending status in db2?
What is check constraint in db2?
How can you classify the locks in db2?
What is meant by dclgen?
What is db2 command?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What are catalog tables in db2?
What is database reorganization?
Explain packages.
List down the data types in the db2 database.
What is a trigger in the db2 database?