Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 16972 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 |
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
what happend with out using Commit,when closing cursor and program?
How will fetch last 5 rows from table in db2
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
Can one database have multiple instances?
How will you return the number of records in table?
What is explain plan in db2?
Can we declare DB2 HOST variable in COBOL COPY book?
What is the syntax required for the creation of a cursor?
what is the role of the cursor in db2?
Can there be more than one cursor open for any program?
COBOL 
