Ed,
Thanks so much for your help.
Becuase this table has 6000000 records ; I am trying to avoid to
copy it to other table.
I think I will create a export dump and rebuild the primary key on
the old table.
Sue



"Edwards Ed " <db2udbdba-ezmlmshield-x97184223.[Email address protected]
04/26/2007 09:13 AM


To
"LazyDBA Discussion" <[Email address protected]

cc


Subject
RE: How to rebuild primary key on same table







Yes. You can go ahead and drop the old primary key and create the new
primary key. It would not hurt to copy the old table to a new table.





Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality of
services provided to you.Simply use the link below. Thank you in advance
for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Sheuehua
[mailto:db2udbdba-ezmlmshield-x81185650.[Email address protected]
Sent: Thursday, April 26, 2007 8:53 AM
To: LazyDBA Discussion
Subject: How to rebuild primary key on same table


Hi,
I got a request to rebuild primary key on same table; one table
called "promotion_history", initial has 2 columns as
a primary key; now they want to rebuilt with adding addition one cloumn
(
client_name).
I select with group by to find any count > 1 within those 3 columns to
make
sure not duplicate records.
There is not FK constrants on this table; can I go ahead drop old
primary
key and rebuild the new primary key with 3 colums.
Do I have to copy the old table to a new table, in case of the bulding
failed?

Thanks for your 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 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: "LazyDBA Discussion" <[Email address protected]
cc:
From: "Edwards Ed "
<db2udbdba-ezmlmshield-x97184223.[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