Work with Db2 to write SQL and access databases using optimized code for
the fastest response. This book will give you complete documentation on
DB2 via Python for the IBM_db module and provide a number of examples
for the usage of each module API.
Begin by getting your free version of Db2 for Linux and Windows. While
the book concentrates more on the Linux version of Db2, it also covers
enough of the Windows version so that you're comfortable with obtaining
and installing Db2 on your version of Windows. Next, you'll see how to
install the sample database that comes with Db2, and take some data from
the web to design a database around it, including tables and indexes.
For Db2 to be really useful you need to use strong SQL expressions. This
book provides specific examples of how to avoid using poor ones that can
cause extra processing time for the query. Lastly, you'll look at each
API in the ibm_db and ibm_db_dbi module. This module is not sponsored by
IBM and must be installed separately from the Db2 database.
After reading Foundation Db2 and Python you'll be able to install Db2
on Windows or Linux, and perform backups and restore data.
What You'll Learn
- Obtain and install Db2 properly on Linux and Windows
- Create databases and load them on Db2
- Work with ibm_db and ibm_db_dbi API modules for Python
- Write SQL for Db2
- Review the future of the ibm_db Python module
Who This Book Is For
Python programmers and DB2 administrators interested in building
application with Python and DB2
