What is Reorg Recovery? when will you run it?

Answer Posted / s.v.venkata sivaprasad

reorg is a db2 use to improve the performance and any unused
pages in table space is rearange it perticul order and
release free space
//job1 job....
//step1 exec pgm=IKJEFT01
//sysin dd *
reorg db123.tb123
//

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is db2 free?

685


What is the usage of open cursor command?

601


How to test SQL -911 error while developing COB-DB2 program

6721


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3797


What parameters are used to control the free space in DB2?

645






How do you eliminate duplicate values in db2?

690


What is the function of logging in the db2 database?

647


What do you mean by between and in? Is between inclusive of specified range values?

670


What is ibm db2 used for?

603


What is db2 optimizer?

773


What is ibm db2 client?

523


Which component is responsible for db2 startup and shutdown?

630


What are the contents of dclgen?

661


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

755


What does db2 blu stand for?

664