Answer / a

What vamshi is said is incorrect .i.e he told about
RUNSTATS utility.

Where in REORG is used to re organise the table after huge
manipulation say insert,delete of records etc.It provides
free space also.

Correct me if i wrong vamshi/anyone

Answer / mehdee

REORG INDEX
The online REORG INDEX utility reorganizes an index space
to improve access performance and reclaim fragmented space.
You can specify the degree of access to your data during
reorganization, and you can collect inline statistics by
using the STATISTICS keyword.

REORG TABLESPACE
The online REORG TABLESPACE utility reorganizes a table
space to improve access performance and to reclaim
fragmented space. In addition, the utility can reorganize a
single partition or range of partitions of a partitioned
table space.
Traditionally, tablespace reorg consists of the following
steps:
• unload of the data
• redefinition of the tablespace
• reload of the data
• rebuild of the indexes

Now that we know what it dose, it is a DBA person to run
it as required.

Answer / thiru

Yes What Vamsi said is right. But not only it will re-
organise or re arrange the occupied and un occupied space
of the perticular table. By default when we add a new
column to the existing table db2 V9 onwards the REORG is
compulsary. otherwise from any application the table will
not be accessed.
while doing the REORG after New column addition or Bulk
Insert/Load it will rearrange the data internally based on
the indexes available from the table. hence further search
as well as other operations will be faster.

Answer / vamsikrishnamraju

Calculates statistics on the database to determine if
tables or indexes, or both, need to be reorganized or
cleaned up.

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

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  

---

---

What is concurrency?

0 Answers  

---

What is referential integrity?

5 Answers  

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

---

Highlight all the advantages that are attached to a package.

0 Answers  

---

What are the various locks available?

5 Answers   CTS,

---

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

2 Answers   Accenture,

---