473,231 Members | 1,984 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Question on a table reorg with clustering index.

Running DB2 version 8.1.1 on AIX 5.1.1

The table (employee) is being reorged and has a clustering index
(empid).

Is there any different between these two commands?

db2 reorg table employee index empid allow no access indexscan

db2 reorg table employee index empid allow no access

Thanks
Gerry

Nov 12 '05 #1
3 2305
<da*******@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Running DB2 version 8.1.1 on AIX 5.1.1

The table (employee) is being reorged and has a clustering index
(empid).

Is there any different between these two commands?

db2 reorg table employee index empid allow no access indexscan

db2 reorg table employee index empid allow no access

Thanks
Gerry

There is no functional difference in the result. If you use "indexscan", DB2
will use the index to retrieve the rows and avoid an external sort of the
data.
Nov 12 '05 #2
Also note that empid is the index with the cluster clause (clustering index)
and therefore you don't need to mention it in the reorg command. It will
"see" it as the clustering and use it to retrieve the rows in the reorg to
rebuild the table in the sequence of the indexscan and as mentioned, no
sort.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Mark A" <no****@nowhere.com> a écrit dans le message de
news:no********************@comcast.com...
<da*******@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Running DB2 version 8.1.1 on AIX 5.1.1

The table (employee) is being reorged and has a clustering index
(empid).

Is there any different between these two commands?

db2 reorg table employee index empid allow no access indexscan

db2 reorg table employee index empid allow no access

Thanks
Gerry
There is no functional difference in the result. If you use "indexscan",

DB2 will use the index to retrieve the rows and avoid an external sort of the
data.


Nov 12 '05 #3
Thanks much for the replies.

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: GB | last post by:
The main and index table space have page sizes of 8k The long data table space has page size of 4k The page size of the temporary table is 4k REORG TABLE USERBLAH.MYTABLE USE TEMPTBS; ...
10
by: Jean | last post by:
Hi, how to know for a particular table if it is organized by index, and which one ? reorg table index ind1 -> the table is organised by ind1 i wan't to know that for all table thx
3
by: datapro01 | last post by:
I have a question concerning reorgs. We have a relatively new DB2 system (8.1) on Aix 5.1 and we are trying to institute regular reorgs via scripts. Does it matter if the index for a table or...
2
by: TomHorner | last post by:
I have several quick questions about reorg's, and a request (favor). 1. The documentation says that reorg "Reorganizes an index or a table" I cannot see how one would reorg ONE particular index...
4
by: cmitchell | last post by:
Hi, I am looking for some suggestions as to what i can do to improve the following situation. If there is more detail you require please ask.. There are users inserting/altering data into a...
3
by: Antanas | last post by:
Why is that even though I have added index with DESC sort order on primary key, records in Control Center are displayed by the sequence they were previously inserted, not by the value of primary...
2
by: datapro01 | last post by:
Running DB2 8.2 on AIX 5.2 I have a question on reorgs and reorgchk results. My reorg script is using the db2reorgchk (which I understand has certain limitations) to determine if a table or an...
5
by: Sam Durai | last post by:
Do db2 system catalog table require maintenance (reorg/runstat) ? Thanks, Sam
2
by: dunleav1 | last post by:
I have a many row and many column table that is in a 16K page size. I have four indexes on the table. I am running row compression on the table. The table does not have a primary key. The table...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.