Db2 & pureXML Resources

Here are some useful links to IBM Db2 (mostly LUW) and pureXML, starting with Documentation, Best Practices, Support:

• Db2 Fix packs by version: http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg27007053
• Db2 LUW Information Center (9.7.): http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
• Db2 LUW Information Center (V10): http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/index.jsp
• Db2 LUW Knowledge Center (V10.5): http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.kc.doc/welcome.html?lang=en
• Db2 for z/OS Information Center: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc/db2prodhome.htm 
• Db2 LUW Best Practices: https://ibm.biz/Bdx2ew 
• Db2 LUW Support Information: http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/DB2_for_Linux,_UNIX_and_Windowsm/software/data/db2/support/db2_9/
• DB2 for z/OS Support Information: http://www.ibm.com/software/data/db2/zos/support.html 
• IBM Software Support Feeds for IM products: http://www-01.ibm.com/software/support/rss/db2/
• The DB2Night Show™ with host Scott Hayes, IBM Gold Consultant and IBM Information Management Champion
• Db2-related books on Amazon: DB2 books on Amazon
• IDUG: International DB2 User Group
• IDUG TechLibrary with presentations from past conferences

Some pureXML resources:

• Db2 pureXML Enablement Wiki: https://www.ibm.com/developerworks/wikis/display/db2xml/Home 
• "pureXML Devotees": https://www.ibm.com/developerworks/wikis/display/db2xml/devotee
• How to migrate from CLOB columns to XML-typed columns (this is a FAQ): http://nativexmldatabase.com/2010/10/03/how-to-migrate-xml-from-lob-to-xml-columns/

Db2, JSON, NoSQL, MongoDB:

• Article series on InfoSphere Guardium data security and protection for MongoDB
• Article series on DB2 JSON NoSQL Capabilities

Oracle to Db2 migration:

• DB2 for LUW Application Enablement - Oracle Application Enablement for DB2 for LUW
• Summary article on developerWorks: DB2 10: Run Oracle applications on DB2
• IBM Data Movement Tool: http://www.ibm.com/developerworks/data/library/techarticle/dm-0906datamovement/index.html

Download the free DB2 Express-C and the IBM Data Studio:

• http://www-01.ibm.com/software/data/db2/express/
• http://www.ibm.com/developerworks/downloads/im/data/

Usenet newsgroups (via Google Groups):

• DB2: comp.databases.ibm-db2
• Informix: comp.databases.informix
• Oracle: comp.databases.oracle.server

Bootcamps for your education:

• http://www.ibm.com/developerworks/wikis/display/im/Bootcamps+and+Education

DB2 Family:

• SQL Reference for Cross-Platform Development (DB2): http://www.ibm.com/developerworks/data/library/techarticle/0206sqlref/0206sqlref.html

The epic "Elements vs. attributes" discussion and other XML resources:

• Elements or attributes?

Some information on pureXML and Hibernate:

• Mapping DB2 pureXML data using Hibernate User Types

Temenos T24 on DB2:

• IBM Redpaper: High Availability and Disaster Recovery for Temenos T24 with IBM DB2 and AIX
• IBM PartnerWorld solutions directory: Temenos T24 TAFC R12 with DB2 Workgroup on Linux
• IBM and Temenos T24 Workload Optimization on the new IBM PureFlex System
• Temenos T24 as validated solution on DB2 for z/OS  
• DB2 registry settings for Temenos T24 
• Performance tuning for Temenos T24 on DB2 (Table properties)

Interesting articles on developerWorks:

• XForms and DB2 pureXML

• Processing SEPA payments using DB2 pureXML and WebSphere Transformation Extender
• Build a pureXML and JSON application