Pinned topicFREE online DB2 Express-C book

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

Answered question
This question has been answered.

Unanswered question
This question has not been answered yet.

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.

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!

Re: FREE online DB2 Express-C 9 book

‏2007-11-20T11:34:39Z

This is the accepted answer.
This is the accepted answer.

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.

Re: FREE online DB2 Express-C 9 book

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.

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.

Re: FREE online DB2 Express-C 9 book

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.

Re: FREE online DB2 Express-C 9 book

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.

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.

Re: FREE online DB2 Express-C 9 book

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!

Re: FREE online DB2 Express-C 9 book

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!

Re: FREE online DB2 Express-C 9 book

‏2009-07-06T15:24:48Z

This is the accepted answer.
This is the accepted answer.

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.

Re: FREE online DB2 Express-C 9 book

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.

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'.

Re: FREE online DB2 Express-C 9 book

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'.

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.

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!