Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Too high expectations ADMIN_MOVE_TABLE?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-13-11, 04:12
dr_te_z dr_te_z is offline
Registered User
  
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Too high expectations ADMIN_MOVE_TABLE?
Busy building & testing scripts to move various tables to other tablespaces/use table-partitioning etc.
Using the new ADMIN_MOVE_TABLE (be sure you have FP4) makes it all easy to do so online with an active database during daytime.....

I had high expectiations, BUT:
- to be able to move a table you have to drop all FK-constaints
- when you are finished moving the table around, you must re-create your FK's
- ALTER TABLE ADD FK constraint causes massive LOCKS

So, you cannot do this on an active database so the added value is NULL?!?

We want to run our database 24x7 and I really hoped the new V9.7 could help me.
Am I too pessimistic? Did I miss something?
Reply With Quote
  #2 (permalink)  
Old 10-13-11, 07:09
DBFinder DBFinder is offline
Registered User
  
Join Date: Sep 2008
Location: Toronto,Canada
Posts: 606
I am having same concerns.

How can we get around this, can someone help ??

Regards
DBFinder
Reply With Quote
  #3 (permalink)  
Old 10-14-11, 07:19
stolze stolze is offline
Registered User
  
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
Foreign keys are not yet supported for ADMIN_MOVE_TABLE. So you'll have to use the described work-around (dropping re-creating FKs) with all the implications. There is work going on to address this short-coming in a future version of DB2, though.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
  #4 (permalink)  
Old 10-14-11, 09:44
dr_te_z dr_te_z is offline
Registered User
  
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Quote:
Originally Posted by stolze View Post
a future version of DB2
Hmmm that means that FP5 is "a little bit" too optimistic?

The next version is announced november 14th .... Guess where I will be at that date. It is in the country where they invented
Reply With Quote
  #5 (permalink)  
Old 10-17-11, 03:19
nvk@vhv nvk@vhv is offline
Registered User
  
Join Date: Jan 2010
Posts: 294
Quote:
Originally Posted by dr_te_z View Post
The next version is announced november 14th .... Guess where I will be at that date. It is in the country where they invented
You are going to iraq? History of beer - Wikipedia, the free encyclopedia
SCNR
Reply With Quote
  #6 (permalink)  
Old 10-17-11, 04:25
dr_te_z dr_te_z is offline
Registered User
  
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Quote:
Originally Posted by nvk@vhv View Post
You are going to iraq?
Nice try

No, I am staying closer to home (from where I stand). I am going to the IDUG in Prague next month. Prague is not too far away from the city of Pilsen Pilsner - Wikipedia, the free encyclopedia.
Maybe I'll meet some of you there?
Reply With Quote
  #7 (permalink)  
Old 10-17-11, 05:11
sathyaram_s sathyaram_s is offline
Super Moderator
  
Join Date: Aug 2001
Location: UK
Posts: 4,534
Quote:
Originally Posted by dr_te_z View Post
I am going to the IDUG in Prague next month.
Are you there the whole week ?
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #8 (permalink)  
Old 10-17-11, 05:48
dr_te_z dr_te_z is offline
Registered User
  
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Quote:
Originally Posted by sathyaram_s View Post
Are you there the whole week ?
Yes. Landing on Sunday and for the Friday I am going to Scott Hayes' session. Looking forward to that.
Reply With Quote
  #9 (permalink)  
Old 10-17-11, 08:59
db2girl db2girl is offline
∞∞∞∞∞∞
  
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Quote:
Originally Posted by nvk@vhv View Post
Reply With Quote
  #10 (permalink)  
Old 10-17-11, 09:03
db2girl db2girl is offline
∞∞∞∞∞∞
  
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Quote:
Originally Posted by dr_te_z View Post
I am going to the IDUG in Prague next month
Nice vacation and for free.


Quote:
Originally Posted by dr_te_z View Post
The next version is announced november 14th .... Guess where I will be at that date. It is in the country where they invented
Was DB2 invented in Czech Rep (Czechoslovakia)?
Reply With Quote
  #11 (permalink)  
Old 10-17-11, 09:27
dr_te_z dr_te_z is offline
Registered User
  
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Quote:
Originally Posted by db2girl View Post
Nice vacation and for free.
Shhhht. I told my boss it was work!
Quote:
Originally Posted by db2girl View Post
Was DB2 invented in Czech Rep (Czechoslovakia)?
No, but beer was (pilsner to be exact).
Reply With Quote
  #12 (permalink)  
Old 10-18-11, 13:57
stolze stolze is offline
Registered User
  
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
Quote:
Originally Posted by dr_te_z View Post
No, I am staying closer to home (from where I stand). I am going to the IDUG in Prague next month. Prague is not too far away from the city of Pilsen Pilsner - Wikipedia, the free encyclopedia.
Maybe I'll meet some of you there?
Czech Republic is really nice. I'm there twice a year - on the race track in Most (just 3h away from my home town). There, I'm taking care of my part in global warming efforts.

p.s: I don't know myself what the referred-to "next version" is going to be. Maybe a FixPak, maybe the next release, maybe some other release.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
  #13 (permalink)  
Old 10-19-11, 02:40
przytula_guy przytula_guy is offline
Registered User
  
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
maybe we will meet ..
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #14 (permalink)  
Old 10-19-11, 06:19
dr_te_z dr_te_z is offline
Registered User
  
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Quote:
Originally Posted by stolze View Post
Czech Republic is really nice.
I know, I agree. Been there a few times for the winter holiday. Because of lack of snow we had to travel to germany every day to be able to ski (Bayerisch Eisenstein im Bayerischen Wald - Home).

Last time I visited Prague it was still in another country and the Iron curtain was still closed. Wonder if it changed much.

Quote:
Originally Posted by przytula_guy View Post
maybe we will meet ..
Lets start a "rendez vous" thread in that week. Pick a time & place and
Who will be there?
Reply With Quote
  #15 (permalink)  
Old 10-19-11, 18:32
db2girl db2girl is offline
∞∞∞∞∞∞
  
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Quote:
Originally Posted by dr_te_z View Post
Pick a time & place and
Czech Rep is #1 by beer consumption as per:
List of countries by beer consumption per capita - Wikipedia, the free encyclopedia


Lots of empty calories...
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.