Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Migraiting from V8 to V10

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

New User


Joined: 11 May 2010
Posts: 16
Location: South Africa

PostPosted: Mon Jan 10, 2011 3:27 pm    Post subject: DB2 Migraiting from V8 to V10
Reply with quote

We need to Migrate from DB2 VA8 to DB2 VA10 directly in other words skipping VA9 for one of our clients.

Can anybody tell me what the implications will be on the applications side.

Thanks
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Jan 10, 2011 6:21 pm    Post subject:
Reply with quote

It might help you a bit:

http://it.toolbox.com/blogs/db2zos/8-to-10-9-to-10-both-are-paths-to-db2-10-41931
Back to top
View user's profile Send private message
Heindba

New User


Joined: 11 May 2010
Posts: 16
Location: South Africa

PostPosted: Mon Jan 10, 2011 6:28 pm    Post subject:
Reply with quote

Thanks Anuj,

but it doesn't really specify what the impact on applications might be, and I really need to know what the impact on applications will be.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Jan 11, 2011 4:13 am    Post subject:
Reply with quote

Hi Heindba,

In the DB2 10 Installation and Migration Guide look for below chapters and subsection. It will give you a listing of all you wanted to know.

DB2 10 for z/OS > Installing and migrating DB2 > Installation and migration > Preparing your system to install or migrate DB2 > Changes that might affect your migration from Version 8


Thanks,
Sushanth
Back to top
View user's profile Send private message
Heindba

New User


Joined: 11 May 2010
Posts: 16
Location: South Africa

PostPosted: Tue Jan 11, 2011 11:42 am    Post subject:
Reply with quote

Thanks you sushanth,

Will check it out
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Jan 11, 2011 1:25 pm    Post subject:
Reply with quote

Would be helpful to others if you would update this thread as you encounter different situations.

As DB2 Vsn10 is as yet installed in few sites, you are apparently one of the first.

I expect my site to start generating db2 vsn10 dbrm's in a 'sandbox' situation,
basically to find what new db2 pre-compile error will result,
around 3rd or 4th quarter this year.

Since each release of db2 involves a new pre-compiler
(whether separate or part of the program language compile step - e.g. enterprise cobol)
and each new pre-compiler is 'stricter' than the last,
would be interesting to know if there are any tighter restrictions on Reserved Word usage.
I know that there are new reserved words in vsn 10,
but vsn 9 does not inhibit use of reserved words as column names
when they are not used in an ambiguous manner.
I fear that eventually the db2 pre-compiler authors are going to just
going to fail (flag as error) reserved words used as column names;
hopefully not Vsn10.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Tue Jan 11, 2011 1:40 pm    Post subject:
Reply with quote

wow, a company with balls: all the experts I spoke to said (off the record) "don't do it".
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Jan 11, 2011 2:39 pm    Post subject:
Reply with quote

as a follow-up on this discussion of reserved words:
http://ibmmainframes.com/viewtopic.php?t=52976

problem here is we have hundreds of tables that use 55 reserved words of the db2 vsn10 list of reserved words for column names.

changing the column names is a non-starter.
we are stuck with 'quoting' the column names,
as qualification has problems with maintenance.
Back to top
View user's profile Send private message
Heindba

New User


Joined: 11 May 2010
Posts: 16
Location: South Africa

PostPosted: Tue Jan 11, 2011 4:20 pm    Post subject:
Reply with quote

While we are on the whole DB2 subject and new versions etc.

Can someone please provide me with a link or a list of what has fallen away from DB2 V8 and what is new in DB2 v9?

Thanks for the help guys.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue Jan 11, 2011 4:29 pm    Post subject:
Reply with quote

http://www-01.ibm.com/support/docview.wss?uid=swg27019288
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:



Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us