View previous topic :: View next topic
|
Author |
Message |
aprocon
New User
Joined: 26 Oct 2010 Posts: 41 Location: chennai
|
|
|
|
Hi all
I am using DB2 V 9.1 and soon going to migrate 10. I am looking for converting my segemnted tablespaces and partitioned tablespaces to range partitioned and partition by growth tablespaces. I am seeing plenty of advantages in moving to UTS but I am interested to see the other side of the coin as well in order to make my manager convinced. I looked for some cons. Below is what I found and I think there will be a few more if not many.
1) varchar columns will be added at the end - this makes the inablility to use the column number in order to refer a column
2) we need to be sure of the range before creating the range for keys.
If you can add some critical things to consider that will be of great help to me.
Thanks in advance!! |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
1) varchar columns will be added at the end - this makes the inablility to use the column number in order to refer a column |
could you explain that please?
Where do you use a column number to refer to a column?
(other than ORDER BY, and then it is the select-list ordinal)
Quote: |
2) we need to be sure of the range before creating the range for keys. |
when is this not a problem? do you not have to be aware of the key-range growth potential now?
as far as I can tell
(but I only have experience with db2 v2 thru 9)
an upgrade basically means
with each upgrade your dba's need to be a little more competent
and
a programming staff that will bother to read the manuals
inorder to take take advantages of the enhancements to sql
as well as recognize their sloppy/non-standard sql
allowed in earlier releases
needs to be 'tightened'.
so, as far as pro's:
take advantage of the enhancements to db2
con's:
need to educate your staff. |
|
Back to top |
|
|
|