Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
29 replies Latest Post - ‏2012-05-17T21:54:07Z by SystemAdmin
rfchong
rfchong
484 Posts
ACCEPTED ANSWER

Pinned topic FREE online DB2 Express-C book

‏2007-11-19T14:48:50Z |

Hello everyone!

If you've attended any of my speeches or courses/workshops as part of the DB2 on Campus program, I'd like to let you know that we've recently released a new FREE book about DB2 Express-C 9 based on the materials from these speeches/courses. The book also comes with a downloadable file you can use to work on the exercises/labs that come with the book.

To download the book go to the home page of DB2 Express-C:
www.ibm.com/db2/express

From there, there is a link on the right side that says:
FREE Book: Getting Started with DB2 Express-C

The book is for DB2 9, but we are working to update it to DB2 9.5 soon, and we are planning to add more application development topics too. This book is a good start for people who are new to DB2, and it provides you with some hands-on exercises.

I'm also looking for volunteers to translate this book to your own language! If you are interested, please let me know by replying to this post.
Please help us promote this FREE book!

Cheers!

Raul F. Chong
DB2 on Campus Program Manager
Email: mailto:db2x@ca.ibm.com
Updated on 2012-05-17T21:54:07Z at 2012-05-17T21:54:07Z by SystemAdmin
  • Leo_52
    Leo_52
    69 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2007-11-20T11:34:39Z  in response to rfchong
    Hello Raul,

    I am prepared to translate your book into German. I have acted as IT instructor with the Royal Air Force (United Kingdom) in the past, instructing officers, squadrons and civil personnel. Since I am a native German speaker and IT specialist the translation will conform to the high IBM standards.

    The zip file containing the samples seems to be corrupt!

    With no further news, I remain,

    Yours
    Leo
    • rfchong
      rfchong
      484 Posts
      ACCEPTED ANSWER

      Re: FREE online DB2 Express-C 9 book

      ‏2007-11-20T21:31:35Z  in response to Leo_52

      Hello Leo,

      That's great!. Once I'm done with the update to DB2 9.5 by the end of December, I'll contact you again.
      So far I have 2 volunteers for Spanish, 1 for Portuguese, 2 for Chinese, 1 for Bulgarian, 1 for Vietnamese, and 1 for German (you)

      I just tried downloading the file coming with the book, and I see the corruption problem. I will notify the person who uploaded it to fix it. Thanks for letting us know.

      Cheers!

      Raul F. Chong
      IBM DB2 Express Community Facilitator
      Email: db2x@ca.ibm.com
      • igorM
        igorM
        265 Posts
        ACCEPTED ANSWER

        Re: FREE online DB2 Express-C 9 book

        ‏2007-12-04T14:12:22Z  in response to rfchong
        Hi,
        first of all excellent book!

        On page 25 (2.3.1 character DB2 Connect) there is a picture for "System z". Just to note on System z there are 4 operating systems available that can DB2 be installed on:
        • z/OS,
        • VSE,
        • VM and
        • zLinux.

        DB2 for VSE and DB2 for VM are actually one product DB2 for VM/VSE something like DB2 for Linux, Unix, Windows (DB2 LUW)

        About connect: Connect is required to connect from DB2 LUW to DB2 on:
        • z/OS,
        • VSE,
        • VM,
        but NOT! for zLinux.

        In our company we use DB2 LUW on Intel/Windows and also DB2 for VSE on System z and DB2 for zLinux on System z.

        Just pointing this out that there are more than one operating system on System z, just to get the whole DB2 Connect picture.

        Hope this helps,
        IgorM
      • rfchong
        rfchong
        484 Posts
        ACCEPTED ANSWER

        Re: FREE online DB2 Express-C 9 book

        ‏2008-02-04T17:38:57Z  in response to rfchong
        Hi Leo,

        We had some hurdles to overcome to start working on the translation, but we have now passed them. Are you still available to work on the translation to German? If so, please send me a note to db2x@ca.ibm.com.

        Thanks!

        Raul F. Chong
        IBM DB2 Express Community Facilitator
        Email: db2x@ca.ibm.com
  • rfchong
    rfchong
    484 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2008-04-18T22:03:01Z  in response to rfchong
    The book "Getting Started with DB2 Express-C" has been updated to 9.5. You can get this new version here.

    As you saw from this forum thread, the book is also being translated by the community to several languages!. By mid-May, we should have translations ready for these languages:

    • Portuguese (Brazil)
    • Vietnamese
    • German
    • Simplified Chinese

    Translation to other languages such as Spanish, Italian, and Bulgarian are on the works. If you would like to participate, please reply to this post. We'll try to do our best to recognize your efforts!

    The contents of the book match closely to the video presentations in http://www.channelDB2.com/oncampus. The lab exercises are also the same.

    Cheers,

    Raul F. Chong
    IBM DB2 Express Community Facilitator
    Email: db2x@ca.ibm.com
    • rfchong
      rfchong
      484 Posts
      ACCEPTED ANSWER

      Re: FREE online DB2 Express-C 9 book

      ‏2008-05-27T03:48:05Z  in response to rfchong
      Hello,

      The translated versions of the book are being stored in the same page as the English version here.

      Cheers,

      Raul F. Chong
      IBM DB2 Express Community Facilitator
      Email: db2x@ca.ibm.com
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2008-07-07T10:43:00Z  in response to rfchong
    Hello, Raul!

    I am ready to translate the book into Russian.
    • rfchong
      rfchong
      484 Posts
      ACCEPTED ANSWER

      Re: FREE online DB2 Express-C 9 book

      ‏2008-07-15T04:49:06Z  in response to SystemAdmin
      Hi there,

      A translation to Russian would be fantastic!. Please send me a note to db2x@ca.ibm.com, and we can coordinate the work.

      Thanks for volunteering!

      Raul F. Chong
      DB2 on Campus Program Manager
      Email: db2x@ca.ibm.com
  • rfchong
    rfchong
    484 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2009-02-12T05:13:42Z  in response to rfchong
    Update:

    As of Feb 12th, 2009, the following translations are available at this link:

    English
    Portuguese (Brazil)
    Simplified Chinese
    Vietnamese
    German
    Polish
    Italian
    Spanish

    We are constantly looking for volunteers to translate the book, so please send as a note to db2x@ca.ibm.com if interested!

    Some other translations still ongoing are: Indonesia Bahasa, Thai, Bulgarian, Russian.

    Cheers,

    Raul F. Chong
    DB2 on Campus Program Manager
    Email: db2x@ca.ibm.com
  • rfchong
    rfchong
    484 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2009-03-18T17:36:47Z  in response to rfchong
    March 18th update:

    The Portuguese (Portugal) translation is available! at the same location as the other books.

    Other translations almost done: Japanese, Turkish, Thai, Indonesia Bahasa.

    Cheers,

    Raul F. Chong
    DB2 on Campus Program Manager
    Email: db2x@ca.ibm.com
    • rfchong
      rfchong
      484 Posts
      ACCEPTED ANSWER

      Re: FREE online DB2 Express-C 9 book

      ‏2009-10-12T22:33:09Z  in response to rfchong
      Oct 12th update:

      The Thai translation is available! at the same location as the other books.

      Cheers,

      Raul F. Chong
      DB2 on Campus Program Manager
      Email: db2x@ca.ibm.com
      • sutivnn
        sutivnn
        1 Post
        ACCEPTED ANSWER

        Re: FREE online DB2 Express-C 9 book

        ‏2011-03-11T07:06:30Z  in response to rfchong
        first of all excellent book!

        On page 25 (2.3.1 character DB2 Connect) there is a picture for "System z". Just to note on System z there are 4 operating systems available that can DB2 be installed on:

        * z/OS,
        * VSE,
        * VM and
        * zLinux.
        DB2 for VSE and DB2 for VM are actually one product DB2 for VM/VSE something like DB2 for Linux, Unix, Windows (DB2 LUW)

        About connect: Connect is required to connect from DB2 LUW to DB2 on:

        * z/OS,
        * VSE,
        * VM,

        but NOT! for zLinux.

        In our company we use DB2 LUW on Intel/Windows and also nội thất fami[/URL] nội thất 190[/URL], DB2 for VSE on System z and DB2 for zLinux on System z.

        Just pointing this out that there are more than one operating system on System z, just to get the whole DB2 Connect picture.

        Hope this helps,
  • rfchong
    rfchong
    484 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2009-07-06T15:24:48Z  in response to rfchong
    The third edition of the "Getting Started with DB2 Express-C" book has been updated to 9.7 and is available at this link.

    Tell us what you think about the book, and how we can improve it! We would like to collect as much feedback from the community as possible, and fix any typos, unclear sentences, incorrect examples, etc, by September, and publish again with the corrections made.

    Happy reading!

    Raul F. Chong
    DB2 on Campus Program Manager
    Email: db2x@ca.ibm.com
    • BlackMagic
      BlackMagic
      1 Post
      ACCEPTED ANSWER

      Re: FREE online DB2 Express-C 9 book

      ‏2010-08-07T13:05:09Z  in response to rfchong
      Hi Raul,

      Some time ago I downloaded DB2 Express 9.7 and after a few false starts managed to get it installed and running on my Linux box (Centos 5.5). Trying to get a connection to the database is another story though, one I haven't reached the end of yet.

      I downloaded your excellent book hoping it would solve the problem, but alas no. Here is the problem: for security reasons I don't want any GUI software on the server. All the literature I've read, including the 'Getting Started' book, assumes a GUI is available. At least that's the impression I've taken from skimming through the book looking for a way to connect to the database.

      For example, I've got PostgreSQL running on the same Linux server, and I can administer it using the open source utility phpPgAdmin that's installed on the server but accessible via HTTP on a client Windows PC. Is there anything comparable available for DB2 Express 9.7, or how does one remotely administer DB2 running on a server that doesn't have a GUI installed?

      Perhaps this topic could be covered in the next version of 'Getting Started'.

      Regards,

      MJR
      • rfchong
        rfchong
        484 Posts
        ACCEPTED ANSWER

        Re: FREE online DB2 Express-C 9 book

        ‏2010-08-31T18:25:42Z  in response to BlackMagic
        Hi MJR,

        You can install DB2 on a server without including the GUI tools. Then from a client you can remotely administer it using GUI tools. On the server, the "DAS" (DB2 Administration Server) must be running in order for you to administer remotely with GUI tools.

        If you don't want GUI at all (not even in your client), you can use the "attach" command from the client to perform instance-level operations, and "connect to" statements to connect to the database and perform database-level operations.

        Moreover we recently released "lite" images of DB2 Express-C that do not include the GUI tools.

        Hope this helps,

        Raul F. Chong
        DB2 on Campus Program Manager
        Email: db2x@ca.ibm.com
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2009-08-12T07:34:05Z  in response to rfchong
    that is very good,i get it !
  • rfchong
    rfchong
    484 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2010-04-16T18:04:30Z  in response to rfchong
    Update April 16th, 2010:

    The Japanese translation of the book (for the 3rd Edition) is now available at the same location!

    Raul F. Chong
    DB2 on Campus Program Manager
    Email: db2x@ca.ibm.com
  • rfchong
    rfchong
    484 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2010-04-19T17:39:19Z  in response to rfchong
    Hi All,

    Thanks to volunteers in Bulgaria we now have a Bulgarian translation for the book "Getting started with DB2 Express-C". Get it here!

    Cheers,

    Raul F. Chong
    DB2 on Campus Program Manager
    Email: db2x@ca.ibm.com
  • rfchong
    rfchong
    484 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2010-08-31T18:29:20Z  in response to rfchong
    Hi All,

    The Vietnamese version of the free eBook has been updated to 9.7. Check it out:

    https://www.ibm.com/developerworks/wikis/display/DB2/FREE+Book-+Getting+Started+with+DB2+Express-C

    Cheers,

    Raul F. Chong
    DB2 on Campus Program Manager
    Email: db2x@ca.ibm.com
    • SystemAdmin
      SystemAdmin
      5837 Posts
      ACCEPTED ANSWER

      Re: FREE online DB2 Express-C 9 book

      ‏2010-11-17T14:51:43Z  in response to rfchong
      Hello Raul.

      I have been working on DB2 for in both windows and Linux(Ubuntu) environment.
      I would like to know if there is any DB2 Express-C book, available for Linux users.
      • rfchong
        rfchong
        484 Posts
        ACCEPTED ANSWER

        Re: FREE online DB2 Express-C 9 book

        ‏2010-12-14T21:49:58Z  in response to SystemAdmin
        Hello,

        Maybe this paper is useful (Ubuntu Linux specific):
        https://www.ibm.com/developerworks/wikis/display/DB2/DB2+and+Ubuntu+whitepaper

        Cheers,

        Raul F. Chong
        DB2 on Campus Program Manager
        Email: db2x@ca.ibm.com
  • elsken
    elsken
    2 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2010-12-01T17:04:11Z  in response to rfchong
    Thanks for the info!
  • Marianne.Cross
    Marianne.Cross
    1 Post
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2010-12-30T02:04:20Z  in response to rfchong
    Prabhakar_Bikka... wrote:

    I don't think it's a must, I think you're wrong.
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2011-01-10T01:35:39Z  in response to rfchong
    igorM wrote:
    Hi,
    first of all excellent book!

    On page 25 (2.3.1 character DB2 Connect) there is a picture for "System z". Just to note on System z there are 4 operating systems available that can DB2 be installed on:
    • z/OS,
    • VSE,
    • VM and
    • zLinux.

    DB2 for VSE and DB2 for VM are actually one product DB2 for VM/VSE something like DB2 for Linux, Unix, Windows (DB2 LUW)

    About connect: Connect is required to connect from DB2 LUW to DB2 on:
    • z/OS,
    • VSE,
    • VM,
    but NOT! for zLinux.

    In our company we use DB2 LUW on Intel/Windows and also DB2 for VSE on System z and DB2 for zLinux on System z.

    Just pointing this out that there are more than one operating system on System z, just to get the whole DB2 Connect picture.

    Hope this helps,
    IgorM

    This is what I'm looking for, It's quite useful, Thanks for your effort!
    • rfchong
      rfchong
      484 Posts
      ACCEPTED ANSWER

      Re: FREE online DB2 Express-C 9 book

      ‏2011-01-21T23:08:24Z  in response to SystemAdmin
      Hi All,

      The German translation of the "Getting started with DB2 Express-C 9.7" free eBook is now available! This replaces the previous version we had which was for DB2 Express-C 9.5. A special thanks to Leo Elsenberg (from the community) for translating both editions of this book to German!

      Cheers,

      Raul F. Chong
      DB2 on Campus Program Manager
      Email: db2x@ca.ibm.com
  • PoojaIndia
    PoojaIndia
    1 Post
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2011-03-06T08:41:53Z  in response to rfchong
    Free books on C,C++,Java are available at booksplanet.org
  • rfchong
    rfchong
    484 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C 9 book

    ‏2011-04-01T19:34:20Z  in response to rfchong
    Hello,

    The Czech version of this book is now available!. Same location as the other translations.

    Enjoy!

    Raul F. Chong
    DB2 Program Manager and technical evangelist
    Email: db2x at ca.ibm.com
    Check out: db2university.com
    • rfchong
      rfchong
      484 Posts
      ACCEPTED ANSWER

      Re: FREE online DB2 Express-C 9 book

      ‏2011-09-15T15:32:33Z  in response to rfchong
      Hello,

      New translation of the DB2 Express-C 9.7 book into Brazilian Portuguese and Russian are now live:
      https://www.ibm.com/developerworks/wikis/display/DB2/FREE+Book-+Getting+Started+with+DB2+Express-C

      We now have the book (3rd edition) translated into Chinese, Czech, German, Japanese, Portuguese (Brazil), Russian, Spanish and Vietnamese!. For the 2nd edition, it is translated to Bulgarian, Italian, Polish, Portuguese (Portugal), and Thai!

      Enjoy!

      Raul F. Chong
      DB2 Program Manager and technical evangelist
      Email: db2x at ca.ibm.com
      Check out: db2university.com
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: FREE online DB2 Express-C book

    ‏2012-05-17T21:54:07Z  in response to rfchong
    Is someone updating this nice book for 10.1?

    Regards.