Answer / sadiq afroze

Number of rows in the table, Percent of rows in clustering
sequence, Number of distinct values of indexed column,
Number of rows moved to a nearby/fairway page due to row
length increase

Why do we need reorg in db2?

0 Answers  

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

How is a typical DB2 batch program executed ?

1 Answers  

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

What is explain in db2?

0 Answers  

---

What is load replace in db2?

0 Answers  

---

What is the physical storage length of date data type?

0 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,

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

Mention the various locks that are available in db2.

0 Answers  

---