DB2 Resources

This web page has notes on using DB2.  I'm not a DB2 person and that's why I'm creating this page.  For my reference and maybe it will help you.

Resources

• DB2 UDB - http://www.ibm.com/software/data/  - download a trial version.  Choose DB2 UD from the pick and choose list.  On next web page click on "download" in the left frame.  They may have a Free developer version and a Trial Enterprise version.
• DB2 Developer Domain - http://www7b.software.ibm.com/dmdd/?np-113
• DB2 Newsgroups - http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/newsgroup.d2w/report 
• DB2 User Certification - http://www7b.software.ibm.com/dmdd/library/tutorials/db2cert/db2cert_tut.html - DB2 Certification Preparation Tutorials - Take these six tutorials at your own pace and get ready to certify.

My Notes

• DB2 Installation Notes  
• DB2 Survival Guide - Create Databases, Tables, and SQL Script info.
• DB2 Survival Guild - Return Codes
• Copying Data From MS Access to DB2 - Copy data from MS Access to DB2.
• DB2 DataPropagator - Replicate data from DB2 Databases to other Databases.

JDBC & DB2

• Using the JDBC-ODBC bridge w/Windows
  • driver: sun.jdbc.odbc.JdbcOdbcDriver
  • url example: jdbc:odbc:mydatabase
• Using IBM's drivers w/Windows
  • driver: COM.ibm.db2.jdbc.net.DB2Driver
  • url example: jdbc:db2://localhost/mydatabase
  • Possible Driver location for windows: "c:\Program Files\Sqllib\cc\c2\db2java.zip"

Questions I want answered

• How do you execute an external SQL script while in the "Command Center"?
• If I import a SQL script that I saved while in the Script tab my machine will hang.  Is there a solution?
  • Click on the Script Tab.  Steps: Enter some SQL, Click on "Script, Save Script", now try to import the script.
• Is there a GUI interface to list and edit records in a table similar to MS Access?