What does the REORG Utility do?
Answers were Sorted based on User's Feedback
Answer / guest
REORG is a db2 utlity, to reclustering, reclaim the table
space. it used when the bulk updates or inserts happens.
| Is This Answer Correct ? | 23 Yes | 5 No |
Answer / harsha
Reorg is done when
1) clustratio <80% ( for IBM stranded)
2) when altering the Cluster object
3) when dropping the cluster object
4) when bulk updates and inserts are done
5) space reclamation
6) when a table is changed from compression to decompression
mode
| Is This Answer Correct ? | 6 Yes | 2 No |
pls tell me abt the normalization five types....
What is runstats and reorg in db2?
How to define the data items to receive the fetch items for the SQL?
What is cursor stability?
What keyword does an SQL SELECT statement use for a string search?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
Can any one tell me about Restart logic in DB2.
pls explain the precompilation process of cobol-db2 pgm
when does the SQL statement gets executed when you use cursor in the application programming ?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?