Thanks for your help; I will put a weekly job to do the org for those
indexes.
----- Forwarded by Sheuehua Leufuh/NYC-NY/US/Marsh/MMC on 08/28/2006 05:11
PM -----

db2udbdba-ezmlmsh
ield-x8697617.x11
[Email Address Removed] To
[Email Address Removed] [Email address protected]

08/28/2006 04:38 cc
PM

Subject
reorg question















HI all,

Some of our production tables when created primary key but
without specifying pk constraint name initially and db2 create index name
as in sysibm schema and with funny as SQL050728115814520. When I reorg
index can I use command as
"db2 "REORG TABLE VSADMIN.PERSON_XREF index sysibm.SQL050728115814520 use
TEMPSPACE1".
Thanks for any help !!

Sue


**********************************************************************
This e-mail transmission and any attachments that accompany it may contain
information that is privileged, confidential or otherwise exempt from
disclosure under applicable law and is intended solely for the use of the
individual(s) to whom it was intended to be addressed. If you have received
this e-mail by mistake, or you are not the intended recipient, any
disclosure, dissemination, distribution, copying or other use or retention
of this communication or its substance is prohibited. If you have
received this communication in error, please immediately reply to the
author via e-mail that you received this message by mistake and also
permanently delete the original and all copies of this e-mail and any
attachments from your computer. Thank you.
**********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



To: [Email address protected]
cc: (bcc: Sheuehua Leufuh/NYC-NY/US/Marsh/MMC)
From: db2udbdba-ezmlmshield-x8697617.[Email address protected]



**********************************************************************
This e-mail transmission and any attachments that accompany it may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law and is intended solely for the use of the individual(s) to whom it was intended to be addressed. If you have received this e-mail by mistake, or you are not the intended recipient, any disclosure, dissemination, distribution, copying or other use or retention of this communication or its substance is prohibited. If you have received this communication in error, please immediately reply to the author via e-mail that you received this message by mistake and also permanently delete the original and all copies of this e-mail and any attachments from your computer. Thank you.
**********************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page