What is reorg in DB2

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


Please Help Members By Posting Answers For Below Questions

Can we insert update delete in view?

568


Explain package in db2 and its advantages?

589


How to take backup of table in db2?

591


How to check last update on table in db2?

624


What r the comman abends in db2, jcl and cobol???????

1812






What does db2 stand for?

593


What is package in cobol db2?

695


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1700


What is lock escalation in db2?

567


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

621


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

739


Mention some fields that are a part of sqlca.

592


What's The Error Code For Unique Index Voilation?

645


What is a db2 schema?

756


How do I start db2 in windows?

554