SunQuest
           DB2 Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > DB2 Development
Reload this Page

DB2: Book suggestions?

Discuss DB2: Book suggestions? in the DB2 Development forum on Dev Shed.
DB2: Book suggestions? DB2 Development forum discussing administration, DB2 queries, SQL/PL, and other DB2-related topics. Covers the entire DB2 line, including UDB (DB2 for Unix and Linux), midrange (AS/400) and mainframe versions.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Page 1 of 2 1 2 >
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old May 18th, 2004, 01:36 PM
drgroove's Avatar
drgroove drgroove is offline
pushing envelopes, not pencils
Dev Shed God 2nd Plane (6000 - 6499 posts)
  
Join Date: Feb 2002
Posts: 6,224 drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 1 Day 4 h 34 m 57 sec
Reputation Power: 174
DB2: Book suggestions?
I'm looking for suggestions on a good DB2 book; something w/ a great reference section, but also w/ some tutorials on the various functions etc.
__________________
Give a person code, and they'll hack for a day; Teach them how to code, and they'll hack forever.
Analyze twice; hack once.
The world's first existential ITIL question: If a change is released into production without a ticket to track it,
was it actually released?

About DrGroove: ITIL-Certified IT Process Engineer - Enterprise Application Architect -
Freelance IT Journalist - Devshed Moderator - Funk Bassist Extraordinaire
Reply With Quote
  #2  
Old May 24th, 2004, 01:05 PM
dcaillouet's Avatar
dcaillouet dcaillouet is offline
Big Endian
Dev Shed Beginner (1000 - 1499 posts)
  
Join Date: May 2001
Location: Fly-over country
Posts: 1,173 dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 16 h 29 m 5 sec
Reputation Power: 24
These are the five books that I used for DB2 mainly because they fit the type of development I was doing. They may or may not be what you're looking for:

This book is great if you're going to be using stored procedures. It's all the book discusses.

DB2 SQL Procedural Language for Linux, Unix and Windows

While this is a certification guide, it is still a pretty good reference for a DBA. I got it for free so I can't be too critical.

DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide (5th Edition)

The following three books are some of my favorites because they talk specifically about accessing DB2 using C++. They cover CLI (Call Level Interface), embedded SQL and API calls. Tons of examples and all the source code included on CD's. They are several years old, but I used the examples verbatim to access UDB 8.1 with no problems. These aren't for everyone, but I found them to be invaluable.

DB2 Universal Database Call-Level Interface (Cli) Developer's Guide

DB2 Universal Database SQL Developer's Guide

DB2 Universal Development Guide
Reply With Quote
  #3  
Old May 24th, 2004, 03:10 PM
drgroove's Avatar
drgroove drgroove is offline
pushing envelopes, not pencils
Dev Shed God 2nd Plane (6000 - 6499 posts)
  
Join Date: Feb 2002
Posts: 6,224 drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 1 Day 4 h 34 m 57 sec
Reputation Power: 174
wow DC, thanks for the great refs. Had no idea you were such a DB2 stud lol

we're doing the whole IBM thing here - db2, wsad, was, j2ee yada yada.
Reply With Quote
  #4  
Old May 24th, 2004, 10:47 PM
dcaillouet's Avatar
dcaillouet dcaillouet is offline
Big Endian
Dev Shed Beginner (1000 - 1499 posts)
  
Join Date: May 2001
Location: Fly-over country
Posts: 1,173 dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 16 h 29 m 5 sec
Reputation Power: 24
The bad news is that reading IBM documentation has been proven to cause narcolepsy. The good news is that there are other resources that aren't quite as painful:

IBM developerWorks
WebSphere TechJournal
WebSphere Developer Domain
developerWorks DB2 Library
Reply With Quote
  #5  
Old May 25th, 2004, 08:22 AM
drgroove's Avatar
drgroove drgroove is offline
pushing envelopes, not pencils
Dev Shed God 2nd Plane (6000 - 6499 posts)
  
Join Date: Feb 2002
Posts: 6,224 drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 1 Day 4 h 34 m 57 sec
Reputation Power: 174
Quote:
Originally Posted by dcaillouet
The bad news is that reading IBM documentation has been proven to cause narcolepsy.


lmao
Reply With Quote
  #6  
Old May 27th, 2004, 04:03 PM
Onslaught's Avatar
Onslaught Onslaught is offline
/(bb|[^b]{2})/
Dev Shed Demi-God (4500 - 4999 posts)
  
Join Date: Nov 2001
Location: Somewhere in the great unknown
Posts: 4,834 Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 1 Day 23 h 30 m 30 sec
Reputation Power: 88
Send a message via ICQ to Onslaught
drgroove, did you install the ibm documentation when you installed the db2 odbc driver? I like the IBM Information center FWIW.
Reply With Quote
  #7  
Old May 27th, 2004, 04:25 PM
drgroove's Avatar
drgroove drgroove is offline
pushing envelopes, not pencils
Dev Shed God 2nd Plane (6000 - 6499 posts)
  
Join Date: Feb 2002
Posts: 6,224 drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 1 Day 4 h 34 m 57 sec
Reputation Power: 174
Quote:
Originally Posted by Onslaught
drgroove, did you install the ibm documentation when you installed the db2 odbc driver? I like the IBM Information center FWIW.


our DB2 is running on a remote solaris box; i don't have it running locally.

is there a version of the doc separate from the install?
Reply With Quote
  #8  
Old May 27th, 2004, 07:52 PM
Onslaught's Avatar
Onslaught Onslaught is offline
/(bb|[^b]{2})/
Dev Shed Demi-God (4500 - 4999 posts)
  
Join Date: Nov 2001
Location: Somewhere in the great unknown
Posts: 4,834 Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 1 Day 23 h 30 m 30 sec
Reputation Power: 88
Send a message via ICQ to Onslaught
You should be able to install the documentation with the administration client and probably just the odbc driver not the database itself.
I'll see if I can find a seperate installation of the information center for you.
Reply With Quote
  #9  
Old May 27th, 2004, 08:18 PM
Nemi Nemi is offline
Clueless llama
Dev Shed Regular (2000 - 2499 posts)
  
Join Date: Feb 2001
Location: Lincoln, NE. USA
Posts: 2,353 Nemi User rank is First Lieutenant (10000 - 20000 Reputation Level)Nemi User rank is First Lieutenant (10000 - 20000 Reputation Level)Nemi User rank is First Lieutenant (10000 - 20000 Reputation Level)Nemi User rank is First Lieutenant (10000 - 20000 Reputation Level)Nemi User rank is First Lieutenant (10000 - 20000 Reputation Level)Nemi User rank is First Lieutenant (10000 - 20000 Reputation Level)Nemi User rank is First Lieutenant (10000 - 20000 Reputation Level)Nemi User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 2 Days 12 h 35 m 19 sec
Reputation Power: 111
It's nice to see so many here doing development with IBM, DB2, WSAD and WAS. This is what I use at work also.
__________________
~Nemi

Before posting did you try:
[ Javadocs | Google ]
Reply With Quote
  #10  
Old May 27th, 2004, 08:52 PM
drgroove's Avatar
drgroove drgroove is offline
pushing envelopes, not pencils
Dev Shed God 2nd Plane (6000 - 6499 posts)
  
Join Date: Feb 2002
Posts: 6,224 drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 1 Day 4 h 34 m 57 sec
Reputation Power: 174
Quote:
Originally Posted by Nemi
It's nice to see so many here doing development with IBM, DB2, WSAD and WAS. This is what I use at work also.


I've only been working under this architecture briefly, but yeah, I'm all-IBM at the moment. Definitely good to know there's other DSer's out there who are ibm-homogenized.
Reply With Quote
  #11  
Old May 27th, 2004, 08:52 PM
drgroove's Avatar
drgroove drgroove is offline
pushing envelopes, not pencils
Dev Shed God 2nd Plane (6000 - 6499 posts)
  
Join Date: Feb 2002
Posts: 6,224 drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level)drgroove User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 1 Day 4 h 34 m 57 sec
Reputation Power: 174
Quote:
Originally Posted by Onslaught
You should be able to install the documentation with the administration client and probably just the odbc driver not the database itself.
I'll see if I can find a seperate installation of the information center for you.


rockin'
Reply With Quote
  #12  
Old May 28th, 2004, 08:36 AM
Onslaught's Avatar
Onslaught Onslaught is offline
/(bb|[^b]{2})/
Dev Shed Demi-God (4500 - 4999 posts)
  
Join Date: Nov 2001
Location: Somewhere in the great unknown
Posts: 4,834 Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level)Onslaught User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 1 Day 23 h 30 m 30 sec
Reputation Power: 88
Send a message via ICQ to Onslaught
Here is a link in IBM's site where you can download the information center for the appropriate version of DB2 that you are running.

You can find out which version by either a: opening up a db2 command window and typing db2
you will get something like this:
Code:
C:\Program Files\SQLLIB\bin>db2
(c) Copyright IBM Corporation 1993,2001
Command Line Processor for DB2 SDK 7.2.8

You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd
plus more, but the relevant part is in bold.
or b: you can connect to a database
Code:
C:\Program Files\SQLLIB\bin>db2 connect to myserver user me
Enter current password for me:

   Database Connection Information

 Database server        = DB2/LINUX 7.2.8
 SQL authorization ID   = ME
 Local database alias   = MYSERVER
I can have an iso of the admin client if you need it for windows (or just about any other os) but it is large. Let me know if you want to download that and we'll set something up. The iso is for 7.1. You will have to download the appropriate patches to get it to something higher.
Reply With Quote
  #13  
Old May 28th, 2004, 11:34 PM
fractalvibes fractalvibes is offline
Contributing User
Dev Shed Novice (500 - 999 posts)
  
Join Date: Jun 2003
Location: Waco, Texas
Posts: 632 fractalvibes User rank is Sergeant (500 - 2000 Reputation Level)fractalvibes User rank is Sergeant (500 - 2000 Reputation Level)fractalvibes User rank is Sergeant (500 - 2000 Reputation Level)fractalvibes User rank is Sergeant (500 - 2000 Reputation Level)fractalvibes User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 1 Week 14 h 11 m 13 sec
Reputation Power: 22
Wow - how long has this DB2 forum been here??? Did I overlook for so long?

I have been using DB2 for almost 10 years, currently use via ASP and ASP.NET to access both DB2 on Z/OS and UDB on Win 200X. Powerfull stuff. A few 'gotchas' with ADO early on.
Have not tried any PHP/DB2 as of yet.

Some good resources mentioned so far - I would add:
http://www.idug.org/html/home.asp
and
http://groups.google.com/groups?hl=...tabases.ibm-db2

The first is the International DB2 Users Group and the second
has a number of IBM folks responding to questions.

Stinger will be the next release of DB2 for Unix/Linux/Windows,
and promises even tighter integration with the .NET platform.

fv
__________________
...because that is the way we have always done it. We've been doing it like that for 80 Years! (How do we change that mindset?)
Reply With Quote
  #14  
Old May 28th, 2004, 11:48 PM