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

what is load and unload in db2

1 Answers   IBM,

---

What is read-only cursor?

1 Answers  

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

Which transaction use a command thread ?

1 Answers  

---

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

---

Explain the function done by data manager?

0 Answers  

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

What is load utility in db2?

0 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---