Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
UTS disadvantages

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Thu Nov 15, 2012 5:00 am    Post subject: UTS disadvantages
Reply with quote

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
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Thu Nov 15, 2012 7:36 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts BLSR - Advantages & Disadvantages reachsenthilnathan JCL & VSAM 1 Thu Jul 14, 2011 6:34 pm
No new posts Advantages and disadvantages of cobol... Robert Sample COBOL Programming 1 Tue Mar 31, 2009 5:00 pm
No new posts Disadvantages of using 77 Level variable Souparno COBOL Programming 6 Wed Sep 24, 2008 9:31 am
No new posts Disadvantages of increasing the SEGNO? AshimSreedhar IMS DB/DC 1 Sat Jul 12, 2008 1:46 am
No new posts Advantages and Disadvantages of Mainf... enrico-sorichetti All Other Mainframe Topics 4 Sat Oct 13, 2007 1:00 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us