Answer / s

MODIFY RECOVERY utility

Answer / mehdee

The online REORG INDEX or REORG Table Space utility
reorganizes an index space or Table Space to improve access
performance and reclaim fragmented space.
RUNSTATS utility will collect inline statistics and update
DB2 catalog.

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

how do you resolve -805?

3 Answers   HCL,

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

How do I connect my db2 database to ibm?

0 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

Which component is responsible for processing sql statements and selecting access paths?

0 Answers  

---

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

4 Answers   ADP,

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---