[From Vwall: Suspected SPAM]: Re: [DB2-L] Reorg Prblem

Philip Sevetson

[From Vwall: Suspected SPAM]: Re: [DB2-L] Reorg Prblem
Any reason not to DSN1COPY the indexes too? (Don't forget to put the TS and index in RO or STOP mode first)

--Phil Sevetson, NYCAPS DBA Support
Financial Information Services Agency of The City of New York
450 West 33rd Street, 4th Floor
New York, NY 10001
phone: (212) 857-1688
mailto: [login to unmask email]
________________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of duam lee
Sent: Tuesday, January 15, 2008 2:51 PM
To: [login to unmask email]
Subject: [From Vwall: Suspected SPAM]: Re: [DB2-L] Reorg Prblem

Correct Phil,
Bench marks are challenge always. But when we go for the DSN1COPY then what about indexes build. The data portion is disorganized , but I guess index build would make the index more organized than earlier. So any updates/suggestions for this.


With Thanks
Duam.

________________________________________
Date: Tue, 15 Jan 2008 16:27:18 +0000
From: [login to unmask email]
Subject: Re: [DB2-L] Reorg Prblem
To: [login to unmask email]
to run reproducible benchmarks perhaps?
That's ALWAYS a challenge
An easier way is to DSN1COPY the table BEFORE you reorg it and then put the copy back to run the next test - also ensures that all reorgs are reorganising exactly the SAME disorganised data
Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]
Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL


________________________________________
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Doyle Mark
Sent: 15 January 2008 16:12
To: [login to unmask email]
Subject: Re: [DB2-L] Reorg Prblem
Duam,
Your question prompts me to ask "why?"
If, for instance, you want to trigger a conditional reorg, there is a much easier way to do this, namely, updating the FAROFFPOSto bethe cardinality of the table.
Mark -----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of duam lee
Sent: Tuesday, January 15, 2008 2:40 AM
To: [login to unmask email]
Subject: Reorg Prblem
Hi List,

What is the best way to disorganize a table which is now perfectly re-organized. Deletion of records more that 20 percent and insert the same would be one example I think of now. If record length is variable, then mass update can also do. I am looking for any other way I can disorganize the tablespace soon.

With Thanks
Duam.


=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Raey

Re: Reorg Prblem
(in response to Philip Sevetson)
How about following the below steps to disorganize a table

1. drop the clustering index, hopefully you have two indexes on this table
2. reorg the table
3. create the clustering index

Regards,
Ayalew

duam lee <[login to unmask email]> wrote:
.hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } Correct Phil,

Bench marks are challenge always. But when we go for the DSN1COPY then what about indexes build. The data portion is disorganized , but I guess index build would make the index more organized than earlier. So any updates/suggestions for this.



With Thanks
Duam.




---------------------------------
Date: Tue, 15 Jan 2008 16:27:18 +0000
From: [login to unmask email]
Subject: Re: [DB2-L] Reorg Prblem
To: [login to unmask email]

.ExternalClass .EC_hmmessage P {padding-right:0px;padding-left:0px;padding-bottom:0px;padding-top:0px;} .ExternalClass EC_BODY.hmmessage {font-size:10pt;font-family:Tahoma;} to run reproducible benchmarks perhaps?

That's ALWAYS a challenge

An easier way is to DSN1COPY the table BEFORE you reorg it and then put the copy back to run the next test - also ensures that all reorgs are reorganising exactly the SAME disorganised data

Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company registration number 1282495 with its registered office at the address set out above. VAT number 697904179.





---------------------------------
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Doyle Mark
Sent: 15 January 2008 16:12
To: [login to unmask email]
Subject: Re: [DB2-L] Reorg Prblem



Duam,

Your question prompts me to ask "why?"

If, for instance, you want to trigger a conditional reorg, there is a much easier way to do this, namely, updating the FAROFFPOS to be the cardinality of the table.

Mark



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of duam lee
Sent: Tuesday, January 15, 2008 2:40 AM
To: [login to unmask email]
Subject: Reorg Prblem


Hi List,



What is the best way to disorganize a table which is now perfectly re-organized. Deletion of records more that 20 percent and insert the same would be one example I think of now. If record length is variable, then mass update can also do. I am looking for any other way I can disorganize the tablespace soon.



With Thanks
Duam.



---------------------------------
Express yourself instantly with MSN Messenger! MSN Messenger
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services
______________________________________________________________________
This electronic message and any attachment is intended exclusively for the individual or entity to which it is addressed. It may contain information that is privileged, confidential and exempt from disclosure und er applicable law. Any unauthorized disclosure, copying, distribution or use of this electronic message or any attachment is prohibited. If you have received this message in error, please return it to the sender and delete this original from your system.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services

---------------------------------
Express yourself instantly with MSN Messenger! MSN Messenger
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services


---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Phil Grainger

Re: Reorg Prblem
(in response to Raey)
er, yes

DSN1COPY the indexes as well - it's not only for tablespaces

btw, DON'T use dfp to do this unless you can guarantee that extents
won't e consolidated

Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.





________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of duam lee
Sent: 15 January 2008 19:51
To: [login to unmask email]
Subject: Re: [DB2-L] Reorg Prblem


Correct Phil,

Bench marks are challenge always. But when we go for the DSN1COPY then
what about indexes build. The data portion is disorganized , but I guess
index build would make the index more organized than earlier. So any
updates/suggestions for this.



With Thanks
Duam.



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Doyle Mark
Sent: 15 January 2008 16:12
To: [login to unmask email]
Subject: Re: [DB2-L] Reorg Prblem


Duam,

Your question prompts me to ask "why?"

If, for instance, you want to trigger a conditional reorg, there
is a much easier way to do this, namely, updating the FAROFFPOS to be
the cardinality of the table.

Mark


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of duam lee
Sent: Tuesday, January 15, 2008 2:40 AM
To: [login to unmask email]
Subject: Reorg Prblem


Hi List,



What is the best way to disorganize a table which is now
perfectly re-organized. Deletion of records more that 20 percent and
insert the same would be one example I think of now. If record length is
variable, then mass update can also do. I am looking for any other way I
can disorganize the tablespace soon.



With Thanks
Duam.



________________________________

Express yourself instantly with MSN Messenger! MSN Messenger
< http://clk.atdmt.com/AVE/go/onm00200471ave/direct/01/ >
The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org < http://www.idug.org/lsidug > under the Listserv tab. While
at the site, you can also access the IDUG Online Learning Center, Tech
Library and Code Place, see the latest IDUG conference information, and
much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services

______________________________________________________________________
This electronic message and any attachment is intended
exclusively for the individual or entity to which it is addressed. It
may contain information that is privileged, confidential and exempt from
disclosure und er applicable law. Any unauthorized disclosure, copying,
distribution or use of this electronic message or any attachment is
prohibited. If you have received this message in error, please return it
to the sender and delete this original from your system.

The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org < http://www.idug.org/lsidug > under the Listserv tab. While
at the site, you can also access the IDUG Online Learning Center, Tech
Library and Code Place, see the latest IDUG conference information, and
much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services
The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org < http://www.idug.org/lsidug > under the Listserv tab. While
at the site, you can also access the IDUG Online Learning Center, Tech
Library and Code Place, see the latest IDUG conference information, and
much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services


________________________________

Express yourself instantly with MSN Messenger! MSN Messenger
< http://clk.atdmt.com/AVE/go/onm00200471ave/direct/01/ >
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < http://www.idug.org/lsms >
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms