Solved

Need help to develop Plan Migrating DB2 on z/OS to DB2 UDBv9.5 on AIX 5.3

Posted on 2011-02-27
7
1,253 Views
Last Modified: 2012-05-11
Hello all,
I need help developing and documenting a usable data migration plan that describes the strategy, preparation, and specifications for migrating/converting from current DB2v9 on z/OS to DB2 UDB on AIX environment. I looking for document examples of a fully treated plan used by someone who had done this kind of project. My data is going from the mainframe to AIX, what are the challenges and gotchas, if any, I should be aware of? Any major difference between the DB2 object on the mainframe or AIX that may "trip" a AIX newbie? Are there some links to where I can find more resources for this ind of project?

Any and all response will br highly appreciated.

Okonita
0
Comment
Question by:Okonita001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 45

Accepted Solution

by:
Kent Olsen earned 350 total points
ID: 34996858
Hi Okonita,

Good questions.  :)

Before embarking on this task, you should understand this this is a full conversion/migration, just as converting from Oracle to DB2 would be.  There are a lot of similarities between DB2 for Z/OS and UDB/LUW, but that's mostly in the SQL and client ends.  The database engine (server) is a completely different code base with different requirements and tools.

The first thing that you'll need is a plan to migrate the data.  (Tables and table spaces.)  The Z/OS backups are not compatible with the LUW tools so you won't be able to simply restore a database backup.  The data will have to be migrated from Z/OS.  Depending on a several factors, you may be able to "Federate" the systems (IBM's terminology for logically linking the database server) so that the Z/OS tables can be seen from the LUW server.  You can then directly query the Z/OS tables from the LUW server and populate the LUW tables.  The other choice is to export the Z/OS data in IXF format and import it into the LUW server.  Both approaches have their strengths.  If you have a lot of data, the IXF export is probably the better choice.

The plan should include sizing.  Make sure that there is enough storage and the AIX server and that it organized in a logical fashion.

The next step will be to migrate the objects.  (Stored procedures, views, triggers, etc.)  The triggers should require very few changes, if any.  Most views should also require few changes, with the biggest concern being references to schemas that don't exist in the new environment.  Anything that references the system tables will have to be modified as the system environment (tables, views, names, etc.) is different.  Stored procedures will be the most work to convert as there will probably be SQL differences that will affect them.  And, of course, any references to system objects in the stored procedures.

Z/OS uses an EBCDIC character set.  AIX, like most all other servers, uses ASCII.  Any code (views, stored procedures, and external applications) the rely on the EBCDIC coding, or reference characters by binary value (e.g. '0x12') will have to be converted.

IBM has migration tools and checklists.  I'll track some down.  In the meantime, this is a "short list" of things to keep in mind.


Kent
0
 
LVL 57

Assisted Solution

by:giltjr
giltjr earned 150 total points
ID: 34997603
Another issue with the EBCDIC vs. ASCII is sort order.  If a field/column contains alphanumeric data the sort order will could be different.  In ASCII numbers are lower in value (that is 1 would come before A if sorting in ascending order) in EBCDIC numbers are higher in value (that is 1 would come AFTER A if sorting in ascending order).

If you have large tables on the z/OS side you need to make sure you plan according on the AIX side.  z/OS handles files much differently than AIX.  I am fairly sure you can get better I/O performance on z/OS in some cases when compaired to AIX for very large table spaces.
0
 

Author Closing Comment

by:Okonita001
ID: 35046040
Both discussion were very correct but not complete and missing examples or references as I would expect  for a question that depends on experience.
0
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 
LVL 57

Expert Comment

by:giltjr
ID: 35046279
I actually looked around and there are no references or examples.  This type of migration is not done alot.  I would suggest that you talk to IBM about getting somebody to help you.

I know we tested with DB2 on a distributed platform (I can't remember if it was Windows or Linux) and performance was less than desirable.  The process normally takes 1 hour on z/OS and the "distributed" people originally stated that with the processing power they had the process should take less 30 minutes and in a worse case situation it make take equal to that.

After about 6 hours and the process was less than half way done the test was stopped.
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 35046288
Hi giltjr,

I was also surprised by the lack of examples.

You moved from a Z/OS system to LUW?  If your tests suggest that LUW was taking about 10 times longer, it wasn't DB2, per se.  There was a configuration issue, memory management, I/O paths, or some other peripheral element that was responsible for the degradation.


Kent
0
 
LVL 57

Expert Comment

by:giltjr
ID: 35046866
Not too many companies migrate DB2 from z/OS to distributed platforms.  If they are migrating off of z/OS, they typically will go to a "cheaper" DBMS, like MySQL or PostgreSQL, or to DBMS that are considered better in the distributed world like Oracle.

The biggest issue was I/O.

The distributed team severely underestimated the I/O capability of our mainframe and severely overestimated the I/O capabilities of their SAN.   They did not really understand the native multipath support that mainframe environment has has for decades and what the lack of such support would do on the distributed side.  

They also over estimated the "advantage" of having more RAM and more faster CPU's.  The mainframe at that time only has 10GB and they out 64GB on the distributed server.    We had 5 CPU's rated at about 900Mhz vs. their 8 rated close to 3.0 Ghz.

0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 35046933

There's always something to learn, huh?

Sorry that your lesson was so expensive.


Kent
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question