Sustainable Software Ltd
Useful links
DB2 Universal Database for Linux,Unix and Windows
IBM update their links with some regularity and do not always redirect. Please report any broken links to feedback
KEY DOCUMENTS AND LIBRARIES
First,some database humour!
IBM Knowledge Center: ALL current DB2 versions plus ALL other IBM software (From Feb 2014 a replacement for Information Centers) - may take some familiarisation!
DB2 V10.5 upgrade roadmap
DB2 10.5 Cancun Release summary
10.5 Information Center, replaced by Knowledge Center
10.1 Information Center, replaced by Knowledge Center
9.8 Information Center, replaced by Knowledge Center
9.7 Information Center, replaced by Knowledge Center
10.5 Infosphere Warehouse Information Center
10.1 Infosphere Warehouse Information Center
9.7 Infosphere Warehouse Information Center
DB2 Documentation Portal
DB2 Best Practices (index)
DB2 Best Practices (alternate link)
DB2 FAQs
DB2 product family
PDF Manuals (all DB2 versions)
Redbooks
IBM Information Management Library
Developerworks technical library
ALEX'S PICK OF USEFUL ARTICLES
DB2 Night Show replays
Ditto, alternate link
Serge Rielau SQL Tips for DB2 LUW
SQL Cookbook (Graeme Birchall)
The SQL Apprentice: a collection of Joe Celko's answers
BLOGROLL
Chris Eaton's blogs
DATABASE DEBUNKINGS is an educational blog
Dave Beulke's blogs, with much wisdom and general principles
Scott Hayes' performance blogs
Serge Rielau's blogs
REFERENCE AND FURTHER EDUCATION
IBM DB2 Technology Review (post-10.5)
developerWorks (index page)
International DB2 Users Group (IDUG) technical library and DB2 Tech Conference Presentation Archive
IDUG DB2 technical channel
IDUG video channel
Other IDUG Links (index page)
IBM Education Assistant - task-based self-study modules
My Notifications - product news, fixes and technotes
DB2 For Linux Redbook
Linux How To for DB2
Validated Linux Environments for DB2
DB2 and Virtualisation (multiple links)
Java for DB2 (9.7 Information Center topic page)
9.7 Release highlights summary
9.7 dated marketing puff
V9.5 Security Redbook
V9.1 Compression Tutorial
Backup Primer
High Availability and Disaster Recovery Redbook
Some interesting stuff from 'The K Guy', particularly around SQL Metaprogramming
TSM Welcome and Manual
Querying the TSM database
TSM return codes header library
TSM Messages
DOS batch help
10.5: BLU and Big Data
Warning: may contain marketing puff and traces of nut
10.5 products and features PDF poster (not for the kids' bedroom)
Intro to BLU (youtube)
Availability announcement
Podcast by Phil Downey, DB2 LUW program director
10.5 What's New
10.5 trial download
BLU migration guide
A list of accompanying 'data management solutions'
Phil Nelson article
The db2guys' take
Triton podcast
Big Data Challenges (Triton)
DOWNLOADS
10.5 trial download
Evaluation trials
Free DB2 Express-C versions
Infosphere Big Insights (Quick start complimentary download)
Infosphere Warehouse (features and trial download)
DB2 upgrade portal (formerly DB2 migration portal)
Product Support, including Fix Packs, APAR lists, alerts and known issues
IBM Data Studio download
IBM Integrated Data Management (Data Studio v3.2, OPM etc.)
Developerworks Technical Resources
Uploads! to IBM Support
TOOLS AND UTILITIES
DBI monitoring and tuning software (home page). Expensive is sometimes cheaper!
SQL PL profiler, brilliant module by Serge Rielau
Information Integration products
Multi-platform tools
Optim Tools - a bag of nails, mostly.
DB Designer 4 (free datamodelling tool, not very DB2-centric)
Visual Paradigm - another free modelling tool, more geared to object-orientation
Small and free DB2 Monitor from Tripod
Rosetta Stone (a sysadmin's unixersal translator for Unix and Linux)
DB2 Editions Recommendation 'Tool'
SQL Formatter,very useful though not always entirely reliable for large queries or Unix/Windows conversion>
SUPPORT
IBM Support Portal home page
IBM Support Portal DB2 home page
IBM Electronic Support site - online tools, tips, and resources
Fix Central
(Broken link:) IBM Support Assistant (automated data collectors)
Service Request Tool (open, track and edit PMRs)
(Broken link:) Online support tools, linking to all above and more
AIX + P Series FAQs
Known issues for DB2/AIX
10.1 Fixlist and APARs
Pisspoor Advantage
