Answer / guest

REORG is a db2 utlity, to reclustering, reclaim the table
space. it used when the bulk updates or inserts happens.

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

Once you create a view, where would information about the view be stored?

1 Answers  

---

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 ?...

0 Answers   IBM,

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

Which transaction use a command thread ?

1 Answers  

---

What is the database descriptor?

2 Answers  

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,

---

What is bind in db2?

0 Answers  

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---