What is the significance of DB2 free space and what
parameters control it?
Answer / s
Free space is used by DB2 to maintain data clustering and
variable length rows. FREE PAGE,PCTFREE
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
What is the difference between TYPE 1 index & TYPE 2 index
What is the picture clause of the null indicator variable?
What is a trigger in the db2 database?
What parameters are used to control the free space in DB2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Is db2 free?
What Utility is used to migrate DB2 from one release to the next?
Why do we use cursor?
Compare a subselect to a join?