What is the significance of DB2 free space and what
parameters control it?
Answer Posted / 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 |
Post New Answer View All Answers
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
i want to maintain uniqueness on pdf without make lf??????????
What is the maximum size of varchar data type in db2?
What is consistency token in db2?
Explain about cursor stability?
What is difference between rollback and commit?
What is the use of dclgen in db2?
How to find schema of a table in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How do I delete a table in database?
Explain dclgen.
How to find primary key of a table in db2?
What is an instance database?
Explain the contention situations caused by locks?
What is iseries database?