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 Resources

Discuss DB2 Resources in the DB2 Development forum on Dev Shed.
DB2 Resources 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 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old May 27th, 2004, 02:57 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 Resources
Here are some online resources I've found for DB2 documentation and issues:

DB2 SQL Reference
https://aurora.vcu.edu/db2help/db2s0/frm3toc.htm

IBM DB2 Ref
http://www-106.ibm.com/developerwor...0206sqlref.html

If you have any good online resources, please post them to this thread, thanks!

- DrGroove
__________________
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 27th, 2004, 03:52 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
DB2 Redbooks from IBM are an excellent way to get info on IBM tech

http://publib-b.boulder.ibm.com/cgi...archFuzzy=FALSE
__________________
~Nemi

Before posting did you try:
[ Javadocs | Google ]
Last edited by Nemi : May 27th, 2004 at 04:08 PM.
Reply With Quote
  #3  
Old May 27th, 2004, 04:06 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
Reply With Quote
  #4  
Old May 28th, 2004, 04:39 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
Quest Software has some freeware utilities and versions of their commercial software:

Quest Central for DB2

SpotlightŪ on WebSphere
Reply With Quote
  #5  
Old May 28th, 2004, 04:49 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 dcaillouet
Quest Software has some freeware utilities and versions of their commercial software:

Quest Central for DB2

SpotlightŪ on WebSphere


Is Quest's DB2 tool any better than TOAD (which, IMHO, has one of the worst UI of any RDBMS tool I've ever used...) - or, is it basically a TOAD port for DB2? Just curious...
Reply With Quote
  #6  
Old May 28th, 2004, 08:37 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
Just curious, but why even use TOAD or Quest's DB2 tool over IBM's Administration interface?
Reply With Quote
  #7  
Old June 3rd, 2004, 01:07 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
more resources
The DB2 Book Suggestions thread also contains valuable links to books, various informational sites, etc.
Reply With Quote
  #8  
Old June 3rd, 2004, 10:08 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
Quote:
Originally Posted by Onslaught
Just curious, but why even use TOAD or Quest's DB2 tool over IBM's Administration interface?


Well, I have used Platinum, BMC, and Quest as an interface to the DB. All were superior to what is now DB2's control center, simply easier to use, period. Quest is our latest tool, and seems very satisfactory (well it lacks some things re:
getting to functions and stored procedures...) Quest does seem 10 times faster than the DB2 admin tool - perhaps it is because the DB2 tool is Java/JDBC - based? Many times it has caused a reboot - memory leakage?

For just running a bunch of queries against the database
on the fly - the free version of WinSQL is my tool of choice.
Very light footprint and quick.

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
  #9  
Old June 4th, 2004, 08:29 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
Don't get me wrong, I'm not downing any custom tool out there. I personally have one that I built on my own to interact with my database, but then my reasoning was because I deal with more than just DB2 and this application allows me to interact with DB2, MSSQL, and MySQL at the same time.
I will agree that it isn't as fast as a C/C++ or other compiled appliction because it is done in java. Though, I will have to say that you can access store procedures and functions via the control center.
Attached Images
File Type: jpg db2cc.jpg (79.4 KB, 485 views)
Reply With Quote
  #10  
Old June 4th, 2004, 08:41 AM
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
The control center has been quite usefull for building/debugging PSQL stored procs - the source-level deugger is a very valuable tool. With version 8 (UDB/NT)
it has changed totally - now called the Development Center with a totally different interface that I have not explored much. Also it seems integrated into Visual Studio.NET. Next release (code-named Stinger) we will be able to write stored procs in VB.NET...interesting!

fv
Reply With Quote
  #11  
Old June 4th, 2004, 08:49 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
The version 7.2 also has a plugin for VS6. I have it installed, but I have not used it though.
Reply With Quote
  #12  
Old June 4th, 2004, 09:23 AM
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
I do recall reading somewhere that you could build what they were calling OLE stored procs with VB6, but info was so scarce that I did not pursue. There is a good book on procedural SQL langage for DB2 here: http://www.phptr.com/
just search for DB2 and you will find it.

fv
Reply With Quote
  #13  
Old July 21st, 2004, 11:19 AM
anaveens anaveens is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jul 2004
Posts: 5 anaveens User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
db2 resources
publib.boulder.ibm.com/infocenter/db2help/index.jsp
Last edited by Nemi : November 24th, 2006 at 11:06 AM. Reason: made url visible
Reply With Quote
  #14  
Old November 24th, 2006, 08:50 AM
pranavp pranavp is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Nov 2006
Posts: 1 pranavp User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 31 sec
Reputation Power: 0
Lightbulb Reporting for DB2 Express C
Synaptris has released a free reporting software for DB2 Express C users, visit www. synaptris. com/go/expressc for more details and for downloading the software.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > DB2 Development > DB2 Resources

« Previous Thread | Next Thread »