Search390.com Expert Question of the Week September 10, 2001 ===================================== SPONSORED BY: Storage Decisions 2001 ===================================== TIME IS RUNNING OUT to qualify to attend the FREE Storage Decisions 2001 conference in Chicago September 26-28. Learn to set strategy/make the smartest decisions to most effectively manage your storage initiatives for 2002. Pre-qualified audience of your peers and NO vendor sales pitches. Don't get shut out at this critical event. Visit http://ad.doubleclick.net/clk;3177034;5058249;j?http://www.StorageDecisions2001.com today! ===================================== ===================================== FEATURED TOPIC: NetRexx ===================================== This popular human-oriented programming language makes writing and using Java classes quicker and easier than writing in Java, thus making it the language of choice for many. To learn more, check out our collection of links below. http://search390.techtarget.com/featuredTopic/0,290042,sid10_gci768370,00.html -------------------------------------------------------------------- Welcome to Search390's Expert Question of the Week newsletter. Remember, no question is too simple for Ask the Experts! If you have a 390-related question, send it to [EMAIL PROTECTED] Selected questions will be answered by our experts. This week's question was answered by Tom Moulder, search390's Database Management Expert. THIS WEEK'S QUESTION: Q: Can you please point me to where I can find information on how to move databases from one DB2 engine to another? Our situation is that we have an OS/390 2.4 system with DB2510 on one partition. We have an OS/390 2.9 system on another partition with DB2512 on another partition. I would like to know how to migrate the databases from the old DB2 engine to the other when they are on separate partitions. A: Here are places to look at in the DB2 manuals: In the Administration Guide look at Section 2.11 under the topic moving DB2 data. This assumes that you have the DDL that created the structure and simply want to move data to populate the new objects. If you do not have the original DDL, there are a number of tools that will read the catalog and generate this DDL for you. The Control Center comes to mind. What you did not say is whether the DASD is shared between the two LPARs. The task is easier if the DASD is shared. Here is a simple list of the items that must be taken into consideration when you attempt to migrate a DB2 application: 1. The DDL for the source objects mujst be available in some file or there must be a method to generate the DDL for re-creating the objects that you want to migrate. 2. There must be a method of moving the data. Look at the Administration Guide for the no-cost options that come with DB2. 3. There must be a method to move the applications that access this data. Hopefully the DBRMLIB is shared, otherwise you will need to copy this library so that it can be used in the compile and bind process on the target system. All of the plans and packages for the source system should be bound on the target system. 4. Finally, be sure to account for stored procedures if you have begun using them. I hope this helps. Feel free to ask further questions as you look into this project. I have greatly simplified this process in this answer. Also, you should know that BMC, CA, Candle and IBM all have for-cost products that will automate this process. Based on the number of times that this process must be repeated, you might want to investigate these offerings to determine if they are cost justified. ------------------------------------------------------------ Do you have a question for Tom Moulder? If so, submit it here: http://search390.techtarget.com/ateQuestion/0,289624,sid10_tax286336,00.html ============================================================ HAVE A GREAT TIP OF YOUR OWN? ============================================================ Want to win a cool Olympus Stylus Epic Zoom camera? If you answered yes to either of those questions, then you must send us your tip and enter out Tip of the Month contest for September! If your tip is chosen as the winner by search390's registered users and panel of experts, you could take home the prize. To learn more about the contest rules and prize, or to submit your tip today, go to: http://search390.techtarget.com/tipsPrize/0,289492,sid10_prz764545_cts764532,00.html ======================================================== If you would like to sponsor this or any TechTarget newsletter, please contact Tim Keough at [EMAIL PROTECTED] ======================================================== If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://search390.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
