Lesson 0 Transcript: Getting Started
Slide 1: Cover Welcome to the presentation, “Getting Started with the DB2 on Campus lecture series.” This is a presentation that explains how you can take the most advantage out of this e-learning lecture series. My name is Raul Chong, and I'm the DB2 on Campus Program Manager.
Slide 2: Agenda (1) This is the agenda for today. Now we'll start talking about the software material that is required for these e-learning courses.
Slide 3: Getting started So first of all, we recommend that you download DB2 Express-C 9.5, this is the latest version of DB2. Then download IBM Data Studio 1.1, which will be used mainly for the development of stored procedures, user defined functions, and maybe we'll do, as well, some Web Services. You can download and unzip them in any directory that you wish, the structure that we have is basically downloading them into a directory called db2-workshop and in there we have another directory called install-images, and we download it there.
Now you can download this software for free from www.ibm.com/db2/express and click on the Downloads tab. From there you can choose the image that you would like to use, either if it’s on the Windows platform, or on the Linux platform, or if it's 32-bit or 64-bit. Now once you download and unzip these files. Do not install them because we will install them in another lesson of these e-learning courses. The next thing you should download is the book and exercises, which are also provided from the DB2 Express-C web site. The title of the book is "Getting Started with DB2 Express-C". It is a free online book, and pretty much most of the material in this book has been used for these e-learning courses. The exercises are separate files that can be found in the same web site as the book, so download and unzip the book from the main DB2 Express-C web site, which has a link to where this book resides.
Slide 4: DB2 UDB versus DB2 Moving on to the next slide, we are comparing the terms DB2 UDB versus DB2. Well the reason I decided to put this slide in is that many people who are new to DB2, they may go to Google or any other search engine and type DB2; once they do this, and click on search, they may find different hits on DB2 and some of them may say DB2 UDB. UDB used to be part of the name before DB2 Version 9. UDB stands for "Universal Database"
Starting with Version 9 we decided to simply the name and we decided to remove UDB from the product name. So, basically, what I'm trying to say here is that DB2 UDB and DB2 are exactly the same product, where DB2 UDB was used before Version 9. If you go to Google again and you type DB2, you may also find a term like Viper or Viper 2. What happens is that what we do here (at the Toronto Lab) when we develop a product is that we first use a code name, and once we officially announce it to the public, or we make it generally available, we give it a name, another name, an official name, so in this case Viper was a code name and once we officially announced the product, we call it DB2 9. The same thing with DB2 9.5, the code name was Viper 2 and once we officially announced DB2 9.5, we called it DB2 9.5. DB2 9.5 by the way is the latest version of DB2, and I think I mentioned that earlier as well. Now again, the purpose of this slide was basically try to clarify things in terms of terminology, in terms of the name of a product, just in case if you start to do research on your