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
What are the bind parameters ibm db2?
What is phantom read in db2?
How to check table size in db2 sap?
What is the use of db2 optimizer?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the difference between using bind () and rebind () methods of naming class?
What is the difference between nvl and coalesce?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Why do we bind in db2?
What is load replace in db2?
How to find schema of a table in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference