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 do the initials DDL and DML stand for and what is their meaning?
what needs to be done if a table is in copy pending / check pending status?
What is the difference between group by and order by?
what are the bind parameters?
Can you tell me how can you find out the # of rows updated after an update statement?
What is drop table?
Discuss about db2 bind?
What os does db2 run on?
Explain in detail about buffer manager and its functionalities?
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 ?
What is the use of reorg in db2?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,