Answer Posted / vivekk ram
when ever a record is deleted, it marks the record to be deleted but the physically it is not deleted in db. So using reorg command is ran, it physically deletes the record from db.
Please correct me, if i'm wrong..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can record locking be achieved in those DB2 versions which do not support it?
When the like statement is used?
What is the difference between using bind () and rebind () methods of naming class?
How many types of page locks can be held in db2?
What is syscat in db2?
What is explain in db2?
What is dbrm? What it contains? When it will be created?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Why cursor is used in db2?
What is a db2 table?
Define db2.
What is release/acquire in bind?
Mention the various locks that are available in db2.
What is node in db2?
Explain the contention situations caused by locks?