DB2

IBM DB2 est un système de gestion de base de données utilisant le langage SQL. Cette base de donnée est un système propriétaire appartenant à IBM déployé sur les mainframes (DB2 for z/OS), systèmes Linux, Unix et Windows (DB2 LUW). De nombreux outils rendent ce système de base de données très évolutif. [Source : Wikipedia]

Mementos

• DB2 9 SQL Cookbook [Source : Graeme Birchall]

Documentation officielle

Version 9 [Source : IBM]

• DB2 V9R1 for z/OS – What’s New?
• DB2 V9R1 for z/OS – Application Programming & SQL Guide
• DB2 V9R1 for z/OS – Application Programming Guide and Reference for Java
• DB2 V9R1 for z/OS – Codes
• DB2 V9R1 for z/OS – Command Reference
• DB2 V9R1 for z/OS – SQL Reference
• DB2 V9R1 for z/OS – Utility Guide and Reference
• DB2 V9R1 for z/OS – XML Guide

Version 8 [Source : IBM]

• DB2 UDB for z/OS V8 – What’s New?
• DB2 UDB for z/OS V8 – Application Programming & SQL Guide
• DB2 UDB for z/OS V8 – Application Programming Guide and Reference for Java
• DB2 UDB for z/OS V8 – Codes
• DB2 UDB for z/OS V8 – Command Reference
• DB2 UDB for z/OS V8 – SQL Reference
• DB2 UDB for z/OS V8 – Utility Guide and Reference
• DB2 UDB for z/OS V8 – XML Guide

Version 7 [Source : IBM]

• DB2 UDB for OS/390 and z/OS V7 – What’s New?
• DB2 UDB for OS/390 and z/OS V7 – Application Programming & SQL Guide
• DB2 UDB for OS/390 and z/OS V7 – Application Programming Guide and Reference for Java
• DB2 UDB for OS/390 and z/OS V7 – Codes
• DB2 UDB for OS/390 and z/OS V7 – Command Reference
• DB2 UDB for OS/390 and z/OS V7 – SQL Reference
• DB2 UDB for OS/390 and z/OS V7 – Utility Guide and Reference

Redbooks

Version 9

• DB2 9 for z/OS: Using the Utilities Suite
• DB2 9 for z/OS: Resource Serialization and Concurrency Control
• DB2 9 for z/OS: Distributed Functions
• DB2 9 for z/OS: Packages Revisited
• DB2 9 for z/OS: Deploying SOA Solutions
• Enterprise Data Warehousing with DB2 9 for z/OS
• DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond
• Best Practices for SAP BI using DB2 9 for z/OS
• IBM DB2 9 for z/OS: New Tools for Query Optimization
• DB2 9 for z/OS Performance Topics
• Enhancing SAP by Using DB2 9 for z/OS
• DB2 9 for z/OS Technical Overview
• LOBs with DB2 for z/OS: Stronger and Faster

Redpapers

Version 9

• DB2 9 for z/OS: Configuring SSL for Secure Client-Server Communications
• DB2 9 for z/OS: Buffer Pool Monitoring and Tuning
• DB2 9 for z/OS: Backup and Recovery I/O Related Performance Considerations
• DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration
• DB2 for z/OS: Considerations on Small and Large Packages
• Index Compression with DB2 9 for z/OS
• How does the MIDAW Facility Improve the Performance of FICON Channels Using DB2 and other workloads?
• Disk Storage Access with DB2 for z/OS