Interested to Buy Any Domain ? << Click Here >> for more details...
What is FREEPAGE and PCTFREE in TABLESPACE creation?
- 1 Answers
- 17186 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 |
how can u retrieve the data from null values using applicaion program.
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How does one remove entries from the SCT02 table?
When Can you be sure that a query will return only one row?
what is check point and restart Logic ? why do we go for that ??
What is a buffer pool?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
how to resolve -805. give clear explination for that
What is difference between alias and synonym in db2?
How do I copy a table in db2?
what is static sql? what is dynamic sql? Give me details
COBOL 
