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
What's The Error Code For Unique Index Voilation?
What is the maximum length of sqlca?
What are db2 tables?
What is explain in db2?
What are the different types of base tables?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Explain packages.
What is the difference between cursor stability and repeatable read isolation levels?
What action db2 takes when a program aborts in the middle of a transaction?
What is the maximum number of columns in a db2 table?
What is coalesce in db2?
What is declare cursor?
What is the use of db2 optimizer?
How is a typical db2 batch pgm executed?
Explain how can you do the explain of a dynamic sql statement?