Thread: DB2 Resources

Page 1 of 2 12 Last
  • Jump to page:
    #1
  1. Moderator Emeritus
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2002
    Location
    Austin, TX
    Posts
    7,186
    Rep Power
    2265

    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/developerwork...206sqlref.html

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

    - DrGroove
    DrGroove, Devshed Moderator | New to Devshed? Read the User Guide | Connect with me on LinkedIn
  2. #2
  3. No Profile Picture
    Clueless llama
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Feb 2001
    Location
    Lincoln, NE. USA
    Posts
    2,353
    Rep Power
    117
    DB2 Redbooks from IBM are an excellent way to get info on IBM tech

    http://publib-b.boulder.ibm.com/cgi-...rchFuzzy=FALSE
    Last edited by Nemi; May 27th, 2004 at 05:08 PM.
    ~Nemi

    Before posting did you try:
    [ Javadocs | Google ]
  4. #3
  5. No Profile Picture
    Clueless llama
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Feb 2001
    Location
    Lincoln, NE. USA
    Posts
    2,353
    Rep Power
    117
    ~Nemi

    Before posting did you try:
    [ Javadocs | Google ]
  6. #4
  7. Big Endian
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    May 2001
    Location
    Fly-over country
    Posts
    1,172
    Rep Power
    30
    Quest Software has some freeware utilities and versions of their commercial software:

    Quest Central for DB2

    SpotlightŪ on WebSphere
  8. #5
  9. Moderator Emeritus
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2002
    Location
    Austin, TX
    Posts
    7,186
    Rep Power
    2265
    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...
    DrGroove, Devshed Moderator | New to Devshed? Read the User Guide | Connect with me on LinkedIn
  10. #6
  11. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    793
    Just curious, but why even use TOAD or Quest's DB2 tool over IBM's Administration interface?
  12. #7
  13. Moderator Emeritus
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2002
    Location
    Austin, TX
    Posts
    7,186
    Rep Power
    2265

    more resources


    The DB2 Book Suggestions thread also contains valuable links to books, various informational sites, etc.
    DrGroove, Devshed Moderator | New to Devshed? Read the User Guide | Connect with me on LinkedIn
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2003
    Location
    Waco, Texas
    Posts
    636
    Rep Power
    28
    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?)
  16. #9
  17. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    793
    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
  18. #10
  19. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2003
    Location
    Waco, Texas
    Posts
    636
    Rep Power
    28
    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
    ...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?)
  20. #11
  21. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    793
    The version 7.2 also has a plugin for VS6. I have it installed, but I have not used it though.
  22. #12
  23. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2003
    Location
    Waco, Texas
    Posts
    636
    Rep Power
    28
    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
    ...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?)
  24. #13
  25. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2004
    Posts
    5
    Rep Power
    0

    db2 resources


    publib.boulder.ibm.com/infocenter/db2help/index.jsp
    Last edited by Nemi; November 24th, 2006 at 12:06 PM. Reason: made url visible
  26. #14
  27. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2006
    Posts
    1
    Rep 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.
  28. #15
  29. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2008
    Posts
    1
    Rep Power
    0
    I prefer DB2 Maestro, the perfect substitute for TOAD and in some ways also much better product (much cheaper, suberb design and interface, and the support is fast and easy.). I have just pumped an MS SQL database into a DB2 database. All the data including the indexes and foreign keys with just a few clicks.
Page 1 of 2 12 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo