Page 1 of 4 123 ... LastLast
Results 1 to 15 of 59
  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Unanswered: DB2 Resources on the Web

    ***********************************************
    * ALL THESE AND MORE INFO AT www.db2click.com* ************************************************


    Click on these links at your own risk ..

    IBM

    Official DB2 Site

    DB2 Manuals (Look for links to the manuals on this page)

    Certification Page

    Sample Tests

    Redbooks

    DB2 LUW Online Support (Provides links to DB2 LUW Fixpak pages, learning resources, search function on apars, technotes, manuals etc.)

    DB2 ZOS Online Support (Provides links to DB2 ZOS learning resources, search function on apars, technotes, manuals etc.)


    DB2 LUW Information Centre

    DB2 Developer Domain

    New to DB2 ?

    Hints and Tips

    Porting to DB2 ?

    Other resources :

    Newsgroup

    Discussion List(mainly DB2 for OS/390)

    Association of Database Professionals

    User Group

    DB2 OS/390 links

    SQL Cookbook

    Hints and Tips

    Database Related Information

    Perl Scripts & Utlities

    Open Source DB2 Tools

    How-To for DB2

    Site for DB2 Information

    Whitepapers

    Magazines and Journals :

    DB2 Magazine

    IDUG Solutions Journal

    DB2 Times

    DB2 Certification Resources:

    IBM Certification Page

    Certification Information
    (Search for 'Certification Strategies' in for more articles by H Fosdick)

    IBM Recommended Certification Guides

    Study Guides

    Sample Tests (Disable popup blockers whatsoever)

    Online Tutorial for 512

    Online Tutorial for 700

    Online Tutorial for 701

    Tutorials:

    IBM Problem Determination Tutotial



    I'll be posting/adding more links to this section ... If you have any good links, please send them to me by clicking here

    and I'll add them to this list.
    Please let me know if there are any broken links.

    If you feel that any of these links here are not appropriate or should be removed, please let me know by stating a valid reason by clicking here


    Thanks in Advance
    Last edited by sathyaram_s; 01-22-05 at 10:46.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Suggestions

    I'd like to hear suggestions from the users on how to make this forum more useful ....

    And contributions too ...

    Send me a Private Message

    Cheers

    Sathyaram
    Last edited by sathyaram_s; 09-18-03 at 17:35.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    DB2 on Solaris

    A must-read if you are planning to install DB2 on Solaris

    db2ptree tool for Sun Solaris

    From IBM FAQ:
    Q :When installing DB2 on Solaris, my operating system level says SunOS 5.6. The DB2 for Solaris books say my operating system must be Solaris 2.6. Are these the same?

    A: Yes, the operating system for Sun will display a SunOS version 5.x. This is the same as Solaris 2.x. For example, SunOS 5.8 is the same as Solaris 2.8.
    Last edited by sathyaram_s; 09-18-03 at 17:37.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    FAQ

    FAQ Sites:
    IBM FAQ

    FAQ Topics:
    (If a link takes you to www.tek-tips.com , search for the IBM DB2 forum and go to the FAQ section of the discussion)

    BACKUP/RESTORE:

    1) Can the database on one platform be restored on another platform ?

    2) Recovery of Accidentally dropped Tables

    APPLICATION DEVELOPMENT :

    1) SQL Procedure Deployment

    TIPS AND TRICKS:

    1) 'Truncating' a Table

    2) DB2DIAG.LOG

    3) What to expect in V8

    4) Timerons

    5) DB2 Replication Pruning
    Last edited by sathyaram_s; 11-02-03 at 13:17.

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    DB2 on Linux

    IBM Home page for DB2 on Linux :
    http://www-3.ibm.com/software/data/db2/linux/


    How-to fir DB2 Linux Install :
    http://www.ibiblio.org/pub/Linux/doc.../DB2-HOWTO.pdf

    DB2 EE V7.1 Installation Guide for Red Hat Linux

    http://www.cs.yorku.ca/~dfiguero/tech/db2install.html

    Understanding DB2 UDB and DB2 Connect for Linux/390

    http://www.share.org/proceedings/sh98/data/S1361.PDF


    Using DB2 and the DB2 Control Center

    http://www-106.ibm.com/developerwork...ry/l-ss-db2cc/

    Python and DB2 for Linux
    https://www6.software.ibm.com/reg/de...GRlnxw15-DB2DD

    Apache Web Development with IBM DB2 for Linux

    http://www7b.boulder.ibm.com/dmdd/li.../db2linux.html

    Papers for DB2 on Linux:

    http://www.itpapers.com/cgi/SearchIT...ch=db2%20linux

    Up and Running with DB2 on Linux(IBM Redbook)

    http://www.redbooks.ibm.com/pubs/pdf...s/sg246899.pdf

    Hints and Tips for using Graphical Tools:
    http://publib-b.boulder.ibm.com/Redb...a?OpenDocument

    Last edited by sathyaram_s; 04-21-03 at 07:46.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Migrating to DB2 ?

    IBM Migration Homepage : www.ibm.com/db2/migration

    Dev Domain Portal for Migration : http://www7b.software.ibm.com/dmdd/z...ing/index.html

    Leverage your Microsoft SQL Server 2000 Skills to Learn DB2 UDB Version 8 : http://www7b.boulder.ibm.com/dmdd/li...307chong2.html

    Sybase ASE to DB2

    Problems when using MTK ? Email mtk@us.ibm.com

    Last edited by sathyaram_s; 07-23-03 at 12:39.

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Operating System Links for the database person

    Visit the new-look IDUG Website , register to gain access to the excellent content.

  9. #9
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    DB2 Related Tools and Utilities

    I'll be listing both commercial and non-commercial ones for your benefit:

    Graphical Snapshot Monitoring tool

    Perl Scripts & Utlities

    Open Source DB2 Tools

    Aqua Data Studio

    Format your SQL
    Last edited by sathyaram_s; 05-15-05 at 11:04.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  10. #10
    Join Date
    Nov 2002
    Posts
    207

  11. #11
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    IBM publications library : a collection of links to the manuals for almost all IBM products (DB2 for all platforms, AIX, CM, etc.), all on one page.

    http://www.ibm.com/support/publications/us/library/

  12. #12
    Join Date
    Aug 2004
    Posts
    138

  13. #13
    Join Date
    Jun 2005
    Posts
    5

    Thumbs up Powerfull tools for DB2

    Currently DB2 Utils include SQL Query for DB2 - a powerful utility for building and executing queries, Data Pump for DB2 - a wizard application for converting ADO-compatible databases to DB2, Data Export for DB2 - a powerful tool for DB2 data export, and Data Import for DB2 - a utility for quick importing data to DB2 tables.

    http://www.sqlmanager.net/products/db2

  14. #14
    Join Date
    Jul 2005
    Posts
    47
    Sathyaram,

    Thanks for posting so much useful information on DB2. I will surely make use of it. But I found one of the links not working which I need presently
    Papers for DB2 on Linux:
    http://www.itpapers.com/cgi/SearchIT...ch=db2%20linux
    and also its been months that I am looking for sample tests on Exam 701.Self test software have stopped providing them.Do you have any other resource for sample tests.

  15. #15
    Join Date
    May 2006
    Posts
    1

    Thanks..

    thanks a Ton for providing such useful links.

    But I would like to see more stuff on DPF.

    If you could help me out with some reading material on DPF ?

    Regards

    DK.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •